JPA_Shop
Tables (10)
Address (<<Value Type>>)
- city (String)
- street (Integer)
- zipcode
Album (Untitled6)
- artist (Field)
- etc (Field2)
Book (Untitled7)
- author (Field)
- isbn (Field2)
Category (Untitled5)
- id (Key) — Primary key — NOT NULL
- name (Field)
Delivery (Entity5)
- id (Key) — Primary key — NOT NULL
- order (Order) — Foreign key → Order.id — NOT NULL
- id (Member) — Foreign key → Order.id — NOT NULL
- address (Address)
- status (DeliveryStatus)
Item (Untitled3)
- id (Key) — Primary key — NOT NULL
- name (Field)
- price (Field2)
- stockQuantitty (Field3)
- categories (List)
Member (Untitled4)
- id (Key) — Primary key — NOT NULL
- name (Field)
- address (Field2)
- orders (Field3)
Movie (Untitled8)
- director (Field)
- actor (Field2)
Order (Untitled2)
- id (Key) — Primary key — NOT NULL
- id (Member) — Foreign key → Member.id — NOT NULL
- orderDate (Date)
- status (OrderStatus)
OrderItem (Untitled)
- id (Key) — Primary key — NOT NULL
- item (Item) — Foreign key → Item.id — NOT NULL
- id (Key2) — Foreign key → Order.id — NOT NULL
- id (Member) — Foreign key → Order.id — NOT NULL
- orderPrice (Field)
- count (Field2)