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