Class: CreateLearningOutcomeResults

Inherits:
Object
  • Object
show all
Defined in:
lib/canvas_sync/generators/templates/migrations/create_learning_outcome_results.rb

Overview

<%= autogenerated_migration_warning %>

Instance Method Summary collapse

Instance Method Details

#change ⇒ Object 



4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 
# File 'lib/canvas_sync/generators/templates/migrations/create_learning_outcome_results.rb', line 4

def change
  create_table :learning_outcome_results do |t|
    t.bigint :canvas_id, null: false
    t.bigint :canvas_context_id
    t.string :canvas_context_type
    t.bigint :canvas_association_id
    t.string :canvas_association_type
    t.bigint :canvas_content_tag_id
    t.bigint :canvas_learning_outcome_id
    t.bigint :canvas_user_id
    t.boolean :mastery
    t.boolean :original_mastery
    t.bigint :canvas_artifact_id
    t.string :canvas_artifact_type
    t.datetime :assessed_at
    t.string :title
    t.float :percent
    t.bigint :canvas_associated_asset_id
    t.string :canvas_associated_asset_type
    t.integer :attempt
    t.float :score
    t.float :possible
    t.float :original_score
    t.float :original_possible
    t.string :workflow_state

    t.timestamps
  end

  add_index :learning_outcome_results, :canvas_id, unique: true
  add_index :learning_outcome_results, %i[
    canvas_user_id
    canvas_content_tag_id
    canvas_association_id
    canvas_association_type
    canvas_associated_asset_id
    canvas_associated_asset_type
  ], unique: true, name: :index_learning_outcome_results_association
  add_index :learning_outcome_results, :canvas_content_tag_id
  add_index :learning_outcome_results, :canvas_learning_outcome_id
  add_index :learning_outcome_results, %i[canvas_artifact_id canvas_artifact_type], name: :index_learning_outcome_results_on_canvas_arid_and_artype
end