Database Schema

api_key

Constraints and indexes

• api_key_pkey PRIMARY KEY, btree (id)

• api_key_user_id_key UNIQUE CONSTRAINT, btree (user_id)

batch_search

Constraints and indexes

• batch_search_pkey PRIMARY KEY, btree (uuid)

• batch_search_date btree (batch_date)

• batch_search_nb_queries btree (nb_queries)

Referenced by

• batch_search_pkey PRIMARY KEY, btree (uuid)

• batch_search_date btree (batch_date)

• batch_search_nb_queries btree (nb_queries)

batch_search_project

Constraints and indexes

• batch_search_project_unique UNIQUE, btree (search_uuid, prj_id)

• batch_search_project_batch_search_uuid_fk FOREIGN KEY (search_uuid) REFERENCES batch_search(uuid)

batch_search_query

Constraints and indexes

• batch_search_query_search_id btree (search_uuid)

• idx_query_result_batch_unique UNIQUE, btree (search_uuid, query)

batch_search_result

Constraints and indexes

• batch_search_result_prj_id btree (prj_id)

• batch_search_result_query btree (query)

• batch_search_result_uuid btree (search_uuid)

document

Constraints and indexes

• document_pkey PRIMARY KEY, btree (id)

• document_parent_id btree (parent_id)

• document_status btree (status)

document_tag

Constraints and indexes

• document_tag_doc_id btree (doc_id)

• document_tag_label btree (label)

• document_tag_project_id btree (prj_id)

document_user_recommendation

Constraints and indexes

• document_user_mark_read_doc_id btree (doc_id)

• document_user_mark_read_project_id btree (prj_id)

• document_user_mark_read_user_id btree (user_id)

document_user_star

Constraints and indexes

• document_user_star_doc_id btree (doc_id)

• document_user_star_project_id btree (prj_id)

• document_user_star_user_id btree (user_id)

named_entity

Constraints and indexes

• named_entity_pkey PRIMARY KEY, btree (id)

• named_entity_doc_id btree (doc_id)

note

Constraints and indexes

• idx_unique_note_path_project UNIQUE, btree (project_id, path)

• note_project btree (project_id)

project

Constraints and indexes

• project_pkey PRIMARY KEY, btree (id)

task

Constraints and indexes

• task_pkey PRIMARY KEY, btree (id)

• task_created_at btree (created_at)

• task_group btree (group_id)

user_history

Constraints and indexes

• user_history_pkey PRIMARY KEY, btree (id)

• idx_user_history_unique UNIQUE, btree (user_id, uri)

• user_history_creation_date btree (creation_date)

Referenced by

• user_history_pkey PRIMARY KEY, btree (id)

• idx_user_history_unique UNIQUE, btree (user_id, uri)

• user_history_creation_date btree (creation_date)

user_history_project

Constraints and indexes

• user_history_project_unique UNIQUE, btree (user_history_id, prj_id)

• user_history_project_user_history_id_fk FOREIGN KEY (user_history_id) REFERENCES user_history(id)

user_inventory

Constraints and indexes

• user_inventory_pkey PRIMARY KEY, btree (id)

user_policy

Constraints and indexes

• idx_user_policy_unique UNIQUE, btree (user_id, prj_id)