20239384_222
Tables (8)
Comment
- CommentID — INT
- PostID — INT — NOT NULL
- ParentCommentID — INT
- Content — TEXT — NOT NULL
- AuthorID — INT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
Member
- MemberID — INT
- Name — VARCHAR(100) — NOT NULL
- PhoneNumber — VARCHAR(15)
- Email — VARCHAR(255)
- Address — VARCHAR(255)
OrderDetail
- OrderDetailID — INT
- OrderID — INT — NOT NULL
- ProductID — INT — NOT NULL
- Quantity — INT — NOT NULL
OrderHeader
- OrderID — INT
- MemberID — INT — NOT NULL
- OrderDate — DATE — NOT NULL
- ShippingAddress — VARCHAR(255) — NOT NULL
Post
- PostID — INT
- Title — VARCHAR(255) — NOT NULL
- Content — TEXT
- AuthorID — INT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
Product
- ProductID — INT
- ProductName — VARCHAR(100) — NOT NULL
- Stock — INT — NOT NULL
- UnitPrice — DECIMAL(10, 2) — NOT NULL
ProductSupply
- ProductSupplyID — INT
- SupplierID — INT — NOT NULL
- ProductID — INT — NOT NULL
- SupplyDate — DATE — NOT NULL
- Quantity — INT — NOT NULL
Supplier
- SupplierID — INT
- SupplierName — VARCHAR(100) — NOT NULL
- PhoneNumber — VARCHAR(15)
- ContactName — VARCHAR(100)
- Address — VARCHAR(255)