Contents

class CreateSisCoreCourseOfferingSequences < ActiveRecord::Migration[6.0]
  def change
    create_table :sis_core_course_offering_sequences do |t|
      t.references :curriculum_course,
                   null: false,
                   index: { name: 'cc_on_course_off_seq' },
                   foreign_key: { to_table: :sis_core_curriculum_courses }
      t.references :programme_type,
                   null: false,
                   index: { name: 'pt_on_course_off_seq' },
                   foreign_key: { to_table: :sis_core_lookups }
      t.references :level,
                   null: false,
                   index: { name: 'level_on_course_off_seq' },
                   foreign_key: { to_table: :sis_core_lookups }
      t.references :semester,
                   null: false,
                   index: { name: 'sem_on_course_off_seq' },
                   foreign_key: { to_table: :sis_core_semesters }

      t.timestamps
    end
  end
end

Version data entries

5 entries across 5 versions & 1 rubygems

Version	Path
sis_core-1.0.20	db/migrate/20201104085458_create_sis_core_course_offering_sequences.rb
sis_core-1.0.19	db/migrate/20201104085458_create_sis_core_course_offering_sequences.rb
sis_core-1.0.18	db/migrate/20201104085458_create_sis_core_course_offering_sequences.rb
sis_core-1.0.17	db/migrate/20201104085458_create_sis_core_course_offering_sequences.rb
sis_core-1.0.16	db/migrate/20201104085458_create_sis_core_course_offering_sequences.rb