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