defmodule DaProductApp.Schemas.ShukriaMms.KycRequest do
  use Ecto.Schema
  import Ecto.Query

  @primary_key {:id, :id, autogenerate: true}
  schema "kyc_requests" do
    field :kyc_application_number, :string
    field :kyc_method_id, :integer
    field :status, :integer
    field :ocr_status, :string
    field :rejected_at, :date
    field :note, :string
    field :comment, :string

    # JSON fields
    field :data, :map
    field :ocr_data, :map
    field :fields, :map

    # OCR related fields
    field :ocr_started_at, :utc_datetime
    field :ocr_completed_at, :utc_datetime
    field :ocr_error, :string
    field :ocr_confidence, :decimal
    field :ocr_retry_count, :integer

    field :created_at, :utc_datetime
    field :updated_at, :utc_datetime

    # Associations
    belongs_to :user, DaProductApp.Schemas.ShukriaMms.User, foreign_key: :user_id
  end
end