shopping
Tables (7)
Category (Untitled2)
- CATEGORY_ID (Key) — Long — Primary key — NOT NULL
- name (Field) — String
Category_ITEM (Untitled3)
- CATEGORY_ID (Key) — Long — Foreign key → Category.CATEGORY_ID — NOT NULL
- ITEM_ID (Key2) — Foreign key → ITEM.ITEM_ID — NOT NULL
ITEM (Untitled4)
- ITEM_ID (Key) — Primary key — NOT NULL
- name (Field) — String
- price (Field2) — int
- stockquantity (Field3) — int
- DTYPE (Field4)
- ARTIST (Field5)
- ETC (Field6)
- AUTHOR (Field7)
- ISBN (Field8)
- DIRECTOR (Field9)
- ACTOR (Field10)
Member (회원)
- MEMBER_ID (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- city (Field2) — String
- street (Field3) — String
- zipcode (Field4) — String
OrderItem (Untitled)
- ORDER_ITEM_ID (Key) — Long — Primary key — NOT NULL
- orderPrice (Field) — int
- count (Field2) — int
- ORDER_ID (Key2) — Long — Foreign key → orders.ORDER_ID — NOT NULL
- ITEM_ID (Key3) — Foreign key → ITEM.ITEM_ID — NOT NULL
delivery (배송)
- DELIVER_ID (Key) — Long — Primary key — NOT NULL
- status (Field) — String
- city (Field2) — String
- street (Field3) — String
- zipcode (Field4) — String
- ORDER_ID (Key2) — Long — Foreign key → orders.ORDER_ID — NOT NULL
orders (주문)
- ORDER_ID (Key) — Long — Primary key — NOT NULL
- orderDate (Field) — Date
- status (Field2) — String
- MEMBER_ID (Key2) — Long — Foreign key → Member.MEMBER_ID — NOT NULL