ERD
Tables (7)
CATEGORY (범주)
- CATEGORY_ID (범주아이디) — VARCHAR — Primary key — NOT NULL
- PARENT_ID (부모) — VARCHAR
- NAME (이름) — VARCHAR
CATEGORY_ITEM (범주 아이템)
- CATEGORY_ID(FK) (범주아이디) — VARCHAR — Primary key — NOT NULL
- ITEM_ID(FK) (아이템아이디) — VARCHAR
- CATEGORY_ID (범주아이디2) — VARCHAR — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
- ITEM_ID (아이템ID) — VARCHAR — Foreign key → ITEM.ITEM_ID — NOT NULL
DELIVERY (배달)
- DELIVERY_ID (배달아이디) — VARCHAR — Primary key — NOT NULL
- CITY (지역) — VARCHAR
- STREET (거리) — VARCHAR
- ZIPCODE (우편번호) — VARCHAR
- STATUS (상태) — VARCHAR
ITEM (아이템)
- ITEM_ID (아이템ID) — VARCHAR — Primary key — NOT NULL
- NAME (이름) — VARCHAR
- PRICE (가격) — NUMBER
- STOCKQUANTITY (재고수량) — NUMBER
MEMBER (회원)
- MEMBER_ID (회원) — VARCHAR — Primary key — NOT NULL
- NAME (이름) — VACHAR
- CITY (지역) — VACHAR
- STREET (거리) — VARCHAR
- ZIPCODE (우편번호) — NUMBER
ORDERS (명령)
- ORDER_ID(FK) (명령아이디) — VARCHAR — Primary key — NOT NULL
- MEMBER_ID(FK) (회원아이디) — VARCHAR
- ORDERDATE (주문일) — NUMBER
- STATUS (상태) — VARCHAR
- MEMBER_ID (회원2) — 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
- ITEM_ID(FK) (아이템아이디) — VARCHAR
- ORDER_ID(FK) (주문아이디) — VARCHAR
- ORDERPRICE (주문한가격) — NUMBER
- COUNT (돈을 세다) — NUMBER
- ORDER_ID(FK) (명령아이디) — VARCHAR — Foreign key → ORDERS.ORDER_ID(FK) — NOT NULL
- CATEGORY_ID(FK) (범주아이디) — VARCHAR — Foreign key → CATEGORY_ITEM.CATEGORY_ID(FK) — NOT NULL