ch06-model3
Tables (7)
CATEGORY (Untitled5)
- CATEGORY_ID (id) — Long — Primary key — NOT NULL
- NAME (name) — String
- (items) — List
- PARENT_ID (parent) — Category
- (child) — List
CATEGORY_ITEM (Untitled6)
- ITEM_ID (Key) — Foreign key → ITEM.ITEM_ID — NOT NULL
- CATEGORY_ID (Key2) — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
DELIVERY (Untitled2)
- DELIVERY_ID (id) — Long — Primary key — NOT NULL
- (order) — Order
- CITY (city) — String
- STREET (street) — String
- ZIPCODE (zipcode) — String
- STATUS (status) — DeliveryStatus
ITEM (Untitled4)
- ITEM_ID (id) — Long — Primary key — NOT NULL
- NAME (name) — String
- PRICE (price) — int
- STOCKQUANTITY (stockQuantity) — int
- (categories) — List
MEMBER (Member)
- MEMBER_ID (id) — Long — Primary key — NOT NULL
- NAME (name) — String
- CITY (city) — String
- STREET (street) — String
- ZIPCODE (zipcode) — String
- (orders) — List
ORDERS (Order)
- ORDER_ID (id) — Long — Primary key — NOT NULL
- MEMBER_ID (member) — Member — Foreign key → MEMBER.MEMBER_ID — NOT NULL
- DELIVERY_ID (delivery) — Delivery — Foreign key → DELIVERY.DELIVERY_ID — NOT NULL
- (orderItems) — List
- ORDERDATE (orderDate) — Date
- STATUS (status) — OrderStatus
ORDER_ITEM (Untitled3)
- ORDER_ITEM_ID (id) — Long — Primary key — NOT NULL
- ORDER_ID (order) — Order — Foreign key → ORDERS.ORDER_ID — NOT NULL
- ITEM_ID (item) — Item — Foreign key → ITEM.ITEM_ID — NOT NULL
- ORDERPRICE (orderPrice) — int
- COUNT (count) — int