Test

Tables (9)

Delivery

  • Id — Long — Primary key — NOT NULL
  • city — String
  • order — Order — Foreign key → Order.Id — NOT NULL
  • street — String
  • zipcode — String
  • status — DeliveryStatus

Item

  • Key (Id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Key (categories) — List — Foreign key → Untitled.Key — NOT NULL
  • Field2 (stockQuanity) — int
  • Field2 (price) — int

Member

  • Id (Member_Id) — Long — Primary key — NOT NULL
  • name — String
  • city — String
  • street — String
  • zipcode — String
  • orders — List

Order

  • Id (Order_Id) — Long — Primary key — NOT NULL
  • Member — member — Foreign key → Member.Id — NOT NULL
  • Field (orderItems) — List
  • Field (delivery) — Delivery
  • Field (orderDate) — Date
  • Field (status) — orderStatus

OrderItem

  • Id — Long — Primary key — NOT NULL
  • order — Order — Foreign key → Order.Id — NOT NULL
  • orderPrice — int
  • count — int
  • Key (item) — Item — Foreign key → Item.Key — NOT NULL

Untitled (Category)

  • Key (Id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Key (items) — List — Foreign key → Item.Key — NOT NULL
  • Field2 (parent) — Category
  • Field (child) — List

Untitled (Book)

  • Field (author) — String
  • Field2 (isbn) — String
  • Key (Id) — Long — Foreign key → Item.Key — NOT NULL

Untitled2 (Movie)

  • Field (actor) — String
  • Field2 (dircetor) — String
  • Key (Id) — Long — Foreign key → Item.Key — NOT NULL

Untitled3 (Album)

  • Field (artist) — String
  • Field2 (etc)
  • Key (Id) — Long — Foreign key → Item.Key — NOT NULL