Memberinfo
Tables (7)
CATEGORY (Untitled5)
- CATEGORY_ID (category_id) — varchar — Primary key — NOT NULL
- PARENT_ID (parent_id) — varchar
- NAME (name) — varchar
CATEGORY_ITEM (Untitled7)
- Field2
- Field
- CATEGORY_ID (category_id) — varchar — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- ITEM_ID (item_id) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
DELIVERY (Untitled3)
- DELIVERY_ID — varchar — Primary key — NOT NULL
- CITY (city) — varchar
- STREET (street) — varchar
- ZIPCODE (zipcode) — varchar
- STATUS (status) — varchar
ITEM (Untitled6)
- ITEM_ID (item_id) — varchar — Primary key — NOT NULL
- NAME (name) — varchar
- PRICE (price) — varchar
- STOCKQUANTITY (stockquantity) — varchar
MEMBER_ID (Untitled)
- MEMBER_ID (member_id) — varchar — Primary key — NOT NULL
- NAME — varchar
- CITY (city) — varchar
- STREET (street) — varchar
- ZIPCODE (zipcode) — varchar
ORDERS_ID (Untitled2)
- ORDER_ID (order_id) — varchar — Primary key — NOT NULL
- ORDERDATE (orderdate) — date
- STATUS (status) — varchar
- MEMBER_ID (member_id) — varchar — Foreign key → MEMBER_ID.MEMBER_ID — NOT NULL
- DELIVERY_ID — varchar — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
ORDER_ITEM (Untitled4)
- ORDER_ITEM (order_item) — varchar — Primary key — NOT NULL
- ORDER{RICE (orderprice) — num
- COUNT (count) — vatchar
- ORDER_ID (order_id) — varchar — Foreign key → ORDERS_ID.ORDER_ID — NOT NULL
- ITEM_ID (item_id) — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL