ch04-model1
Tables (4)
ITEM_ID (Item)
- ITEM_ID (id) — Long — Primary key — NOT NULL
- NAME (name) — String
- PRICE (price) — int
- STOCKQUANTITY (stockQuantity) — int
MEMBER (Member)
- MEMBER_ID (id) — Long — Primary key — NOT NULL
- NAME (name) — String
- CITY (city) — String
- STREET (street) — String
- ZIPCODE (zipcode) — String
ORDERS (Order)
- ORDER_ID (id) — Long — Primary key — NOT NULL
- MEMBER_ID (memberId) — Long — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- ORDERDATE (orderDate) — Date
- STATUS (status) — OrderStatus
ORDER_ITEM (OrderItem)
- ORDER_ITEM_ID (id) — Long — Primary key — NOT NULL
- ORDER_ID (orderId) — Long — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (itemId) — Long — Foreign key → ITEM_ID.ITEM_ID — NOT NULL
- ORDERPRICE (orderPrice) — int
- COUNT (count) — int