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