JPA
Tables (6)
Item (Untitled4)
- id (Key) — NOTNULL — Primary key — NOT NULL
- categories (Key2) — NOTNULL — Foreign key → Untitled6.id — NOT NULL
- name (Field)
- price (Field2)
- stockQuantity (Field3)
Member (Untitled)
- ID (Key) — NOTNULL — Primary key — NOT NULL
- name (FILED)
- city (Field2)
- street (Field3)
- zipcode (Field)
Order (Untitled2)
- id (Key) — NOTNULL — Primary key — NOT NULL
- MemberID (Key3) — NOTNULL — Foreign key → Member.ID — NOT NULL
- orderDate (Field)
- status (Field2)
OrderItem (Untitled3)
- id (Key) — NOTNULL — Primary key — NOT NULL
- orderId (Key3) — NOTNULL — Foreign key → Order.id — NOT NULL
- ItemId (Key2) — NOTNULL — Foreign key → Item.id — NOT NULL
- id (Key22) — NOTNULL — Foreign key → Item.categories — NOT NULL
- orderPirce (Field)
- count (Field2)
Untitled5
- id (Key) — NOTNULL — Primary key — NOT NULL
- order (Key2) — NOTNULL — Foreign key → Order.id — NOT NULL
- city (Field2)
- street (Field3)
- zipcode (Field4)
- status (Field)
Untitled6
- id (Key) — NOTNULL — Primary key — NOT NULL
- name (Field) — NOTNULL
- items (Field2) — NOTNULL
- parent (Field3)
- child (Field4) — NOTNULL