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