06.20 ERD
Tables (6)
CATEGORY
- CATEGORY_ID — NUMBER — Primary key
- PARENT_ID — NUMBER
- NAME — VARCHAR(50)
CATEGORY_ITEM
- CATEGORY_ID — NUMBER — Foreign key → CATEGORY.CATEGORY_ID
- ITEM_ID — NUMBER — Foreign key
DELIVERY
- DELIVERY_ID — VARCHAR(20 — Primary key
- CITY — VARCHAR(50)
- STREET — VARCHAR(50)
- ZIPCODE — VARCHAR(10)
- STATUS — VARCHAR(20)
MEMBER
- MEMBER_ID — NUMBER — Primary key
- NAME — VARCHAR(50)
- CITY — VARCHAR(50)
- STREET — VARCHAR(50)
- ZIPCODE — VARCHAR(10)
ORDERS
- ORDER_ID — NUMBER — Primary key
- MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID
- DELIVERY_ID — VARCHAR(20 — Foreign key → DELIVERY.DELIVERY_ID
- ORDERDATE — DATE
- STATUS — VARCHAR(20)
ORDER_ITEM
- ORDER_ITEM_ID — NUMBER — Primary key
- ITEM_ID — NUMBER — Foreign key
- ORDER_ID — NUMBER — Foreign key → ORDERS.ORDER_ID
- ORDERPRICE — NUMBER
- COUNT — NUMBER