20239384-1111

Tables (8)

Comments

  • comment_id — INT
  • question_id — INT — NOT NULL
  • customer_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • parent_comment_id — INT

Customers

  • customer_id — INT
  • name — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • email — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255)

Manufacturers

  • manufacturer_id — INT
  • name — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20)
  • manager_name — VARCHAR(255)
  • address — VARCHAR(255)

OrderItems

  • order_item_id — INT
  • order_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL

Orders

  • order_id — INT
  • customer_id — INT — NOT NULL
  • order_date — DATETIME — NOT NULL
  • delivery_address — VARCHAR(255) — NOT NULL

ProductSupplies

  • supply_id — INT
  • manufacturer_id — INT — NOT NULL
  • product_id — INT — NOT NULL
  • supply_date — DATE — NOT NULL
  • supply_quantity — INT — NOT NULL

Products

  • product_id — INT
  • name — VARCHAR(255) — NOT NULL
  • stock_quantity — INT — NOT NULL
  • unit_price — DECIMAL(10, 2) — NOT NULL

Questions

  • question_id — INT
  • customer_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL