Skip to content

public.documents

Columns

Name Type Default Nullable Children Parents Comment
created_at timestamp with time zone false
id bigint false public.contact_documents public.document_versions
latest_version_id bigint true public.document_versions
salesforce_ref varchar(255) false
title varchar(255) false
valid_from date true
valid_until date true

Constraints

Name Type Definition
documents_latest_version_id_bddf0d93_fk_document_versions_id FOREIGN KEY FOREIGN KEY (latest_version_id) REFERENCES document_versions(id) DEFERRABLE INITIALLY DEFERRED
documents_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
documents_latest_version_id_bddf0d93 CREATE INDEX documents_latest_version_id_bddf0d93 ON public.documents USING btree (latest_version_id)
documents_pkey CREATE UNIQUE INDEX documents_pkey ON public.documents USING btree (id)
documents_salesfo_399844_idx CREATE INDEX documents_salesfo_399844_idx ON public.documents USING btree (salesforce_ref)
documents_title_3f6c9c_idx CREATE INDEX documents_title_3f6c9c_idx ON public.documents USING btree (title)

Generated by tbls