week06
Tables (5)
BID
- 입찰 (bid_id) — NOT NULL — Primary key — NOT NULL
- Field
COMMENT
- 댓글아이디 (comment_id) — NOT NULL — Primary key — NOT NULL
- 댓글 (comment) — NOT NULL
- 생성일자 (createdAt) — NOT NULL
- 수정일자 (modifiedAt) — NOT NULL
- 상품아이디 (product_id) — NOT NULL — Foreign key → PRODUCT.상품아이디 — NOT NULL
- 멤버아이디 (member_id) — NOT NULL — Foreign key → Member.멤버아이디 — NOT NULL
LIKE
- 관심 상품 (like_id) — NOT NULL — Primary key — NOT NULL
- 멤버아이디 (member_id) — NOT NULL — Foreign key → Member.멤버아이디 — NOT NULL
Member
- 멤버아이디 (member_id) — NOT NULL — Primary key — NOT NULL
- 아이디 (username) — NOT NULL
- 비밀번호 (password) — NOT NULL
- 생성일자 (createdAt) — NOT NULL
- 수정일자 (modifiedAt) — NOT NULL
PRODUCT
- 상품아이디 (product_id) — NOT NULL — Primary key — NOT NULL
- 상품명 (title) — NOT NULL
- 이미지 (image) — NOT NULL
- 내용 (content) — NOT NULL
- 최저입찰가 (lowprice) — NOT NULL
- 최고입찰가 (highprice) — NOT NULL
- 생성일자 (createdAt) — NOT NULL
- 수정일자 (modifiedAt) — NOT NULL
- 관심 상품 (like_id) — NOT NULL — Foreign key → LIKE.관심 상품 — NOT NULL
- 멤버아이디 (member_id) — NOT NULL — Foreign key → Member.멤버아이디 — NOT NULL