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