summaryrefslogtreecommitdiff
path: root/db/migrate/20221116160204_create_ml_experiment_metadata_and_ml_candidate_metadata.rb
blob: 288d1e4be9877b1dc4f8835356fb663052d05a80 (plain)
1
2
3
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
# frozen_string_literal: true

class CreateMlExperimentMetadataAndMlCandidateMetadata < Gitlab::Database::Migration[2.0]
  def change
    create_table :ml_experiment_metadata do |t|
      t.timestamps_with_timezone null: false
      t.references :experiment,
                   foreign_key: { to_table: :ml_experiments, on_delete: :cascade },
                   index: false,
                   null: false
      t.text :name, limit: 255, null: false
      t.text :value, limit: 5000, null: false

      t.index [:experiment_id, :name], unique: true
    end

    create_table :ml_candidate_metadata do |t|
      t.timestamps_with_timezone null: false
      t.references :candidate,
                   foreign_key: { to_table: :ml_candidates, on_delete: :cascade },
                   index: false,
                   null: false
      t.text :name, limit: 255, null: false, index: true
      t.text :value, limit: 5000, null: false

      t.index [:candidate_id, :name], unique: true
    end
  end
end