Moonge
Tables (9)
Channel (채널)
- channel_id — BIGINT — Primary key — NOT NULL
- community_id — BIGINT — Foreign key → Community.community_id — NOT NULL
- channel_name (이름) — VARCHAR(50) — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
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
- is_deleted (삭제여부) — BOOLEAN — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL
Community (커뮤니티/프로그램)
- community_id — BIGINT — Primary key — NOT NULL
- community_name (이름) — VARCHAR(50) — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
Image (이미지)
- image_id — BIGINT — Primary key — NOT NULL
- original_name (원본이름) — VARCHAR(255) — NOT NULL
- stored_name (저장이름) — VARCHAR(255) — NOT NULL
- s3_image_path (s3 경로) — VARCHAR(512) — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL
- DTYPE (이미지 종류) — VARCHAR(31) — NOT NULL
Member (유저)
- member_id — BIGINT — Primary key — NOT NULL
- community_id — BIGINT — Foreign key → Community.community_id — 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
- kakao_id — BIGINT — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
- updated_at (수정시간) — DATETIME — NOT NULL
MemberImage (프로필 이미지)
- image_id — BIGINT — Foreign key → Image.image_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
Member_Channel (유저&채널)
- member_channel_id (Key) — BIGINT — Primary key — NOT NULL
- channel_id — BIGINT — Foreign key → Channel.channel_id — NOT NULL
- member_id — BIGINT — Foreign key → Member.member_id — NOT NULL
- created_at (생성시간) — DATETIME — NOT NULL
Post (게시물)
- post_id — BIGINT — Primary key — NOT NULL
- channel_id — BIGINT — Foreign key → Channel.channel_id — 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
PostImage (게시물 이미지)
- image_id — BIGINT — Foreign key → Image.image_id — NOT NULL
- post_id — BIGINT — Foreign key → Post.post_id — NOT NULL