OTP ERD
테이블 (7)
go_config_nodes
- id — BIGINT — 기본 키 — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- has_child — BOOLEAN
- name — VARCHAR(255)
- value — VARCHAR(255)
- value_type — VARCHAR(255)
- config_id — BIGINT
- parent_id — BIGINT — 외래 키 → go_config_nodes.id
go_otp_devices (수정) (CopyOfgo_otp_devices)
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- cert_time — bigint
- auth_code — bigint
- auth_code_generated_at — bigint
- device_id — character
- os_type — character
- device_model — character
- regist_code — character
- registered_at — timestamp
- company_id — bigint — NOT NULL — 제거
- user_id — bigint
- user_otp_id (Key) — bigint — 외래 키 → go_user_otp (신규).id — NOT NULL
go_user_otp (신규) (CopyOfgo_otpadmins)
- id (Key) — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- media_type (auth_type) — character
- user_id (id3) — bigint — 외래 키 → go_users.id — NOT NULL
- status (Field) — character
go_user_otp_auth (신규) (go_otp_mail_auth)
- id (Key) — bigint — 기본 키 — NOT NULL
- email_auth_key (Field) — character
- reset_auth_key (Field2) — character
- verification_valid_until (Field3) — timestamp
- certification_validity_at (Field4) — timestamp
- created_at (Field5) — timestamp
- updated_at (Field6) — timestamp
- user_otp_id (Key2) — bigint — 외래 키 → go_user_otp (신규).id — NOT NULL
go_user_otp_issued (신규) (go_otp_logs)
- id (Key) — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- user_otp_id (Field) — bigint
- media_type (Field2) — character
- seed_key (Field3) — character
- seed_timestamp (Field4) — bigint
- otp_code (Field5) — character
- verification_at (Field7) — timestamp
- auth_fail_count (Field9) — integer
- user_id (Field10) — bigint
- otp_valid_until (Field6) — timestamp
- is_succeed (Field8) — boolean
go_user_profiles
- id — bigint — 기본 키 — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- address — character
- anniversary — timestamp
- birthday — timestamp
- direct_tel — character
- fax — character
- home_page — character
- location — character
- memo — character
- messanger — character
- mobile_no — character
- phone_search_format — character
- rep_tel — character
- self_info — character
- job — character
- grade_id — bigint
- photo_id — bigint
- position_id — bigint
- external_email — character
- custom_user_profile_id — bigint
- lunar_cal — boolean
go_users
- id — bigint — 기본 키 — NOT NULL
- employee_number — character
- locale — character — NOT NULL
- last_logined_at — timestamp
- login_count — integer
- login_fail_count — integer
- login_id — character
- login_locked_at — timestamp
- mail_group — character
- name — character — NOT NULL
- name_hurigana — character
- noti — character
- open_type — character
- password — character — NOT NULL
- password_changed_at — timestamp
- search_name — character
- status — character
- time_zone — character
- use_cert — boolean
- force_to_change_password — boolean
- delayed_pw_change_checked_at — timestamp
- user_profile_id (id2) — bigint — 외래 키 → go_user_profiles.id — NOT NULL