TCK 파일럿 발표용
테이블 (7)
app_user
- user_id — varchar(50) — 기본 키 — NOT NULL
- password_hash — varchar(255)
- user_name — varchar(100) — NOT NULL
- email — varchar(200)
- phone — varchar(30)
- role_code — varchar(30) — 외래 키 → role_master.role_code — NOT NULL
- user_status — varchar(20) — NOT NULL
- last_login_at — timestamptz
- password_changed_at — timestamptz
- deleted_at — timestamptz
- deleted_reason — varchar(500)
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
board_post
- post_id — bigserial — 기본 키 — NOT NULL
- author_user_id — varchar(50) — 외래 키 → app_user.user_id — NOT NULL
- title — varchar(200) — NOT NULL
- content — text — NOT NULL
- importance_level — integer — NOT NULL
- view_count — integer — NOT NULL
- like_count — integer — NOT NULL
- post_status — varchar(20) — NOT NULL
- deleted_at — timestamptz
- deleted_by — varchar(50) — 외래 키 → app_user.user_id
- 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) — 외래 키 → app_user.user_id — NOT NULL
- created_at — timestamptz — NOT NULL
login_history
- history_id — bigserial — 기본 키 — NOT NULL
- user_id — varchar(50) — 외래 키 → app_user.user_id
- login_type — varchar(30) — NOT NULL
- action_type — varchar(30) — NOT NULL
- client_ip — varchar(60)
- user_agent — varchar(300)
- success_yn — char(1) — NOT NULL
- fail_reason — varchar(500)
- created_at — timestamptz — NOT NULL
menu_master
- menu_id — bigserial — 기본 키 — NOT NULL
- parent_menu_id — bigint — 외래 키 → menu_master.menu_id
- menu_code — varchar(50) — NOT NULL
- menu_name — varchar(100) — NOT NULL
- menu_url — varchar(300)
- display_order — integer — NOT NULL
- use_yn — char(1) — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
role_master
- role_code — varchar(30) — 기본 키 — NOT NULL
- role_name — varchar(100) — NOT NULL
- use_yn — char(1) — NOT NULL
- sort_order — integer — NOT NULL
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz — NOT NULL
role_menu_map
- role_code — varchar(30) — 외래 키 → role_master.role_code — NOT NULL
- menu_id — bigint — 외래 키 → menu_master.menu_id — NOT NULL
- created_at — timestamptz — NOT NULL