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

  def change do
    create table(:vat_invoices) do
      add :merchant_mid,    :string,  null: false
      add :merchant_id,     :integer
      add :settlement_date, :date,    null: false
      add :invoice_number,  :string,  null: false
      add :invoice_date,    :date,    null: false
      add :payout_item_id,  :integer
      add :gross_amount,    :decimal, precision: 18, scale: 4
      add :mdr_amount,      :decimal, precision: 18, scale: 4, null: false
      add :vat_amount,      :decimal, precision: 18, scale: 4, null: false
      add :sent_at,         :naive_datetime
      add :sent_to_email,   :string

      timestamps()
    end

    create unique_index(:vat_invoices, [:invoice_number])
    create unique_index(:vat_invoices, [:payout_item_id], name: :vat_invoices_payout_item_unique)
    create index(:vat_invoices, [:merchant_mid])
    create index(:vat_invoices, [:settlement_date])
  end
end