jpaShop

Tables (7)

Delivery (Untitled3)

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

Item (Untitled4)

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

Member (Untitled)

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

Order_item (Untitled5)

  • order_item_id (Key) — Primary key — NOT NULL
  • order_id (Key2) — Foreign key → Orders.order_id — NOT NULL
  • item_id (Key3) — Foreign key → Item.item_id — NOT NULL
  • order_price (Field)
  • orderprice (Field2)
  • count (Field3)

Orders (Untitled2)

  • order_id (Key) — Primary key — NOT NULL
  • member_id (Key2) — Foreign key → Member.member_id — NOT NULL
  • delivery_id (Key3) — Foreign key → Delivery.delivery_id — NOT NULL
  • orderdate (Field)
  • date (Field2)

category (Untitled6)

  • category_id (Key) — Primary key — NOT NULL
  • parent_id (Key2) — Foreign key → category.category_id — NOT NULL
  • name (Field)

category_item (Untitled7)

  • category_id (Key) — Foreign key → category.category_id — NOT NULL
  • item_id (Key2) — Foreign key → Item.item_id — NOT NULL