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