Skip to content

public.document_versions

Columns

Name Type Default Nullable Children Parents Comment
created_at timestamp with time zone false
created_by_id bigint true public.users
document_id bigint false public.documents
file varchar(100) false
file_size integer false
file_type varchar(255) false
id bigint false public.documents
is_latest boolean false
salesforce_ref varchar(255) false
version integer false

Constraints

Name Type Definition
document_versions_created_by_id_06a1d777_fk_users_id FOREIGN KEY FOREIGN KEY (created_by_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
document_versions_document_id_f408232d_fk_documents_id FOREIGN KEY FOREIGN KEY (document_id) REFERENCES documents(id) DEFERRABLE INITIALLY DEFERRED
document_versions_file_size_check CHECK CHECK ((file_size >= 0))
document_versions_pkey PRIMARY KEY PRIMARY KEY (id)
document_versions_version_check CHECK CHECK ((version >= 0))
unique_document_version UNIQUE UNIQUE (document_id, version)

Indexes

Name Definition
document_ve_is_late_a18c8d_idx CREATE INDEX document_ve_is_late_a18c8d_idx ON public.document_versions USING btree (is_latest)
document_ve_salesfo_5ff6e8_idx CREATE INDEX document_ve_salesfo_5ff6e8_idx ON public.document_versions USING btree (salesforce_ref)
document_versions_created_by_id_06a1d777 CREATE INDEX document_versions_created_by_id_06a1d777 ON public.document_versions USING btree (created_by_id)
document_versions_document_id_f408232d CREATE INDEX document_versions_document_id_f408232d ON public.document_versions USING btree (document_id)
document_versions_pkey CREATE UNIQUE INDEX document_versions_pkey ON public.document_versions USING btree (id)
unique_document_version CREATE UNIQUE INDEX unique_document_version ON public.document_versions USING btree (document_id, version)
unique_latest_version CREATE UNIQUE INDEX unique_latest_version ON public.document_versions USING btree (document_id) WHERE is_latest

Generated by tbls