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)