Contents

class CreateSisCoreCourseAssignments < ActiveRecord::Migration[6.0]
  def change
    create_table :sis_core_course_assignments do |t|
      t.references :course_offering,
                   null: false,
                   index: { name: 'crs_off_on_crs_ass' },
                   foreign_key: { to_table: :sis_core_course_offerings }
      t.references :section,
                   null: false,
                   index: { name: 'sec_on_crs_ass' },
                   foreign_key: { to_table: :sis_core_sections }
      t.references :instructor,
                   null: false,
                   index: { name: 'ins_on_crs_ass' },
                   foreign_key: { to_table: :sis_core_instructors }
      t.integer :lab_instructor_id, null: true
      t.integer :tutorial_instructor_id, null: true

      t.timestamps
    end
  end
end

Version data entries

4 entries across 4 versions & 1 rubygems

Version	Path
sis_core-1.0.20	db/migrate/20201110080957_create_sis_core_course_assignments.rb
sis_core-1.0.19	db/migrate/20201110080957_create_sis_core_course_assignments.rb
sis_core-1.0.18	db/migrate/20201110080957_create_sis_core_course_assignments.rb
sis_core-1.0.17	db/migrate/20201110080957_create_sis_core_course_assignments.rb