jpashop

Tables (7)

Category (category)

  • Category_Id (category_id) — Primary key — NOT NULL
  • Parent_Id (parent_id)
  • Name (name)

Category_Item (category_item)

  • Item Id (item_id2) — Foreign key → Item.Item Id — NOT NULL
  • Category_Id (category_id) — Foreign key → Category.Category_Id — NOT NULL

Delivery (delivery)

  • Delivery Id (delivery_id) — Primary key — NOT NULL
  • Order Id (order_id) — Foreign key → Orders.Order Id — NOT NULL
  • Status (status)
  • City (city)
  • Street (street)
  • Zipcode (zipcode)

Item (item)

  • Item Id (item_id) — Primary key — NOT NULL
  • Name (name)
  • Price (price)
  • Stock Quantity (stock_quantity)
  • DTYPE (dtype)
  • Artist (artist)
  • ETC (etc)
  • Author (author)
  • ISBN (isbn)
  • Director (director)
  • Actor (actor)

Member (member)

  • Member Id (member_id) — Long — Primary key — NOT NULL
  • Name (name)
  • City (city)
  • Street (street)
  • Zipcode (zipcode)

Order_Item (order_item)

  • Order Item Id (order_item_id) — Primary key — NOT NULL
  • Order Id (order_id2) — Foreign key → Orders.Order Id — NOT NULL
  • Item Id (item_id2) — Foreign key → Item.Item Id — NOT NULL
  • Order Price (order_price)
  • Count (count)

Orders (orders)

  • Order Id (order_id) — Primary key — NOT NULL
  • Member Id (member_id) — Long — Foreign key → Member.Member Id — NOT NULL
  • Delivery Id (delivery_id)
  • Order state (order_state)
  • Status (status)