0620 Mission
Tables (7)
CATEGORY (Untitled7)
- 카테고리ID (CATEGORY_ID) — varchar2 — Primary key — NOT NULL
- 카테고리이름 (NAME) — varchar2
CATEGORY_ITEM (Untitled6)
- 카테고리ID (CATEGORY_ID) — varchar2 — Foreign key → CATEGORY.카테고리ID — NOT NULL
- 상품ID (ITEM_ID) — varchar2 — Foreign key → ITEM.상품ID — NOT NULL
DELIVERY (Untitled3)
- 아이디 (DELIVERY_ID) — varchar2 — Primary key — NOT NULL
- 도시 (CITY) — varchar2
- 지번 (STREET) — varchar2
- 우편번호 (ZIPCODE) — number
- 상세주소 (STATUS) — varchar2
ITEM (Untitled5)
- 상품ID (ITEM_ID) — varchar2 — Primary key — NOT NULL
- 상품이름 (NAME) — varchar2
- 상품가격 (PRICE) — number
- 재고수량 (STOCKQUANTITY) — number
MEMBER (Untitled)
- 아이디 (MEMBER_ID) — varchar2 — Primary key — NOT NULL
- 이름 (NAME) — varchar2
- 도시 (CITY) — varchar2
- 지번 (STREET) — varchar2
- 우편번호 (ZIPCODE) — number
ORDERS (Untitled2)
- 주문아이디 (ORDER_ID) — varchar2 — Primary key — NOT NULL
- 아이디 (MEMBER_ID) — varchar2 — Foreign key → MEMBER.아이디 — NOT NULL
- 아이디 (DELIVERY_ID) — varchar2 — Foreign key → DELIVERY.아이디 — NOT NULL
- 주문날짜 (ORDERDATE) — date
- 상세주소 (STATUS) — varchar2
ORDER_ITEM_ID (Untitled4)
- 상품ID (ORDER_ITEM_ID) — varchar2 — Primary key — NOT NULL
- 주문아이디 (ORDER_ID) — varchar2 — Foreign key → ORDERS.주문아이디 — NOT NULL
- 상품ID (ITEM_ID2) — varchar2 — Foreign key → ITEM.상품ID — NOT NULL
- 상품가격 (ORDERPRICE) — number
- 갯수 (COUNT) — number