require "jobshop/helpers/migration.rb"

class CreateRFQs < ActiveRecord::Migration[5.2]
  include Jobshop::Helpers::Migration

  def change
    create_table :jobshop_rfqs, id: false do |t|
      t.uuid :organization_id, null: false
      t.uuid :rfq_id, null: false, default: "gen_random_uuid()"
      t.index %i[ organization_id rfq_id ], unique: true,
        name: "idx_jobshop_rfqs_pkey"

      t.uuid :company_id, null: true
      t.index %i[ organization_id company_id ], where: "company_id IS NOT NULL"
      t.index %i[ organization_id company_id ], where: "company_id IS NULL",
        name: "idx_jobshop_rfqs_company_is_null"

      t.string :from
      t.string :subject, null: false
      t.text :content, null: false

      t.timestamps
    end

    idx_table_name_pkey "jobshop_rfqs"
    fk_organization_id "jobshop_rfqs"
    foreign_key "jobshop_rfqs", "jobshop_companies",
      [ "organization_id", "company_id" ]

    create_table :jobshop_rfq_lines, id: false do |t|
      t.uuid :organization_id, null: false
      t.uuid :rfq_id, null: false
      t.uuid :rfq_line_id, null: false, default: "gen_random_uuid()"
      t.index %i[ organization_id rfq_id rfq_line_id ], unique: true,
        name: "idx_jobshop_rfq_lines_pkey"

      t.timestamps
    end
  end
end