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

  @primary_key {:id, :id, autogenerate: true}
  schema "users" do
    field :name, :string
    field :username, :string
    field :email, :string
    field :phone, :string
    field :role, :string
    field :status, :integer
    field :kyc_status, Ecto.Enum, values: [:in_progress, :approved, :rejected]
    field :public_key, :string
    field :secret_key, :string
    field :city, :string
    field :merchant_status, :string
    field :expected_annual_turnover, :string
    field :contract_status, :string

    # JSON fields
    field :meta, :map
    field :shareholders, :map
    field :products, :map
    field :fee_structure, :map
    field :contract_data, :map

    # Timestamps
    field :created_at, :utc_datetime
    field :updated_at, :utc_datetime
    field :kyc_verified_at, :utc_datetime

    # Associations
    has_many :user_metadata, DaProductApp.Schemas.ShukriaMms.UserMetadata, foreign_key: :user_id
    has_many :kyc_requests, DaProductApp.Schemas.ShukriaMms.KycRequest, foreign_key: :user_id
  end
end