MemberInfo
Tables (7)
CATEGORY (카테고리)
- CATEGORY_ID — VARCHAR — Primary key — NOT NULL
- PARENT_ID — VARCHAR
- NAME — VARCHAR
CATEGORY_ITEM (상품카테고리)
- ITEM_ID — VARCHAR — Foreign key → ITEM.ITEM_ID — NOT NULL
- CATEGORY_ID — VARCHAR — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
DELIVERY (배송)
- DELIVERY_ID — VARCHAR — Primary key — NOT NULL
- CITY — VARCHAR
- STREET — VARCHAR
- ZIPCODE — CHAR
- STATUS — VARCHAR
ITEM (상품)
- ITEM_ID — VARCHAR — Primary key — NOT NULL
- NAME — VARCHAR
- PRICE — NUMBER
- STOCKQUANTITY — NUMBER
MEMBER
- MEMBER_ID — VARCHAR — Primary key — NOT NULL
- NAME — VARCHAR
- CITY — VARCHAR
- STREETS (STREEET) — VARCHAR
- ZIPCODE — CHAR
ORDERS (주문)
- ORDER_ID — VARCHAR — Primary key — NOT NULL
- ORDERDATE — DATE
- STATUS — VARCHAR
- MEMBER_ID — VARCHAR — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- DELIVERY_ID — VARCHAR — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
ORDER_ITEM (주문상품)
- ORDER_ITEM_ID — VARCHAR — Primary key — NOT NULL
- ORDERPRICE — NUMBER
- COUNT — NUMBER
- ORDER_ID — VARCHAR — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID — VARCHAR — Foreign key → ITEM.ITEM_ID — NOT NULL