Moonge v1.0
Tables (3)
Comment (댓글)
- comment_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → Post.post_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- parent_comment_id — BIGINT — Foreign key → Comment.comment_id
- comment_content (내용) — TEXT — NOT NULL
- depth (깊이) — INT — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL
Member (유저)
- member_id — BIGINT — Primary key — NOT NULL
- role (역할) — VARCHAR(50) — NOT NULL
- course (과정) — VARCHAR(50) — NOT NULL
- member_name (한국 이름) — VARCHAR(50) — NOT NULL
- member_name_english (영어 이름) — VARCHAR(50) — NOT NULL
- email (이메일) — VARCHAR(255)
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL
Post (게시물)
- post_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- post_title (제목) — VARCHAR(255) — NOT NULL
- post_content (내용) — TEXT — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL