MemberINFO
Tables (7)
CATEGORY
- CATEGORY_ID — varchar — Primary key — NOT NULL
- PARENT_ID — varchar
- NAME — varchar
CATEGORY_ITEM
- CATEGORY_ID — varchar — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
DELIVERY
- DELIVERY_ID — varchar — Primary key — NOT NULL
- CITY — varchar
- STREET — varchar
- ZIPCODE — varchar
- STATUS — varchar
ITEM
- ITEM_ID — varchar — Primary key — NOT NULL
- NAME — varchar
- PRICE — int
- STOCKQUANTITY — int
MEMBER
- MEMBER_ID — varchar — Primary key — NOT NULL
- NAME — varchar
- CITY — varchar
- STREET — varchar
- ZIPCODE — varchar
ORDERS
- ORDER_ID — varchar — Primary key — NOT NULL
- MEMBER_ID — varchar — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- DELIVERY_ID — varchar — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
- ORDERDATE — date
- STATUS — varchar
ORDER_ITEM
- ORDER_ITEM_ID — varchar — Primary key — NOT NULL
- ORDER_ID — varchar — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE — int
- COUNT — int