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