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)