Sha256: ca0cd231c98a4cebf984a843b9b496c95d260336b9f20e07e4a3079e6baaedb4
Contents?: true
Size: 715 Bytes
Versions: 73
Compression:
Stored size: 715 Bytes
Contents
class CreateResearchStudies < ActiveRecord::Migration[5.1]
def change
create_table :research_studies do |t|
t.string :code, null: false
t.string :description, null: false, index: true
t.string :leader, index: true
t.text :notes
t.date :started_on
t.date :terminated_on
t.datetime :deleted_at
t.references :updated_by, foreign_key: { to_table: :users }, index: true
t.references :created_by, foreign_key: { to_table: :users }, index: true
t.timestamps null: false
end
# This create a postgres partial index
add_index :research_studies,
:code,
unique: true,
where: "deleted_at IS NULL"
end
end
Version data entries
73 entries across 73 versions & 1 rubygems