migr.rb

class CreateAcademicClassroomFinalGradeStudents < ActiveRecord::Migration
  def change
    create_table :educacao_academic_classroom_final_grade_students do |t|
      t.belongs_to :academic_classroom_final_grade
      t.belongs_to :student
      t.timestamps
    end

    add_index :educacao_academic_classroom_final_grade_students, :academic_classroom_final_grade_id,
      :name => 'index_eacfgs_final_grade_id'
    add_index :educacao_academic_classroom_final_grade_students, :student_id,
      :name => 'index_eacfgs_student_id'

    add_foreign_key :educacao_academic_classroom_final_grade_students, :educacao_academic_classroom_final_grades,
      :column => :academic_classroom_final_grade_id, :name => 'eacfgs_final_grades_fk'
    add_foreign_key :educacao_academic_classroom_final_grade_students, :educacao_pilot_list_enrollment_academic_years,
      :column => :student_id, :name => 'eacfgs_students_fk'
  end
end