jpa

Tables (7)

category (Untitled4)

  • category_id (Key) — Primary key — NOT NULL
  • name (Field)

category_item (Untitled5)

  • category_id (Key) — Primary key — NOT NULL
  • item_id (Field)

delivery (Untitled7)

  • status (Key) — Primary key — NOT NULL
  • city (Field)
  • street (Field2)
  • zipcode (Field3)

item (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • price (Field2)
  • stockquantity (Field3)
  • dtype (Field4) — a
  • artist (Field5)
  • etc (Field6)
  • author (Field7)
  • isbn (Field8)
  • director (Field9)
  • actor (Field10)

member (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • city (Field2)
  • street (Field3)
  • zipcode (Field4)

order_item (Untitled6)

  • order_id (Key) — Primary key — NOT NULL
  • item_id (Field)
  • orderprice (Field2)
  • count (Field3)

orders (Untitled3)

  • member_id (Key) — Primary key — NOT NULL
  • orderdate (Field) — s
  • status (Field2)