| contact_doc_salesfo_6e5b18_idx |
CREATE INDEX contact_doc_salesfo_6e5b18_idx ON public.contact_documents USING btree (salesforce_ref) |
| contact_doc_type_1d859b_idx |
CREATE INDEX contact_doc_type_1d859b_idx ON public.contact_documents USING btree (type) |
| contact_documents_contact_id_579309c7 |
CREATE INDEX contact_documents_contact_id_579309c7 ON public.contact_documents USING btree (contact_id) |
| contact_documents_document_id_38e0c794 |
CREATE INDEX contact_documents_document_id_38e0c794 ON public.contact_documents USING btree (document_id) |
| contact_documents_pkey |
CREATE UNIQUE INDEX contact_documents_pkey ON public.contact_documents USING btree (id) |
| unique_cv_per_contact |
CREATE UNIQUE INDEX unique_cv_per_contact ON public.contact_documents USING btree (contact_id) WHERE ((type)::text = 'CV'::text) |