go_otp

Tables (8)

go_companies

  • id — bigint — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • algorithm_name — character
  • company_quota — bigint
  • delete_user_count — integer
  • deleted_at — timestamp
  • domain_name — character — NOT NULL
  • locale — character — NOT NULL
  • manager_name — character
  • name — character — NOT NULL
  • online_user_count — integer
  • stop_user_count — integer
  • total_account_quota — bigint
  • used_count — integer
  • user_count — integer
  • wait_user_count — integer
  • site_url — character
  • mail_domain_seq — bigint
  • company_group_id — bigint
  • group_depth — integer
  • manager_id — character
  • uuid — character

go_config_nodes

  • id (Key) — Primary key — NOT NULL
  • config_id (Key2) — Foreign key → go_configs.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • has_child — boolean
  • name — character
  • value — character
  • value_type — character
  • config_id — bigint
  • parent_id — bigint

go_configs

  • id (Key) — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp

go_otp_devices

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • cert_time — bigint
  • auth_code — character
  • auth_code_generated_at — timestamp
  • device_id — character
  • os_type — character
  • device_model — character
  • regist_code — character
  • registered_at — timestamp
  • company_id — bigint — Foreign key → go_companies.id
  • user_id — bigint — Foreign key
  • external_secret_key (Field) — string

go_otpadmins

  • id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • external_email — character
  • email_auth_key — character
  • certification_validity_time — timestamp
  • verification_time — timestamp
  • is_email_verified — boolean — NOT NULL

go_users

  • id (Key2) — Primary key — NOT NULL
  • config_id (Key) — Foreign key → go_configs.id — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp
  • 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
  • company_id — bigint
  • mail_user_seq — bigint
  • user_profile_id — bigint
  • user_push_setting_id — bigint
  • use_cert — boolean
  • user_integration_id — bigint
  • force_to_change_password — boolean
  • user_web_noti_setting_id — bigint
  • user_mobile_noti_setting_id — bigint
  • user_mail_noti_setting_id — bigint
  • user_noti_setting_id — bigint
  • fixed_ip — character
  • delayed_pw_change_checked_at — timestamp

mail_admin

  • company_id — bigint — Foreign key → go_companies.id — NOT NULL
  • mail_user_seq — bigint — Foreign key → mail_user.mail_user_seq — NOT NULL
  • adm_graph — character
  • adm_language — character
  • adm_login_time — character
  • adm_pagebase — bigint
  • adm_privileges — character
  • adm_timeout — bigint
  • adm_type — character
  • removable — boolean — NOT NULL
  • otpadmin_id (Key) — VARCHAR(255) — Foreign key → go_otpadmins.id — NOT NULL
  • id (Key2) — Foreign key — NOT NULL
  • Key2 (Key22) — Foreign key — NOT NULL

mail_user

  • mail_user_seq — bigint — NOT NULL
  • account_disabled_date — character
  • account_dormant_date — character
  • account_expire_date — character
  • account_status — character
  • account_status_admin — character
  • auto_reply_end_time — character
  • auto_reply_include — character
  • auto_reply_mode — character
  • auto_reply_start_time — character
  • auto_reply_subject — character
  • auto_reply_text — text
  • company_id — bigint — NOT NULL
  • delivery_mode — character
  • delivery_noti_mode — character
  • delivery_noti_type — character
  • forwarding_mode — character
  • forwarding_use — character
  • hidden_forwarding_mode — character
  • inbox_expire_days — character
  • mail_add_quota — character
  • mail_domain_seq — bigint — NOT NULL
  • mail_etc_services — integer
  • mail_group_seq — bigint — NOT NULL
  • mail_host — character
  • mail_max_send_size — character
  • mail_password — character
  • mail_sender_use — character
  • mail_services — bigint
  • mail_uid — character — NOT NULL
  • max_send_mail_count — character
  • max_send_mail_count_use — character
  • message_store — character
  • quota_overlook_ratio — character
  • quota_violation_action — character
  • quota_warning_mode — character
  • quota_warning_ratio — character
  • send_allow_mode — character
  • sent_expire_days — character
  • spam_expire_days — character
  • trash_expire_days — character
  • user_expire_days — character
  • user_type — character