ㄴㄴㄴ
Tables (8)
Comment
- CommentID — INT
- QuestionID — INT
- MemberID — INT
- Content — TEXT — NOT NULL
- CreationDate — DATETIME — NOT NULL
Manufacturer
- ManufacturerID — INT
- ManufacturerName — VARCHAR(100) — NOT NULL
- Phone — VARCHAR(15)
- ContactPerson — VARCHAR(100)
- Address — VARCHAR(255)
Member
- MemberID — INT
- Name — VARCHAR(100) — NOT NULL
- Phone — VARCHAR(15)
- Email — VARCHAR(100)
- Address — VARCHAR(255)
Order
- OrderID — INT
- MemberID — INT
- DeliveryAddress — VARCHAR(255)
- OrderDate — DATE — NOT NULL
OrderDetail
- OrderDetailID — INT
- OrderID — INT
- ProductID — INT
- Quantity — INT — NOT NULL
Product
- ProductID — INT
- ProductName — VARCHAR(100) — NOT NULL
- Stock — INT — NOT NULL
- UnitPrice — DECIMAL(10, 2) — NOT NULL
ProductManufacturer
- ProductID — INT
- ManufacturerID — INT
Question
- QuestionID — INT
- Title — VARCHAR(255) — NOT NULL
- MemberID — INT
- CreationDate — DATETIME — NOT NULL