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