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