ksic_assignment
Tables (6)
audit_logs
- audit_log_id — BIGINT — Primary key — NOT NULL
- actor_user_id — BIGINT — Foreign key → users.user_id
- action_type — VARCHAR(50) — NOT NULL
- target_type — VARCHAR(50) — NOT NULL
- target_id — BIGINT
- request_ip — VARCHAR(45)
- trace_id — VARCHAR(100)
- action_result — VARCHAR(20) — NOT NULL
- description — VARCHAR(500)
- action_at — DATETIME — NOT NULL
password_history
- password_history_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- changed_at — DATETIME — NOT NULL
roles
- role_id — BIGINT — Primary key — NOT NULL
- role_code — VARCHAR(50) — NOT NULL
- role_name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
user_auth
- auth_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- password_changed_at — DATETIME
- login_fail_count — INT — NOT NULL
- locked_until — DATETIME
- last_login_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
user_roles
- user_role_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- role_id — BIGINT — Foreign key → roles.role_id — NOT NULL
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(50)
users
- user_id — BIGINT — Primary key — NOT NULL
- login_id — VARCHAR(50) — NOT NULL
- user_name — VARCHAR(100)
- email — VARCHAR(255)
- email_verified — BOOLEAN — NOT NULL
- email_verified_at — DATETIME
- phone_number — VARCHAR(20)
- phone_verified — BOOLEAN — NOT NULL
- phone_verified_at — DATETIME
- di_value — VARCHAR(255)
- user_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- created_by — VARCHAR(50)
- updated_at — DATETIME
- updated_by — VARCHAR(50)