db/schema.rb in iqvoc-4.12.1 vs db/schema.rb in iqvoc-4.13.0
- old
+ new
@@ -1,6 +1,5 @@
-# encoding: UTF-8
# This file is auto-generated from the current state of the database. Instead
# of editing this file, please use the migrations feature of Active Record to
# incrementally modify your database, and then regenerate this schema definition.
#
# Note that this schema.rb definition is the authoritative source for your
@@ -9,193 +8,191 @@
# from scratch. The latter is a flawed and unsustainable approach (the more migrations
# you'll amass, the slower it'll run and the greater likelihood for issues).
#
# It's strongly recommended that you check this file into your version control system.
-ActiveRecord::Schema.define(version: 20190403133600) do
+ActiveRecord::Schema.define(version: 2020_09_01_143030) do
# These are extensions that must be enabled in order to support this database
enable_extension "plpgsql"
- create_table "collection_members", force: :cascade do |t|
+ create_table "collection_members", id: :serial, force: :cascade do |t|
t.integer "collection_id"
t.integer "target_id"
- t.string "type"
+ t.string "type"
+ t.index ["collection_id", "target_id", "type"], name: "ix_collections_fk_type"
+ t.index ["type"], name: "index_collection_members_on_type"
end
- add_index "collection_members", ["collection_id", "target_id", "type"], name: "ix_collections_fk_type", using: :btree
-
- create_table "concept_relations", force: :cascade do |t|
- t.string "type"
- t.integer "owner_id"
- t.integer "target_id"
+ create_table "concept_relations", id: :serial, force: :cascade do |t|
+ t.string "type"
+ t.integer "owner_id"
+ t.integer "target_id"
t.datetime "created_at"
t.datetime "updated_at"
- t.integer "rank", default: 100
+ t.integer "rank", default: 100
+ t.index ["owner_id", "target_id"], name: "ix_concept_relations_fk"
end
- add_index "concept_relations", ["owner_id", "target_id"], name: "ix_concept_relations_fk", using: :btree
-
- create_table "concepts", force: :cascade do |t|
- t.string "type"
- t.string "origin", limit: 4000
- t.integer "rev", default: 1
- t.date "published_at"
- t.integer "published_version_id"
- t.integer "locked_by"
- t.date "expired_at"
- t.date "follow_up"
- t.boolean "to_review"
- t.date "rdf_updated_at"
+ create_table "concepts", id: :serial, force: :cascade do |t|
+ t.string "type"
+ t.string "origin", limit: 4000
+ t.integer "rev", default: 1
+ t.date "published_at"
+ t.integer "published_version_id"
+ t.integer "locked_by"
+ t.date "expired_at"
+ t.date "follow_up"
+ t.boolean "to_review"
+ t.date "rdf_updated_at"
t.datetime "created_at"
t.datetime "updated_at"
- t.boolean "top_term", default: false
+ t.boolean "top_term", default: false
+ t.index ["origin"], name: "ix_concepts_on_origin"
+ t.index ["published_version_id"], name: "ix_concepts_publ_version_id"
end
- add_index "concepts", ["origin"], name: "ix_concepts_on_origin", using: :btree
- add_index "concepts", ["published_version_id"], name: "ix_concepts_publ_version_id", using: :btree
-
- create_table "configuration_settings", force: :cascade do |t|
+ create_table "configuration_settings", id: :serial, force: :cascade do |t|
t.string "key"
t.string "value"
end
- create_table "delayed_jobs", force: :cascade do |t|
- t.integer "priority", default: 0, null: false
- t.integer "attempts", default: 0, null: false
- t.text "handler", null: false
- t.text "last_error"
+ create_table "delayed_jobs", id: :serial, force: :cascade do |t|
+ t.integer "priority", default: 0, null: false
+ t.integer "attempts", default: 0, null: false
+ t.text "handler", null: false
+ t.text "last_error"
t.datetime "run_at"
t.datetime "locked_at"
t.datetime "failed_at"
- t.string "locked_by"
- t.string "queue"
+ t.string "locked_by"
+ t.string "queue"
t.datetime "created_at"
t.datetime "updated_at"
- t.string "error_message"
- t.string "delayed_reference_type"
- t.integer "delayed_reference_id"
- t.string "delayed_global_reference_id"
+ t.string "error_message"
+ t.string "delayed_reference_type"
+ t.integer "delayed_reference_id"
+ t.string "delayed_global_reference_id"
+ t.index ["delayed_global_reference_id"], name: "delayed_jobs_delayed_global_reference_id"
+ t.index ["delayed_reference_id"], name: "delayed_jobs_delayed_reference_id"
+ t.index ["delayed_reference_type"], name: "delayed_jobs_delayed_reference_type"
+ t.index ["priority", "run_at"], name: "delayed_jobs_priority"
+ t.index ["queue"], name: "delayed_jobs_queue"
end
- add_index "delayed_jobs", ["delayed_global_reference_id"], name: "delayed_jobs_delayed_global_reference_id", using: :btree
- add_index "delayed_jobs", ["delayed_reference_id"], name: "delayed_jobs_delayed_reference_id", using: :btree
- add_index "delayed_jobs", ["delayed_reference_type"], name: "delayed_jobs_delayed_reference_type", using: :btree
- add_index "delayed_jobs", ["priority", "run_at"], name: "delayed_jobs_priority", using: :btree
- add_index "delayed_jobs", ["queue"], name: "delayed_jobs_queue", using: :btree
-
- create_table "exports", force: :cascade do |t|
- t.integer "user_id"
- t.text "output"
- t.boolean "success", default: false
- t.integer "file_type"
- t.string "token"
+ create_table "exports", id: :serial, force: :cascade do |t|
+ t.integer "user_id"
+ t.text "output"
+ t.boolean "success", default: false
+ t.integer "file_type"
+ t.string "token"
t.datetime "created_at"
t.datetime "updated_at"
t.datetime "finished_at"
- t.string "default_namespace"
+ t.string "default_namespace"
+ t.index ["user_id"], name: "index_exports_on_user_id"
end
- add_index "exports", ["user_id"], name: "index_exports_on_user_id", using: :btree
-
- create_table "imports", force: :cascade do |t|
- t.integer "user_id"
- t.text "output"
- t.boolean "success", default: false
+ create_table "imports", id: :serial, force: :cascade do |t|
+ t.integer "user_id"
+ t.text "output"
+ t.boolean "success", default: false
t.datetime "created_at"
t.datetime "updated_at"
t.datetime "finished_at"
- t.string "import_file"
- t.boolean "publish"
- t.string "default_namespace"
+ t.string "import_file"
+ t.boolean "publish"
+ t.string "default_namespace"
+ t.index ["user_id"], name: "index_imports_on_user_id"
end
- add_index "imports", ["user_id"], name: "index_imports_on_user_id", using: :btree
-
- create_table "labelings", force: :cascade do |t|
- t.string "type"
- t.integer "owner_id"
- t.integer "target_id"
+ create_table "labelings", id: :serial, force: :cascade do |t|
+ t.string "type"
+ t.integer "owner_id"
+ t.integer "target_id"
t.datetime "created_at"
t.datetime "updated_at"
+ t.index ["owner_id", "target_id", "type"], name: "ix_labelings_fk_type"
+ t.index ["type"], name: "ix_labelings_on_type"
end
- add_index "labelings", ["owner_id", "target_id", "type"], name: "ix_labelings_fk_type", using: :btree
- add_index "labelings", ["type"], name: "ix_labelings_on_type", using: :btree
-
- create_table "labels", force: :cascade do |t|
- t.string "type"
- t.string "origin", limit: 4000
- t.string "language"
- t.string "value", limit: 1024
+ create_table "labels", id: :serial, force: :cascade do |t|
+ t.string "type"
+ t.string "origin", limit: 4000
+ t.string "language"
+ t.string "value", limit: 1024
t.datetime "created_at"
t.datetime "updated_at"
- t.date "published_at"
+ t.date "published_at"
+ t.index ["language"], name: "ix_labels_on_language"
+ t.index ["origin"], name: "ix_labels_on_origin"
end
- add_index "labels", ["language"], name: "ix_labels_on_language", using: :btree
- add_index "labels", ["origin"], name: "ix_labels_on_origin", using: :btree
-
- create_table "matches", force: :cascade do |t|
- t.integer "concept_id"
- t.string "type"
- t.string "value"
+ create_table "matches", id: :serial, force: :cascade do |t|
+ t.integer "concept_id"
+ t.string "type"
+ t.string "value"
t.datetime "created_at"
t.datetime "updated_at"
+ t.index ["concept_id", "type"], name: "ix_matches_fk_type"
+ t.index ["type"], name: "ix_matches_on_type"
end
- add_index "matches", ["concept_id", "type"], name: "ix_matches_fk_type", using: :btree
- add_index "matches", ["type"], name: "ix_matches_on_type", using: :btree
-
- create_table "notations", force: :cascade do |t|
+ create_table "notations", id: :serial, force: :cascade do |t|
t.integer "concept_id"
- t.string "value", limit: 4000
- t.string "data_type", limit: 4000
+ t.string "value", limit: 4000
+ t.string "data_type", limit: 4000
+ t.index ["concept_id"], name: "index_notations_on_concept_id"
end
- add_index "notations", ["concept_id"], name: "index_notations_on_concept_id", using: :btree
-
- create_table "note_annotations", force: :cascade do |t|
- t.integer "note_id"
- t.string "predicate", limit: 50
- t.string "value", limit: 1024
+ create_table "note_annotations", id: :serial, force: :cascade do |t|
+ t.integer "note_id"
+ t.string "predicate", limit: 50
+ t.string "value", limit: 1024
t.datetime "created_at"
t.datetime "updated_at"
- t.string "namespace", limit: 50
- t.string "language"
+ t.string "namespace", limit: 50
+ t.string "language"
+ t.index ["note_id"], name: "ix_note_annotations_fk"
+ t.index ["value"], name: "index_note_annotations_on_value"
end
- add_index "note_annotations", ["note_id"], name: "ix_note_annotations_fk", using: :btree
- add_index "note_annotations", ["value"], name: "index_note_annotations_on_value", using: :btree
-
- create_table "notes", force: :cascade do |t|
- t.string "language", limit: 2
- t.string "value", limit: 4000
- t.string "type", limit: 50
+ create_table "notes", id: :serial, force: :cascade do |t|
+ t.string "language", limit: 2
+ t.string "value", limit: 4000
+ t.string "type", limit: 50
t.datetime "created_at"
t.datetime "updated_at"
- t.integer "owner_id"
- t.string "owner_type", null: false
+ t.integer "owner_id"
+ t.string "owner_type", null: false
+ t.integer "position"
+ t.index ["language"], name: "ix_notes_on_language"
+ t.index ["owner_id", "owner_type", "type"], name: "ix_notes_fk_type"
+ t.index ["type"], name: "ix_notes_on_type"
end
- add_index "notes", ["language"], name: "ix_notes_on_language", using: :btree
- add_index "notes", ["owner_id", "owner_type", "type"], name: "ix_notes_fk_type", using: :btree
- add_index "notes", ["type"], name: "ix_notes_on_type", using: :btree
-
- create_table "users", force: :cascade do |t|
- t.string "forename"
- t.string "surname"
- t.string "email"
- t.string "crypted_password"
- t.boolean "active"
+ create_table "users", id: :serial, force: :cascade do |t|
+ t.string "forename"
+ t.string "surname"
+ t.string "email"
+ t.string "crypted_password"
+ t.boolean "active"
t.datetime "created_at"
t.datetime "updated_at"
- t.string "password_salt"
- t.string "persistence_token"
- t.string "perishable_token"
- t.string "role"
- t.string "telephone_number"
- t.string "type", default: "User"
+ t.string "password_salt"
+ t.string "persistence_token"
+ t.string "perishable_token"
+ t.string "role"
+ t.string "telephone_number"
+ t.string "type", default: "User"
+ t.text "comment"
+ t.integer "login_count", default: 0, null: false
+ t.integer "failed_login_count", default: 0, null: false
+ t.datetime "last_request_at"
+ t.datetime "current_login_at"
+ t.datetime "last_login_at"
+ t.string "current_login_ip"
+ t.string "last_login_ip"
end
add_foreign_key "collection_members", "concepts", column: "collection_id", on_update: :cascade
add_foreign_key "collection_members", "concepts", column: "target_id", on_update: :cascade
add_foreign_key "concept_relations", "concepts", column: "owner_id", on_update: :cascade