Contents

class CreateSisCoreCourseOfferings < ActiveRecord::Migration[6.0]
  def change
    create_table :sis_core_course_offerings do |t|
      t.references :course_offering_sequence,
                   null: false,
                   index: { name: 'crs_off_seq_on_crs_off' },
                   foreign_key: { to_table: :sis_core_course_offering_sequences }
      t.references :academic_year,
                   null: false,
                   index: { name: 'ay_on_crs_off' },
                   foreign_key: { to_table: :sis_core_academic_years }
      t.references :semester,
                   null: false,
                   index: { name: 'sem_on_crs_off' },
                   foreign_key: { to_table: :sis_core_semesters }
      t.references :level,
                   null: false,
                   index: { name: 'level_on_crs_off' },
                   foreign_key: { to_table: :sis_core_lookups }

      t.timestamps
    end
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
sis_core-1.0.20	db/migrate/20201104111548_create_sis_core_course_offerings.rb
sis_core-1.0.19	db/migrate/20201104111548_create_sis_core_course_offerings.rb
sis_core-1.0.18	db/migrate/20201104111548_create_sis_core_course_offerings.rb
sis_core-1.0.17	db/migrate/20201104111548_create_sis_core_course_offerings.rb
sis_core-1.0.16	db/migrate/20201104111548_create_sis_core_course_offerings.rb