MEMBER_info
Tables (7)
CATEGORY (Untitled5)
- CATEGORY_ID — varchar — Primary key — NOT NULL
- NAME — varchar
- PARENT_ID — varchar
CATEGORY_ITEM (Untitled7)
- CATEGORY_ID — varchar — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- ITEM_ID — varchar — Foreign key → ITEM.ITEM_ID — NOT NULL
DEDLIVERY (Untitled4)
- 주문번호 (DELIVERY_ID) — int — Primary key
- 시 (CITY) — varchar — NOT NULL
- 주소 (STREET) — varchar
- ZIPCODE — varchar
- 현황 (STATUS) — varchar
ITEM (Untitled6)
- ITEM_ID — varchar — Primary key — NOT NULL
- 제품명 (NAME) — varchar
- 가격 (PRICE) — int
- 재고수량 (STOCKQUANTITY) — int
MEMBER (Untitled3)
- MEMBER_Id — varchar — Primary key — NOT NULL
- 이름 (NAME) — varchar
- CITY — varchar
- STREET — varchar
- Field
ORDERS (ORDER_ID)
- 주문번호 (ORDER_ID) — int — Primary key — NOT NULL
- MEMBER_Id — varchar — Foreign key → MEMBER.MEMBER_Id — NOT NULL
- 주문번호 (DELIVERY_ID) — int — Foreign key → DEDLIVERY.주문번호
- 주문일 (ORDERDATE) — Date
- 현황 (STATUS) — varchar
ORDER_ITEM (Untitled)
- ORDER_ITEM_ID — varchar — Primary key — NOT NULL
- 주문번호 (ORDER_ID) — int — Foreign key → ITEM.ITEM_ID — NOT NULL
- 제품명 (ITEM_ID) — int — Foreign key → ORDERS.주문번호 — NOT NULL
- ORDERPRICE (ODERPRICE) — int
- COUNT — int