게시판 ERD

테이블 (6)

board_comment

  • comment_id — bigserial — 기본 키 — NOT NULL
  • post_id — bigint — 외래 키 → board_post.post_id — NOT NULL
  • author_user_id — varchar(50) — 외래 키 → user_info.user_id — NOT NULL
  • content — text — NOT NULL
  • comment_status — varchar(20) — NOT NULL
  • deleted_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

board_post

  • post_id — bigserial — 기본 키 — NOT NULL
  • author_user_id — varchar(50) — 외래 키 → user_info.user_id — NOT NULL
  • title — varchar(200) — NOT NULL
  • content — text — NOT NULL
  • view_count — integer — NOT NULL
  • like_count — integer — NOT NULL
  • post_status — varchar(20) — NOT NULL
  • deleted_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

board_post_like

  • post_id — bigint — 외래 키 → board_post.post_id — NOT NULL
  • user_id — varchar(50) — 외래 키 → user_info.user_id — NOT NULL

login_history

  • history_id — bigserial — 기본 키 — NOT NULL
  • user_id — varchar(50) — 외래 키 → user_info.user_id
  • login_type — varchar(30) — NOT NULL
  • action_type — varchar(30) — NOT NULL
  • success_yn — char(1) — NOT NULL
  • fail_reason — varchar(500)

role_master

  • role_code — varchar(30) — 기본 키 — NOT NULL
  • role_name — varchar(100) — NOT NULL
  • use_yn — char(1) — NOT NULL

user_info

  • user_id — varchar(50) — 기본 키 — NOT NULL
  • user_pw — varchar(255) — NOT NULL
  • user_nm — varchar(100) — NOT NULL
  • zip_code — varchar(10)
  • address1 — varchar(100)
  • address2 — varchar(100)
  • email — varchar(100) — NOT NULL
  • email_auth_yn — char(1) — NOT NULL
  • role_code — varchar(30) — 외래 키 → role_master.role_code — NOT NULL
  • auth_type — varchar(30) — NOT NULL
  • jsession_id — varchar(100)
  • user_status — varchar(20) — NOT NULL
  • deleted_at — timestamptz