ch07-model4
Tables (10)
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
- DTYPE (Field)
- ARTIST (artist)
- ETC (etc)
- AUTHOR (author)
- ISBN (isbn)
- DIRECTOR (director)
- ACTOR (actor)
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