defmodule DaProductApp.Repo.Migrations.CreateRiskAuditLog do
  use Ecto.Migration

  def change do
    create table(:risk_audit_log) do
      add :event_type, :string, null: false  # 'supervisor_action', 'rule_updated', 'system_event'
      add :user_id, :bigint
      add :resource_type, :string  # 'risk_rule_hit', 'risk_rule'
      add :resource_id, :bigint
      add :action, :string  # 'release', 'hold', 'request_docs', 'rule_enable', etc.
      add :old_values, :json
      add :new_values, :json
      add :ip_address, :string
      add :user_agent, :text
      add :notes, :text
      add :metadata, :json

      timestamps(type: :utc_datetime)
    end

    create index(:risk_audit_log, [:event_type])
    create index(:risk_audit_log, [:user_id])
    create index(:risk_audit_log, [:resource_type, :resource_id])
    create index(:risk_audit_log, [:action])
    create index(:risk_audit_log, [:inserted_at])
  end
end