ERD
Tables (7)
CATEGORY (CATEGORY_ID)
- PARENT_ID(FK) — varchar — Primary key — NOT NULL
- NAME — varchar
DELIVERY (DELIVERY_ID)
- CITY — varchar — Primary key — NOT NULL
- STREET — varchar
- ZIPCODE — number
- STATUS — varchar
- MEMBER_ID(FK) — varchar — Foreign key → OPDERS.MEMBER_ID(FK) — NOT NULL
ITEM (ITEM_ID)
- NAME — varchar — Primary key — NOT NULL
- PRICE — number
- STOCKQUNTITY — varchar
MEMBER (MEMBER_ID)
- NAME — varchar — Primary key — NOT NULL
- CITY — varchar
- STREET — varchar
- ZIPCODE — number
OPDERS (ORDER_ID)
- MEMBER_ID(FK) — varchar — Primary key — NOT NULL
- DELIVERY_ID(FK) — varchar
- ORDERDATE — date
- STATUS — varchar
- NAME — varchar — Foreign key → MEMBER.NAME — NOT NULL
ORDER_ITEM (ORDER_ITEM_ID)
- ORDER_ID(FK) — varchar — Primary key — NOT NULL
- ITEM_ID(FK) — varchar
- ORDERPRICE — number
- COUNT — number
- MEMBER_ID(FK) — varchar — Foreign key → OPDERS.MEMBER_ID(FK) — NOT NULL
- NAME — varchar — Foreign key → ITEM.NAME — NOT NULL
Untitled
- CATEGORY_ID(FK) — varchar — Primary key — NOT NULL
- NAME — varchar — Foreign key → ITEM.NAME — NOT NULL
- PARENT_ID(FK) — varchar — Foreign key → CATEGORY.PARENT_ID(FK) — NOT NULL
- ITEM_ID(FK) — varchar