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