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)