kun-shopping mall

Tables (8)

Order (Untitled3)

  • id (Key) — not null — Primary key — NOT NULL
  • number (Field) — not null
  • cost (Field2) — not null
  • date (Field3) — not null
  • status (Field4) — not null
  • address (Field5) — not null
  • phone (Field6) — not null
  • email (Field7) — not null
  • user_id (Key2) — not null — Foreign key → User.id — NOT NULL

Order_Product (Untitled4)

  • id (Key) — not null — Primary key — NOT NULL
  • quantity (Field2) — not null
  • order_id (Key2) — not null — Foreign key → Order.id — NOT NULL
  • product_id (Key3) — not null — Foreign key → Product.id — NOT NULL

Product (Untitled2)

  • id (Key) — not null — Primary key — NOT NULL
  • name (Field) — not null
  • price (Field2) — not null
  • inventory (Field3) — not null
  • purchase (Field4) — not null
  • content (Field5) — null
  • product_category_id (Key2) — not null — Foreign key → Product Category.id — NOT NULL

Product Answer (Untitled10)

  • id (Key) — not null — Primary key — NOT NULL
  • title (Field) — not null
  • content (Field2) — null
  • date (Field3) — not null
  • product_question_id (Key2) — not null — Foreign key → Product Question.id — NOT NULL

Product Category (Untitled5)

  • id (Key) — not null — Primary key — NOT NULL
  • name (Field) — not null

Product Question (Untitled9)

  • id (Key) — not null — Primary key — NOT NULL
  • title (Field) — not null
  • content (Field2) — null
  • date (Field3) — not null
  • status (Field4) — not null
  • user_id (Key3) — not null — Foreign key → User.id — NOT NULL
  • product_id (Key2) — not null — Foreign key → Product.id — NOT NULL

Product Review (Untitled8)

  • id (Key) — not null — Primary key — NOT NULL
  • title (Field3) — not null
  • content (Field) — null
  • date (Field2) — not null
  • user_id (Key2) — not null — Foreign key → User.id — NOT NULL
  • product_id (Key3) — not null — Foreign key → Product.id — NOT NULL

User (Untitled)

  • id (Key) — not null — Primary key — NOT NULL
  • name (Field) — not null
  • password (Field2) — not null
  • address (Field3) — not null
  • phone (Field4) — not null
  • email (Field5) — not null