Basketball_Village

Tables (6)

bookmark

  • bookmark_id — NOT NULL — Primary key — NOT NULL
  • user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
  • post_id — NOT NULL — Foreign key → post.post_id — NOT NULL

post

  • post_id — NOT NULL — Primary key — NOT NULL
  • user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
  • 제목 (title) — NOT NULL
  • 조회수 (view_cnt) — NOT NULL
  • 본문 (content) — NOT NULL
  • 생성일자 (created_at) — NOT NULL
  • 수정일자 (modified_at) — NULLABLE
  • 좋아요수 (like_cnt) — NOT NULL

post_like

  • post_like_id — NOT NULL — Primary key — NOT NULL
  • post_id — NOT NULL — Foreign key → post.post_id — NOT NULL
  • user_id — NOT NULL — Foreign key → user.user_id — NOT NULL

reply

  • reply_id — NOT NULL — Primary key — NOT NULL
  • user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
  • post_id — NOT NULL — Foreign key → post.post_id — NOT NULL
  • 본문 (content) — NOT NULL
  • 생성일자 (created_at) — NOT NULL
  • 수정일자 (modified_at) — NULLABLE
  • 좋아요수 (like_cnt) — NOT NULL

reply_like

  • reply_like_id — NOT NULL — Primary key — NOT NULL
  • user_id — NOT NULL — Foreign key → user.user_id — NOT NULL
  • reply_id — NOT NULL — Foreign key → reply.reply_id — NOT NULL

user

  • user_id — NOT NULL — Primary key — NOT NULL
  • name — NOT NULL
  • email — NOT NULL
  • password — NOT NULL
  • 역할 (role) — NOT NULL
  • 생성일자 (created_at) — NOT NULL
  • 개인정보수정일자 (modified_at) — NULLABLE