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