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