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