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