Software Database ER Diagram
Use immediately

Software Database ER Diagram

ARF_CATEGORY

PK,I1

ID

U1





FK1,U2

NCATEGORY_ID

NAME

NAME_EN

DESCRIPTION

DESCRIPTION_EN

PARENT_CAT_ID

REECORD_LAST_UPDATE

RECORED_START_DATE

MOST_RECENT

DELETED


ARF_LINE_ITEM

PK,I1

LINE_ITEM_ID


U1

U12

FK6,U19

FK2,U20

FK1,U21

U22

U14

FK4,U11

FK5,U13

U23

U24

FK3,U25

U2

U3

U4

U5

U6

U9

U8


U7

U15


U10



























U16

U17

U18

SUBMIT_TIMESTAMP

SUBMIT_DAY_ID

SUBMIT_TIME_ID

SKU_ID

PRODUCT_ID

CATEGORY_ID

CUSTOMER_ID

AGENT_ID

ORIGNT_SALE_CHANNEL_ID

SUBMIT_SALE_CHANNEL_ID

STIMGRP_ID

SEGCLSTR_ID

PROMOGRP_ID

BILLING_REGION_ID

SHIPPING_REGION_ID

LOCAL_CURRENCY_ID

DEMOGRAPHIC_ID

SITE_VISIT_ID

ORDER_ID

NORDER_ID

NLINE_ITEM_ID

SESSION_ID

QUESTION_ID

QUANTITY

IS_MARKDOWN

LOCAL_UNIT_PRICE

LOCAL_GROSS_REVENUE

LOCAL_DISCOUNT_AMOUNT

LOCAL_MARKDOWN_DISC_AMOUNT

LOCAL_ORDER_TAX_ALLOC

LOCAL_ORDER_SHIPPING_ALLOC

LOCAL_ORDER_DISCOUNT_ALLOC

LOCAL_NET_REVENUE

LOCAL_ORDER_NET_REVENUE

LOCAL_APPSMT_DBT_ALLOC_AMT

LOCAL_APPSMT_CDT_ALLOC_AMT

LOCAL_PRICE_OVERRIDE_AMT

STANDARD_UNIT_PRICE

STANDARD_GROSS_REVENUE

STANDARD_DISCOUNT_AMOUNT

STANDARD_MARKDOWN_DISC_AMOUNT

STANDARD_ORDER_TAX_ALLOC

STANDARD_ORDER_SHIPPING_ALLOC

STANDARD_ORDER_DISCOUNT_ALLOC

STANDARD_NET_REVENUE

STANDARD_ORDER_NET_REVENUE

STANDARD_APPSMT_DBT_ALLOC_AMT

STANDARD_APPSMT_CDT_ALLOC_AMT

STANDARD_PRICE_OVERRIDE_AMT

STANDARD_APPSMT_DBT_ALLOC_AMT

STANDARD_APPSMT_CDT_ALLOC_AMT

STANDARD_PRICE_OVERRIDE_AMT

SUBMITTED_SITE_ID

ITEM_SITE_ID

ARF_PRODUCT

PK,I1

ID

U1





FK1,U2

NCATEGORY_ID

NAME

NAME_EN

DESCRIPTION

DESCRIPTION_EN

PARENT_CAT_ID

BRAND

BRAND_EN

REECORD_LAST_UPDATE

RECORED_START_DATE

RECORED_END_DATE

MOST_RECENT

DELETED


ARF_SKU

PK,I1

ID

U1





FK1,U2

NSKU_ID

NAME

NAME_EN

DESCRIPTION

DESCRIPTION_EN

PARENT_PROD_ID

WHOLESALE_PRICE

LIST_PRICE

SALE_PRICE

ON_SALE

REECORD_LAST_UPDATE

RECORED_START_DATE

RECORED_END_DATE

MOST_RECENT

DELETED

ARF_PROMOGRP

PK,I1

ID

U1

NAME

HASH_VALUE

LENGTH

ARF_PROMOGRP_MBRS

PK,FK1,I1

PK,FK2,U1,I1

PROMOGRP ID

PROMOTION ID

ARF_PROMOTION

PK,I1

ID

U1

NPROMO_ID

PROMO_NAME

PROMO_NAME_EN

PROMO_DESC

PROMO_DESC_EN

PROMO_TYPE

PROMO_ENABLED

PROMO_BEGIN_USABLE

PROMO_END_USABLE

PROMO_GLOBAL

RECORD_LAST_UPDATE

RECORD_START_DATE

RECORD_END_DATE

MOST_RECENT

DELETED

ARF_SALES_CHANNEL

PK,I1

ID

NCODE

NAME

NAME_EN

DESCRIPTION

DESCRIPTION_EN

ARF_RETURN_ITEM

PK,I1

RETURN_ITEM_ID


U1

U5

FK4,U6

FK1,U7

U8

U10


U11





FK3,U2

U9

FK2,U12

U3

U4

SUBMIT_TIMESTAMP

SUBMIT_DAY_ID

SUBMIT_TIME_ID

SKU_ID

PRODUCT_ID

CUSTOMER_ID

LOCAL_CURRENCY_ID

NRETURN_ID

NOTIGINAL_ORDER_ID

NEXCHANGE_ORDER_ID

NRETURN_ITEM_ID

QUANTITY

EXCHANGE

RETURN_REASON_CHANNEL_ID

AGENT_ID

RETURN_REASON_ID

ITEM_SITE_ID

SUBMITTED_SITE_ID

LOCAL_ITEM_REFUND

LOCAL_TOTAL_REFUND

LOCAL_TOTAL_ADJ_ALLOC

LOCAL_SHIPPING_REFUND_ALLOC

LOCAL_TAX_REFUND_ALLOC

LOCAL_OTHER_REFUND_ALLOC

LOCAL_RETURN_FEE_ALLOC

STD_ITEM_REFUND

STD_TOTAL_REFUND

STD_TOTAL_ADJ_ALLOC

STD_SHIPPING_REFUND_ALLOC

STD_TAX_REFUND_ALLOC

STD_OTHER_REFUND_ALLOC

STD_RETURN_FEE_ALLOC

ARF_CURRENCY_CONV

PK,I1

PK, U1,I1

PK,U2,I1

DAY ID

SRC CURRENCY ID

DST CURRENCY ID

SRC_DST_CONV_RATE

DST_SRC_CONV_RATE

ARF_RET_REASON_DISPOSITION

PK,I1

ID

NREASON_ID

DESCRIPTION

DESCRIPTION_EN

DISPOSITION

31
0
0
publish time: 2021-06-04
Captain O Captain

Creating a software database entity-relationship (ER) diagram is extremely important when working with the software team. It should be noted here that ERM is a graphical approach to database design. It can be designed or created using EdrawMax or EdrawMax Online as it has several predefined templates that make designing such ERM diagrams very easy. The following ER diagram has entities like ARF_Category, ARF_Promogrp, ARF_Promogrp_MBRS, ARF_Promotion, ARF_Line_Item, ARF_Sales_Channel. It is a high-level data model that defines data elements and their relationship for a specified software system. At the same time, an affiliation exists between various qualities of an element. A Relationship between two properties demonstrates that the estimations of the related characteristics are associated.

See More Related Templates

ER Diagram from Dilshan
This is an ER diagram that I made, hope you can like it!
ER Diagram from Dilshan
22
0
0
DILSHAN SACHINDRA