wef
Tables (8)
category (Untitled4)
- category_id (Key) — Primary key — NOT NULL
- parent_id (Key2) — Primary key — NOT NULL
- name (Field)
category_item (Untitled5)
- item_id (Key) — Foreign key → item.item_id — NOT NULL
- category_id (Key2) — Foreign key → category.category_id — NOT NULL
delivery (Untitled3)
- delivery_id (Key) — Primary key — NOT NULL
- status (Field)
- city (Field2)
- street (Field3)
- zipcode (Field4)
item (Untitled6)
- item_id (Key) — Primary key — NOT NULL
- name (Field)
- price (Field2)
- stockquantity (Field3)
- dtype (Field4)
member (Untitled)
- member_id (Key2) — Primary key — NOT NULL
- name (Field)
- city (Field2)
- street (Field3)
- zipcode (Field4)
order_item (Untitled7)
- order_item_id (Key) — Primary key — NOT NULL
- order_id (-) — Foreign key → orders.order_id — NOT NULL
- item_id (Key4) — Foreign key → item.item_id — NOT NULL
- orderprice (Field)
- count (Field2)
orders (Untitled2)
- order_id (-) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
- delivery_id (Key) — Foreign key → delivery.delivery_id — NOT NULL
- orderdate (Field)
- status (Field2) — enum
review (Untitled8)
- review_id (Key) — Primary key — NOT NULL
- order_item_id (Key2) — Foreign key → order_item.order_item_id — NOT NULL
- rating (Field)
- comment (Field2)