jpashop

Tables (7)

Untitled (member)

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

Untitled (item)

  • Key (item_id) — Primary key — NOT NULL
  • Field (name)
  • Field (price)
  • Field (stock_quantity)
  • Field (dtype)
  • Field (artist)
  • Field (etc)
  • Field (author)
  • Field (isbn)
  • Field (director)
  • Field (actor)

Untitled (orders)

  • Key (order_id) — Primary key — NOT NULL
  • Key (member_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (delivery_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (orderdate)
  • Field (status)

Untitled (delivery)

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

Untitled (order_item)

  • Key (order_item_id) — Primary key — NOT NULL
  • Key (order_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (item_id) — Foreign key → Untitled.Key — NOT NULL
  • Field (orderprice)
  • Field (count)

Untitled (category)

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

Untitled (category_item)

  • Key (category_id) — Foreign key → Untitled.Key — NOT NULL
  • Key (item_id) — Foreign key → Untitled.Key — NOT NULL