ERD
Tables (7)
CAREGORY_ITEM (CopyOfCopyOfUntitled22)
- CATEGORY_ID (Key2) — Foreign key → CATEGOET.CATEGORY_ID — NOT NULL
- ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL
CATEGOET (CopyOfCopyOfCopyOfUntitled22)
- CATEGORY_ID (Key) — Primary key — NOT NULL
- PARENT_ID (FK) (Field)
- NAME (Field2)
DELIVERY (CopyOfCopyOfUntitled2)
- DELIVERY_ID (Key) — Primary key — NOT NULL
- CITY (Field)
- STREET (Field2)
- ZIPCODE (Field3)
- STATUS (Field4)
ITEM (CopyOfUntitled2)
- ITEM_ID (Key) — Primary key — NOT NULL
- NAME (Field)
- PRICE (Field2)
- STOCKQUANTITY (Field3)
MEMBER (CopyOfCopyOfUntitled)
- MEMBER_ID (Key) — Primary key — NOT NULL
- NAME (Field)
- CITY (Field2)
- STREET (Field3)
- ZIPCODE (Field4)
ORDERS (CopyOfUntitled)
- ODER_ID (Key) — Primary key — NOT NULL
- MEMBER_ID (Key4) — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- DELIVERY_ID (Key2) — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
- ORDERDATE (Field3)
- STATUS (Field4)
ORDER_ITEM_ID (Untitled)
- ODER_ITEM_ID (Key) — Primary key — NOT NULL
- ODER_ID (Key2) — Foreign key → ORDERS.ODER_ID — NOT NULL
- ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE (Field3)
- COUNT (Field4)