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.2.16	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.15	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.14	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.13	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.12	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.11	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.10	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.9	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.8	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.7	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.6	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.5	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.4	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.3	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.2	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.1	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.2.0	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.1.99	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.1.98	db/migrate/20230728123559_create_comee_core_contacts.rb
comee_core-0.1.97	db/migrate/20230728123559_create_comee_core_contacts.rb