schema.rb in iqvoc-4.14.4

- old
+ new

@@ -8,12 +8,11 @@
 # migrations from scratch. Old migrations may fail to apply correctly if those
 # migrations use external dependencies or application code.
 #
 # It's strongly recommended that you check this file into your version control system.
 
-ActiveRecord::Schema.define(version: 2022_01_07_114201) do
-
+ActiveRecord::Schema[7.0].define(version: 2023_10_12_135837) do
   # These are extensions that must be enabled in order to support this database
   enable_extension "plpgsql"
 
   create_table "collection_members", id: :serial, force: :cascade do |t|
     t.integer "collection_id"
@@ -25,29 +24,28 @@
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     t.integer "rank", default: 100
     t.index ["owner_id", "target_id"], name: "ix_concept_relations_fk"
   end
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     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
 
@@ -59,17 +57,17 @@
   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.datetime "run_at", precision: nil
+    t.datetime "locked_at", precision: nil
+    t.datetime "failed_at", precision: nil
     t.string "locked_by"
     t.string "queue"
-    t.datetime "created_at"
-    t.datetime "updated_at"
+    t.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     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"
@@ -83,58 +81,58 @@
     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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
+    t.datetime "finished_at", precision: nil
     t.string "default_namespace"
     t.index ["user_id"], name: "index_exports_on_user_id"
   end
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
+    t.datetime "finished_at", precision: nil
     t.string "import_file"
     t.boolean "publish"
     t.string "default_namespace"
     t.index ["user_id"], name: "index_imports_on_user_id"
   end
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     t.index ["owner_id", "target_id", "type"], name: "ix_labelings_fk_type"
     t.index ["type"], name: "ix_labelings_on_type"
   end
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     t.date "published_at"
     t.index ["language"], name: "ix_labels_on_language"
     t.index ["origin"], name: "ix_labels_on_origin"
   end
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     t.index ["concept_id", "type"], name: "ix_matches_fk_type"
     t.index ["type"], name: "ix_matches_on_type"
   end
 
   create_table "notations", id: :serial, force: :cascade do |t|
@@ -146,24 +144,24 @@
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     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
 
   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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     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"
@@ -174,32 +172,31 @@
     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.datetime "created_at", precision: nil
+    t.datetime "updated_at", precision: nil
     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.datetime "last_request_at", precision: nil
+    t.datetime "current_login_at", precision: nil
+    t.datetime "last_login_at", precision: nil
     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
   add_foreign_key "concept_relations", "concepts", column: "target_id", on_update: :cascade
-  add_foreign_key "concepts", "users", column: "locked_by", on_update: :cascade, on_delete: :nullify
   add_foreign_key "exports", "users", on_update: :cascade, on_delete: :nullify
   add_foreign_key "imports", "users", on_update: :cascade, on_delete: :nullify
   add_foreign_key "labelings", "concepts", column: "owner_id", on_update: :cascade
   add_foreign_key "labelings", "labels", column: "target_id", on_update: :cascade, on_delete: :cascade
   add_foreign_key "matches", "concepts", on_update: :cascade, on_delete: :cascade