Spring study
Tables (7)
Album (Category_Item)
- Key (Cid) — Long — Foreign key → Untitled.Key — NOT NULL
- Key (Iid) — Long — Foreign key → Category.Key — NOT NULL
Category (Item)
- Key (Iid) — Long — Primary key — NOT NULL
- Field (name) — String
- Field (StockQuantity)
- Field (categories) — List
- Field (ItemType)
Delivery
- Did (Key) — Long — Primary key — NOT NULL
- order (Field) — Order
- address (Field2) — Adress
- status (Field3) — DeliveryStatus
Member
- id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- address (Field2) — Adress
- orders (Field3) — List
Order
- Oid (Key) — Long — Primary key — NOT NULL
- id (Member) — Long — Foreign key → Member.id — NOT NULL
- OrderDate (Field) — Date
- status (Field2) — OrderStatus
- Did (Delivery) — Long — Foreign key → Delivery.Did — NOT NULL
OrderItem
- Oid (Key) — Long — Foreign key → Order.Oid — NOT NULL
- Field (OderPrice) — Int
- Field (Count) — Int
- Key (Iid) — Long — Foreign key → Category.Key — NOT NULL
Untitled (Category)
- Key (Cid) — Long — Primary key — NOT NULL
- Field (name) — String
- Field (items) — List
- Field (child) — List
- Key (Pid) — Category — Foreign key → Untitled.Key — NOT NULL