KCS - 커뮤니티 ERD
테이블 (4)
게시글 (post)
- post_id — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
- owner_id — BIGINT — 외래 키 → 회원.member_id — NOT NULL — REFERENCES member (member_id)
- title — VARCHAR(255) — NOT NULL
- contents — LONGTEXT — NOT NULL
- thumbnail — VARCHAR(255)
- is_visible — BOOLEAN
- created_at — DATETIME(6)
댓글 (comment)
- comment_id — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
- owner_id — BIGINT — 외래 키 → 회원.member_id — NOT NULL — REFERENCES member (member_id)
- post_id — BIGINT — 외래 키 → 게시글.post_id — NOT NULL — REFERENCES post (post_id)
- contents — LONGTEXT — NOT NULL
- is_visible — BOOLEAN
- created_at — DATETIME(6)
세션 (sessions)
- session_id — VARCHAR(128) — 기본 키 — NOT NULL
- expires — INT(11) — NOT NULL
- data — TEXT
회원 (member)
- member_id — BIGINT — 기본 키 — NOT NULL — AUTO_INCREMENT
- email — VARCHAR(255) — NOT NULL — UNIQUE
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL — UNIQUE
- profile_image — VARCHAR(255)
- is_active — BOOLEAN
- created_at — DATETIME(6)