ERD
Tables (7)
Copy Of MEMBER_ID (MEMBER)
- Key (MEMBER_ID) — Primary key — NOT NULL
- Field (NAME)
- Field (CITY)
- Field (STREET)
- Field (ZIPCODE)
Untitled (ORDERS)
- Key (ORDER_ID) — Primary key — NOT NULL
- Field (ORDERDATE)
- Field (STATUS)
- Key (DELIVERY_ID) — Foreign key → Untitled.Key — NOT NULL
- Key (MEMBER_ID) — Foreign key → Copy Of MEMBER_ID.Key — NOT NULL
Untitled (DELVERY)
- Key (DELIVERY_ID) — Primary key — NOT NULL
- Field (CITY)
- Field (STREET)
- Field (ZIPCODE)
- Field (STATUS)
Untitled (ORDER_ITEM)
- Key (ORDER_ITEM_ID) — Primary key — NOT NULL
- Field (ORDERPRICE)
- Field (COUNT)
- Key (ORDER_ID) — Foreign key → Untitled.Key — NOT NULL
- Key (ITEM_ID) — Foreign key → Untitled.Key — NOT NULL
Untitled (ITEM)
- Key (ITEM_ID) — Primary key — NOT NULL
- Field (NAME)
- Field (PRICE)
- Field (STOCKQUANTITY)
Untitled (CATEGIRY_ITEM)
- Key (ITEM_ID) — Foreign key → Untitled.Key — NOT NULL
- Key (CATEGORY_ID) — Foreign key → Untitled.Key — NOT NULL
Untitled (CATEGORY)
- Key (CATEGORY_ID) — Primary key — NOT NULL
- Key (PARENT_ID) — Primary key — NOT NULL
- Field (NAME)