Contents

class CreateEcomCoreCrewOvertimes < ActiveRecord::Migration[6.0]
  def change
    create_table :ecom_core_crew_overtimes do |t|
      t.float :hours, null: false
      t.float :converted_hours, null: false, default: 0
      t.string :remark
      t.references :overtime_type, null: false, index: { name: 'ot_on_co_indx' }
      t.references :overtime_sheet_entry, null: false, index: { name: 'ose_on_co_indx' }
      t.boolean :revised, null: false, default: false
      t.references :revision_to, null: true
      t.references :created_by, null: false, index: { name: 'cb_on_co_indx' }

      t.timestamps
    end
    add_foreign_key :ecom_core_crew_overtimes, :ecom_core_overtime_types, column: :overtime_type_id
    add_foreign_key :ecom_core_crew_overtimes, :ecom_core_overtime_sheet_entries,
                    column: :overtime_sheet_entry_id
    add_foreign_key :ecom_core_crew_overtimes, :ecom_core_crew_overtimes, column: :revision_to_id
    add_foreign_key :ecom_core_crew_overtimes, :ecom_core_users, column: :created_by_id
  end
end

Version data entries

18 entries across 18 versions & 1 rubygems

Version	Path
ecom_core-1.2.5	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.2.4	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.2.3	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.2.2	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.2.1	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.2.0	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.28	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.27	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.26	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.25	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.24	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.23	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.22	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.21	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.20	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.19	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.18	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb
ecom_core-1.1.17	db/migrate/20200410111827_create_ecom_core_crew_overtimes.rb