Order

Tables (4)

ITEM_MST (아이템 마스터)

  • itemId (아이템id) — number — Primary key — NOT NULL
  • name (이름) — varchar2
  • price (가격) — number
  • stockQuanTity (재고) — number

MEMBER_MST (회원)

  • memberId (멤버id) — number — Primary key — NOT NULL
  • name (이름) — varchar2
  • city (주소1) — varchar2
  • street (주소2) — varchar2
  • zipcode (우편번호) — varchar2
  • orderId (주문id) — number

ORDER_ITEM_MST (주문아이템)

  • orderItemId (주문아이템id) — number — Primary key — NOT NULL
  • itemId (아이템id2) — number — Foreign key → ITEM_MST.itemId — NOT NULL
  • orderId (주문id) — number — Foreign key → ORDER_MST.orderId — NOT NULL
  • memberId (멤버id) — number — Foreign key → ORDER_MST.memberId — NOT NULL

ORDER_MST (주문)

  • orderId (주문id) — number — Primary key — NOT NULL
  • memberId (멤버id) — number — Foreign key → MEMBER_MST.memberId — NOT NULL