Pay
Supply Chain ER Diagram

Supply Chain ER Diagram

CUSTOMER

PK

CUS_ID


CUS_FNAME

CUS_LNAME

CUS_INITIAL

CUS_ADDRESS

CUS_PHOME

SALE_ID (FK)

INVOICE

PK

INVOICE_ID


M

INVLINE_ID (FK)

CUSTOMER_ID (FK)

EMPLOYEE_ID (FK)

INVOICE_DATE

INVLINE

PK

INLINE_ID

STOCK_ID

PRICEB_VAT

VAT

TOTAL_PRICE

ORDER_ID (FK)

EMPLOYEE

PK

EMP_ID

EMP_FNAME

EMP_LNAME

EMP_INITIAL

EMP_ADDRESS

EMP_PHONE

EMP_DATE_HIRED

EMP_STATUS

EMP_DWORK

EMP_TWORK

EMP_DEP

SALE

PK

SALE_ID

STOCK_ID

CUS_ID (FK)

ORDER

PK

ORDER_ID

ORDER_DATE

ORDER_TIME

EMP_ID (FK)

CUS_ID (FK)

ORDERED ITEM

ORDER_ID (FK)

CUSTOMER_ID (FK)

STOCK_ID (FK)

AMT_ORDERED

STOCK

PK

STOCK_ID

STOCK_NAME

STOCK_ACTEGORY

STOCK_DESC

STOCK_AMT

UNIT_PRICE

SUPP_ID (FK)

SUPPLIER

PK

SUPP_ID

SUPP_FNAME

SUPP_LNAME

SUPP_ADDRESS

SUPP_PHONE

STOCK SUPPLIED

STOCK_ID (FK)

SUPP_ID (FK)

PROMOTIN TITLE

PK

PK

STOCK ID

PRO ID

PROMOTIN

PK

PRO_ID

STOCK_ID (FK)

PRO_TYPE

PRO_REL_DATE

Generates

1

M

1

1

M

M

1

M

Has

Performs

Places

Sells As

M

M

Sold As

M

1

Involves

Refetences

1

M

M

Is

Faatured

as

Features

1

Contains

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

A supply chain entity-relationship (ER) diagram shows that a supply chain is defined as the entire process of making and selling commercial goods, including every stage from the supply of materials and the manufacture of the goods through to their distribution and sale. The below supply chain ER diagram is a graphical approach to database design. It can be designed or created using EdrawMax as it has free templates that make the procedure very compatible. 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