ERD
Tables (7)
CATEGORY (Untitled6)
- CATEGORY_ID (Key) — Primary key — NOT NULL
- NAME (ename) — varchar
- PARENT_ID (pid) — varchar — NOT NULL
CATEGORY_ITEM (ITEM_ID)
- ITEM_ID (iid2) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
- CATEGORY_ID (Key) — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
DELIVERY (Untitled4)
- DELIVERY_ID (did) — varchar — Primary key — NOT NULL
- STREET (str) — varchar
- ZIPCODE (zcode) — varchar
- STATUS (status) — varchar
- CITY (city) — varchar — NOT NULL
ITEM (Untitled5)
- ITEM_ID (iid) — varchar — Primary key — NOT NULL
- PRICE (eprice) — number
- STOCKQUANTITY (sto) — varchar
- NAME (ename) — varchar — NOT NULL
MEMBER (Untitled3)
- MEMBER_ID (mid) — varchar — Primary key — NOT NULL
- CITY (Field) — varchar
- STREET (Field2) — varchar
- ZIPCODE (Field3) — varchar
- NAME (ename) — varchar — NOT NULL
ORDER _ITEM (Untitled)
- ORDER_ITEM_ID (oii) — varchar — Primary key — NOT NULL
- ORDERPRICE (oprice) — number
- COUNT (cnt) — number
- ORDER_ID (oid2) — varchar — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (iid2) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
ORDERS (Untitled2)
- ORDER_ID (oid) — varchar — Primary key — NOT NULL
- DELIVERY_ID (Field) — varchar
- ORDERDATE (Field2) — varchar
- STATUS (Field3) — varchar
- MEMBER_ID (mid2) — varchar — Foreign key → MEMBER.MEMBER_ID — NOT NULL