free-board

테이블 (5)

Untitled (comment_likes_mapping)

  • Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL
  • Key (comment_id) — Int — 외래 키 → 댓글.Key — NOT NULL
  • Field (created_date) — DateTime

Untitled (post_likes_mapping)

  • Key (post_id) — Int — 외래 키 → 게시글.Key — NOT NULL
  • Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL
  • Field (created_date) — DateTime

게시글 (post)

  • Key (post_id) — Int — 기본 키 — NOT NULL
  • Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL — post_id, member_id 인덱스 설정
  • Field (type) — Varchar — FREE, FOOD, TRAVEL, SPORT
  • Field (title) — Varchar
  • Field (content) — Varchar
  • Field (views) — Int
  • Field (likes) — Int
  • Field (hidden_yn) — TinyInt
  • Field (created_date) — DateTime
  • Field (modified_date) — DateTime

댓글 (comment)

  • Key (comment_id) — Int — 기본 키 — NOT NULL
  • Key (post_id) — Int — 외래 키 → 게시글.Key — NOT NULL — (comment_id, post_id) 인덱스
  • Key (member_id) — int — 외래 키 → 회원.Key — NOT NULL — (comment_id, member_id) 인덱스
  • Field (parent_comment_id) — Int
  • Field (content) — Varchar
  • Field (likes) — Int
  • Field (hidden_yn) — TinyInt
  • Field (created_date) — DateTime
  • Field (modified_date) — DateTime

회원 (member)

  • Key (member_id) — int — 기본 키 — NOT NULL
  • Field (user_id) — Varchar — UNIQUE
  • Field (password) — Varchar
  • (nick_name) — Varchar — UNIQUE
  • Field (created_date) — DateTime
  • Field (modified_date) — DateTime