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