anal_server

Tables (15)

LOGIN_LOGS (로그인 이력)

  • login_log_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id
  • login_id — varchar(50)
  • success_yn — boolean
  • fail_reason — varchar(50)
  • ip_address — varchar(50)
  • login_at (logint_at) — datetime

emai_verification (이메일인증)

  • email_verification_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id
  • tier_id — bigint — Foreign key → user.tier_id — NOT NULL
  • role_id — bigint — Foreign key → user.role_id — NOT NULL
  • login_id — varchar
  • email — varchar
  • auth_code — varchar
  • verfication_status (Field) — varchar
  • expired_at — datetime
  • verfied_at — datetime
  • created_at — datetime
  • updated_at — datetime

menus (메뉴)

  • menu_id — bigint — Primary key — NOT NULL
  • parent_menu_id — bigint
  • menu_code — varchar
  • menu_name — varchar
  • menu_path — varchar
  • sort_order — int
  • visible_yn — boolean
  • use_yn — boolean
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar

password (패스워드)

  • password_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id
  • tier_id (tier_id2) — bigint — Foreign key → user.tier_id — NOT NULL
  • role_id (role_id2) — bigint — Foreign key → user.role_id — NOT NULL
  • password_encrypted — varchar(255)
  • password_changed_at — datetime
  • must_change_password_yn — boolean
  • account_locked_at — datetime
  • created_at — datetime
  • created_by — varchar(50)
  • updated_at — datetime
  • updated_by — varchar(50)

password_change_history (패스워드 변경이력)

  • password_history_id — bigint — Primary key — NOT NULL
  • password_id — bigint — Foreign key → password.password_id — NOT NULL
  • user_id — bigint — Foreign key → password.user_id
  • tier_id (tier_id2) — bigint — Foreign key → password.tier_id — NOT NULL
  • role_id (role_id2) — bigint — Foreign key → password.role_id — NOT NULL
  • password_encrypted — varchar(255)
  • change_type — varchar(50)
  • update_at — datetime
  • update_by — varchar(50)

role (역할)

  • role_id — bigint — Primary key — NOT NULL
  • role_code — varchar
  • role_name — varchar
  • role_description — text
  • use_yn — boolean
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updeated_by (updated_by) — varchar

role_change_history (역할정책변경이력)

  • role_historyid (role_history_id) — bigint — Primary key — NOT NULL
  • role_id — bigint — Foreign key → role.role_id — NOT NULL
  • role_code — varchar
  • role_name — varchar
  • use_yn — boolean
  • change_type — varchar
  • change_reason — text
  • changed_at (change_at) — datetime
  • changed_by — varchar

role_menu_permission (역할별메뉴관리)

  • role_menu_perm_id — bigint — Primary key — NOT NULL
  • menu_id — bigint — Foreign key → menus.menu_id — NOT NULL
  • role_id — bigint — Foreign key → role.role_id — NOT NULL
  • visible_yn (visible_vn) — boolean
  • access_yn — boolean
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar

role_screen_permissions (역할별화면관리)

  • role_screen_perm_id — bigint — Primary key — NOT NULL
  • role_id — bigint — Foreign key → role.role_id — NOT NULL
  • screen_id — bigint — Foreign key → screens.screen_id — NOT NULL
  • menu_id — bigint — Foreign key → screens.menu_id — NOT NULL
  • access_yn — boolean
  • created_atc (created_at) — datetime
  • updated_at — datetime

screens (화면)

  • screen_id — bigint — Primary key — NOT NULL
  • menu_id — bigint — Foreign key → menus.menu_id — NOT NULL
  • screen_code — varchar
  • screen_name — varchar
  • screen_path — varchar
  • visible_yn — boolean
  • description — text
  • use_yn — boolean
  • created_at — datetime
  • updated_at — datetime

sign_up_request (회원가입요청관리)

  • signup_request_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id
  • signup_request_uuid — uuid — 유니크
  • login_id — varchar
  • user_name — varchar
  • email — varchar
  • password_encrypted — varchar — 승인완료되면 비밀번호 테이블에 생성된 후 null 처리
  • request_status — varchar
  • processed_at — datetime
  • reject_reason — text
  • created_at — datetime
  • created_by — varchar
  • updated_at — datetime
  • updated_by — varchar

tier (사용자등급)

  • tier_id — bigint — Primary key — NOT NULL
  • tier_code — varchar(50)
  • tier_name — varchar(50)
  • daily_chat_request_limit — int(4)
  • use_yn — boolean
  • created_at — datetime
  • created_by — varchar(50)
  • updated_at — datetime
  • updated_by — varchar(50)

tier_change_history (등급정책변경이력)

  • tier_change_id — bigint — Primary key — NOT NULL
  • tier_id — bigint — Foreign key → tier.tier_id — NOT NULL
  • tier_code — varchar(50)
  • tier_name — varchar(50)
  • daily_chat_request_limit — int
  • limit_yn — boolean
  • change_type — varchar(50)
  • change_reason — text
  • changed_by — varchar(50)
  • changed_at — datetime

user (유저)

  • user_id — bigint — Primary key
  • tier_id — bigint — Foreign key → tier.tier_id — NOT NULL
  • role_id — bigint — Foreign key → role.role_id — NOT NULL
  • user_uuid — uuid — 유니크 키
  • login_id — varchar(50) — 유니크 키
  • user_name — varchar(50)
  • email — varchar(100)
  • account_status — varchar(50)
  • created_at — datetime
  • created_by — varchar(50)
  • updated_at — datetime
  • updated_by — varchar(50)

user_history (유저변경이력)

  • user_history_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.user_id
  • tier_id (tier_id2) — bigint — Foreign key → user.tier_id — NOT NULL
  • role_id (role_id2) — bigint — Foreign key → user.role_id — NOT NULL
  • email — varchar(100)
  • account_status — varchar(50)
  • changed_type — varchar(50)
  • changed_reason — text
  • created_at — datetime
  • created_by — varchar(50)