ERD GUSINSA
Tables (7)
CATEGORY (Untitled6)
- CATEGORY_ID (Key) — FK — Primary key — NOT NULL
- PARENT_ID (Field) — FK
- NAME (Field2)
CATEGORY_ITEM (Untitled5)
- ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL
- CATEGORY_ID (Key2) — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
DELIVERY_ID (Untitled3)
- DELIVERY_ID (Key) — Primary key — NOT NULL
- CITY (Field)
- STREET (Field2)
- ZIPCODE (Field3)
- STATUS (Field4)
ITEM (Untitled4)
- ITEM_ID (Key) — Primary key — NOT NULL
- NAME (Field)
- PRICE (Field2)
- STOCKQUANTITY (Field3)
MEMBER (Untitled)
- MEMBER ID (MEMBERS_ID) — Primary key — NOT NULL
- NAME (Field)
- CITY (Field2)
- STREET (Field3)
- ZIPCODE (Field4)
ORDERS
- ORDER_ID (MEMBERS_ID) — FK — Primary key — NOT NULL
- MEMBER ID (Key) — FK — Foreign key → MEMBER.MEMBER ID — NOT NULL
- DELIVERY_ID (Key3) — Foreign key → DELIVERY_ID.DELIVERY_ID — NOT NULL
- ORDERDATE (Field)
- STATUS (Field2)
ORDER_ITEM (Untitled2)
- ORDER_ITEM ID (Key) — FK — Primary key — NOT NULL
- ORDERPRICE (Field2)
- ORDER_ID (MEMBERS_ID) — FK — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL
- COUNT (Field)