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)