public.docusign_envelope_documents¶

Columns¶

Name	Type	Nullable	Parents
document_id	integer	false
envelope_id	bigint	false	public.docusign_envelopes
generated_arrival_contact_document_id	bigint	true	public.generated_arrival_contact_documents
generated_contact_document_id	bigint	true	public.generated_contact_documents
generated_employment_contract_document_id	bigint	true	public.generated_employment_contract_documents
generated_employment_declaration_document_id	bigint	true	public.generated_employment_declaration_documents
generated_placement_document_id	bigint	true	public.generated_placement_documents
id	bigint	false

Constraints¶

Name	Type	Definition
docusign_envelope_do_envelope_id_e0a1c993_fk_docusign_	FOREIGN KEY	FOREIGN KEY (envelope_id) REFERENCES docusign_envelopes(id) DEFERRABLE INITIALLY DEFERRED
docusign_envelope_do_generated_arrival_co_bbe0d601_fk_generated	FOREIGN KEY	FOREIGN KEY (generated_arrival_contact_document_id) REFERENCES generated_arrival_contact_documents(id) DEFERRABLE INITIALLY DEFERRED
docusign_envelope_do_generated_contact_do_6cd4fc7f_fk_generated	FOREIGN KEY	FOREIGN KEY (generated_contact_document_id) REFERENCES generated_contact_documents(id) DEFERRABLE INITIALLY DEFERRED
docusign_envelope_do_generated_employment_4d0d788d_fk_generated	FOREIGN KEY	FOREIGN KEY (generated_employment_declaration_document_id) REFERENCES generated_employment_declaration_documents(id) DEFERRABLE INITIALLY DEFERRED
docusign_envelope_do_generated_employment_64d20ed4_fk_generated	FOREIGN KEY	FOREIGN KEY (generated_employment_contract_document_id) REFERENCES generated_employment_contract_documents(id) DEFERRABLE INITIALLY DEFERRED
docusign_envelope_do_generated_placement__7dc7ce78_fk_generated	FOREIGN KEY	FOREIGN KEY (generated_placement_document_id) REFERENCES generated_placement_documents(id) DEFERRABLE INITIALLY DEFERRED
docusign_envelope_document_exactly_one_target	CHECK	CHECK ((((generated_contact_document_id IS NOT NULL) AND (generated_arrival_contact_document_id IS NULL) AND (generated_placement_document_id IS NULL) AND (generated_employment_contract_document_id IS NULL) AND (generated_employment_declaration_document_id IS NULL)) OR ((generated_contact_document_id IS NOT NULL) AND (generated_arrival_contact_document_id IS NULL) AND (generated_placement_document_id IS NULL) AND (generated_employment_contract_document_id IS NULL) AND (generated_employment_declaration_document_id IS NOT NULL)) OR ((generated_contact_document_id IS NULL) AND (generated_arrival_contact_document_id IS NOT NULL) AND (generated_placement_document_id IS NULL) AND (generated_employment_contract_document_id IS NULL) AND (generated_employment_declaration_document_id IS NULL)) OR ((generated_contact_document_id IS NULL) AND (generated_arrival_contact_document_id IS NULL) AND (generated_placement_document_id IS NOT NULL) AND (generated_employment_contract_document_id IS NULL) AND (generated_employment_declaration_document_id IS NULL)) OR ((generated_contact_document_id IS NULL) AND (generated_arrival_contact_document_id IS NULL) AND (generated_placement_document_id IS NULL) AND (generated_employment_contract_document_id IS NOT NULL) AND (generated_employment_declaration_document_id IS NULL)) OR ((generated_contact_document_id IS NULL) AND (generated_arrival_contact_document_id IS NULL) AND (generated_placement_document_id IS NULL) AND (generated_employment_contract_document_id IS NULL) AND (generated_employment_declaration_document_id IS NOT NULL))))
docusign_envelope_documents_document_id_check	CHECK	CHECK ((document_id >= 0))
docusign_envelope_documents_pkey	PRIMARY KEY	PRIMARY KEY (id)
unique_envelope_document_id	UNIQUE	UNIQUE (envelope_id, document_id)

Indexes¶

Name	Definition
docusign_envelope_document_generated_arrival_contact__bbe0d601	CREATE INDEX docusign_envelope_document_generated_arrival_contact__bbe0d601 ON public.docusign_envelope_documents USING btree (generated_arrival_contact_document_id)
docusign_envelope_document_generated_contact_document_6cd4fc7f	CREATE INDEX docusign_envelope_document_generated_contact_document_6cd4fc7f ON public.docusign_envelope_documents USING btree (generated_contact_document_id)
docusign_envelope_document_generated_employment_contr_64d20ed4	CREATE INDEX docusign_envelope_document_generated_employment_contr_64d20ed4 ON public.docusign_envelope_documents USING btree (generated_employment_contract_document_id)
docusign_envelope_document_generated_employment_decla_4d0d788d	CREATE INDEX docusign_envelope_document_generated_employment_decla_4d0d788d ON public.docusign_envelope_documents USING btree (generated_employment_declaration_document_id)
docusign_envelope_document_generated_placement_docume_7dc7ce78	CREATE INDEX docusign_envelope_document_generated_placement_docume_7dc7ce78 ON public.docusign_envelope_documents USING btree (generated_placement_document_id)
docusign_envelope_documents_envelope_id_e0a1c993	CREATE INDEX docusign_envelope_documents_envelope_id_e0a1c993 ON public.docusign_envelope_documents USING btree (envelope_id)
docusign_envelope_documents_pkey	CREATE UNIQUE INDEX docusign_envelope_documents_pkey ON public.docusign_envelope_documents USING btree (id)
unique_envelope_document_id	CREATE UNIQUE INDEX unique_envelope_document_id ON public.docusign_envelope_documents USING btree (envelope_id, document_id)

Generated by tbls