게시판 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