public.generated_employment_declaration_documents¶

Columns¶

Name	Type	Nullable	Children	Parents
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

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

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