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