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)