otp2
Tables (3)
go_domain_admins
- id — BIGINT — Primary key — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- last_logined_at — TIMESTAMP
- page_base — INTEGER
- company_id — BIGINT
- user_id — BIGINT
- otp_admin_id (Key) — Foreign key → go_otpadmins.id — NOT NULL
go_otp_devices
- id — BIGINT — Primary key — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- cert_time — BIGINT
- auth_code — VARCHAR(20)
- auth_code_generated_at — TIMESTAMP
- device_id — VARCHAR(50)
- os_type — VARCHAR(20)
- device_model — VARCHAR(128)
- regist_code — VARCHAR(20)
- registered_at — TIMESTAMP
- company_id — BIGINT
- user_id — BIGINT
- auth_type — VARCHAR(32) — NOT NULL
go_otpadmins
- id (Key) — Primary key — NOT NULL
- mail_user_id — BIGINT — NOT NULL
- company_id — BIGINT — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- external_email — VARCHAR(255)
- email_auth_key — VARCHAR(255)
- reset_auth_key — VARCHAR(255)
- certification_validity_time — TIMESTAMP
- verification_time — TIMESTAMP
- last_otp_auth_time — TIMESTAMP
- is_email_verified — BOOLEAN — NOT NULL
- auth_type — VARCHAR(32)
- used — BOOLEAN — NOT NULL