Contents

class CreateComeeCoreContacts < ActiveRecord::Migration[7.1]
  def change
    create_table :comee_core_contacts do |t|
      t.string :first_name, null: false
      t.string :last_name, null: false
      t.string :email, null: false
      t.string :telephone, null: false

      t.timestamps
    end

    create_table :comee_core_suppliers_contacts, id: false do |t|
      t.references :supplier,
                   null: false,
                   index: {name: "supplier_on_ccsc_indx"},
                   foreign_key: {to_table: :comee_core_suppliers}
      t.references :contact,
                   null: false,
                   index: {name: "sc_on_ccsc_indx"},
                   foreign_key: {to_table: :comee_core_contacts}
    end

    create_table :comee_core_clients_contacts, id: false do |t|
      t.references :client,
                   null: false,
                   index: {name: "client_on_ccsc_indx"},
                   foreign_key: {to_table: :comee_core_clients}
      t.references :contact,
                   null: false,
                   index: {name: "cc_on_ccsc_indx"},
                   foreign_key: {to_table: :comee_core_contacts}
    end
  end
end

Version data entries

160 entries across 160 versions & 1 rubygems

Version	Path
comee_core-0.3.21	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.20	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.19	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.18	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.17	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.16	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.15	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.14	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.13	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.12	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.11	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.10	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.9	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.8	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.7	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.6	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.5	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.4	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.3	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.3.2	db/migrate/20230728123559_create_comee_core_contacts.rb