class CreateEmployers < ActiveRecord::Migration[6.1]
  def change
    create_table :employers do |t|
      t.string "name"
      t.string "logo_url"
      t.string "short_name"
      t.string "short_code"
      t.integer "users_count", default: 0
      t.integer "subscriptions_count", default: 0
      t.string "status"
      t.boolean "user_set_status", default: false
      t.bigint "primary_contact_id"
      t.integer "savings_report_frequency_in_months", default: 3, null: false
      t.date "first_joined_at"
      t.string "org_type", default: "member", null: false
      t.bigint "asana_assignee_id"
      t.index ["asana_assignee_id"], name: "index_employers_on_asana_assignee_id"
      t.index ["first_joined_at"], name: "index_employers_on_first_joined_at"
      t.index ["org_type"], name: "index_employers_on_org_type"
      t.index ["primary_contact_id"], name: "index_employers_on_primary_contact_id"
      t.timestamps
    end
  end
end