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