goott
Tables (7)
CATEGORY (Untitled4)
- CATEGORY_ID — varchar — Primary key — NOT NULL
- NAME — varchar
CATEGORY_ITEM (Untitled5)
- CATEGORY_ID — varchar — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
DELIVERY (Untitled2)
- DELIVERY_ID — varchar — Primary key — NOT NULL
- CITY — varchar
- STREET — varchar
- ZIPCODE — number
- STATUS — varchar
ITEM (Untitled6)
- ITEM_ID — varchar — Primary key — NOT NULL
- NAME — varchar
- PRICE — number
- STOCKQUANTITY — number
MEMBER (ID)
- MEMBER_ID (MID) — varchar — Primary key — NOT NULL
- NAME (Field2) — varchar
- CITY — varchar
- STREET — varchar
- ZIPCODE — NUMBER
ORDERS (Untitled)
- ORDER_ID (OID) — varchar — Primary key — NOT NULL
- MEMBER_ID (MID) — varchar — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- DELIVERY_ID — varchar — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
- ORDERDATE — DATE
- STATUS — varchar
ORDER_ITEM_ID (Untitled3)
- ORDER_ITEM_ID (OITEM) — varchar — Primary key — NOT NULL
- ORDER_ID (OID) — varchar — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE — number
- COUNT — number