ERD_한수민
테이블 (7)
CAREGORY_ITEM (category_item)
- CATEGORY_iD (category_id) — INT — 외래 키 → CATEGORY.CATEGORY_iD — NOT NULL
- ITEM_ID (item_id) — INT — 외래 키 → ITEM.ITEM_ID — NOT NULL
CATEGORY (category)
- CATEGORY_iD (category_id) — INT — 기본 키 — NOT NULL
- PARENT_ID (parent_id) — INT
- NAME (name) — VARCHAR
DELIVERY (delivery)
- DELIVERY_ID (delivery_id) — INT — 기본 키 — NOT NULL
- CITY (city) — VARCHAR
- STREET (street) — VARCHAR
- ZIPCODE (zipcode) — INT
- STATUS (status) — VARCHAR
ITEM (item)
- ITEM_ID (item_id) — INT — 기본 키 — NOT NULL
- NAME (name) — VARCHAR
- PRICE (price) — INT
- STOCKQUANTITY (stockquantity) — INT
MEMBER (member)
- MEMBER_ID (member_id) — INT — 기본 키 — NOT NULL
- NAME (name) — VARCHAR
- CITY (city) — VARCHAR
- STREET (street) — VARCHAR
- ZIPCODE (zipcode) — INT
ORDERS (orders)
- ORDER_ID (order_id) — INT — 기본 키 — NOT NULL
- MEMBER_ID (member_id) — INT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
- DELIVERY_ID (delivery_id) — INT — 외래 키 → DELIVERY.DELIVERY_ID — NOT NULL
- ORDERDATE (orderdate) — DATE
- STATUS (Field) — VARCHAR
ORDER_ITEM (order_item)
- ODER_ITEM_ID (order_item_id) — INT — 기본 키 — NOT NULL
- ORDER_ID (order_id) — INT — 외래 키 → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (item_id2) — INT — 외래 키 → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE (orderprice) — INT
- COUNT (count) — INT