Skip to content

public.generated_employment_declaration_documents

Columns

Name Type Default Nullable Children Parents Comment
contact_id bigint false public.contacts
created_at timestamp with time zone false
file varchar(100) false
id bigint false public.docusign_envelope_documents
is_present_locally boolean false
placement_id bigint true public.placements
salesforce_ref varchar(255) false
sharepoint_ref varchar(255) false
signed_file varchar(100) false
type varchar(100) false

Constraints

Name Type Definition
generated_employment_contact_id_415df9ce_fk_contacts_ FOREIGN KEY FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED
generated_employment_declaration_documents_pkey PRIMARY KEY PRIMARY KEY (id)
generated_employment_placement_id_7c53d8dd_fk_placement FOREIGN KEY FOREIGN KEY (placement_id) REFERENCES placements(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
generated_e_is_pres_6f8d80_idx CREATE INDEX generated_e_is_pres_6f8d80_idx ON public.generated_employment_declaration_documents USING btree (is_present_locally)
generated_e_salesfo_4afdc2_idx CREATE INDEX generated_e_salesfo_4afdc2_idx ON public.generated_employment_declaration_documents USING btree (salesforce_ref)
generated_employment_decla_placement_id_7c53d8dd CREATE INDEX generated_employment_decla_placement_id_7c53d8dd ON public.generated_employment_declaration_documents USING btree (placement_id)
generated_employment_declaration_documents_contact_id_415df9ce CREATE INDEX generated_employment_declaration_documents_contact_id_415df9ce ON public.generated_employment_declaration_documents USING btree (contact_id)
generated_employment_declaration_documents_pkey CREATE UNIQUE INDEX generated_employment_declaration_documents_pkey ON public.generated_employment_declaration_documents USING btree (id)

Generated by tbls