김희정
테이블 (8)
Comment
- CommentID — INT — 기본 키
- PostID (PostID2) — INT — 외래 키 → Post.PostID
- 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
- MemberID (MemberID2) — INT — 외래 키 → Member.MemberID
Post
- PostID — INT — 기본 키
- Title — VARCHAR(255) — NOT NULL
- Content — TEXT
- AuthorID — INT — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- MemberID — INT — 외래 키 → Member.MemberID
Product
- ProductID — INT — 기본 키
- ProductName — VARCHAR(100) — NOT NULL
- Stock — INT — NOT NULL
- UnitPrice — DECIMAL(10, 2) — NOT NULL
- OrderDetailID — INT — 외래 키 → OrderDetail.OrderDetailID
- ProductSupplyID — INT — 외래 키 → ProductSupply.ProductSupplyID
- OrderID — INT — 외래 키 → OrderHeader.OrderID
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)
- ProductSupplyID — INT — 외래 키 → ProductSupply.ProductSupplyID