Skip to content

public.docusign_envelopes

Columns

Name Type Default Nullable Children Parents Comment
completed_at timestamp with time zone true
created_at timestamp with time zone false
declined_reason text false
envelope_id varchar(255) false
id bigint false public.docusign_envelope_documents
phase varchar(32) false
placement_id bigint true public.placements
sent_at timestamp with time zone true
status varchar(32) false
updated_at timestamp with time zone false
worker_id bigint false public.contacts

Constraints

Name Type Definition
docusign_envelopes_envelope_id_key UNIQUE UNIQUE (envelope_id)
docusign_envelopes_pkey PRIMARY KEY PRIMARY KEY (id)
docusign_envelopes_placement_id_0db67b10_fk_placements_id FOREIGN KEY FOREIGN KEY (placement_id) REFERENCES placements(id) DEFERRABLE INITIALLY DEFERRED
docusign_envelopes_worker_id_31b64c91_fk_contacts_id FOREIGN KEY FOREIGN KEY (worker_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED

Indexes

Name Definition
docusign_en_envelop_7952e1_idx CREATE INDEX docusign_en_envelop_7952e1_idx ON public.docusign_envelopes USING btree (envelope_id)
docusign_en_phase_5776a7_idx CREATE INDEX docusign_en_phase_5776a7_idx ON public.docusign_envelopes USING btree (phase, status)
docusign_envelopes_envelope_id_66be57d4_like CREATE INDEX docusign_envelopes_envelope_id_66be57d4_like ON public.docusign_envelopes USING btree (envelope_id varchar_pattern_ops)
docusign_envelopes_envelope_id_key CREATE UNIQUE INDEX docusign_envelopes_envelope_id_key ON public.docusign_envelopes USING btree (envelope_id)
docusign_envelopes_pkey CREATE UNIQUE INDEX docusign_envelopes_pkey ON public.docusign_envelopes USING btree (id)
docusign_envelopes_placement_id_0db67b10 CREATE INDEX docusign_envelopes_placement_id_0db67b10 ON public.docusign_envelopes USING btree (placement_id)
docusign_envelopes_worker_id_31b64c91 CREATE INDEX docusign_envelopes_worker_id_31b64c91 ON public.docusign_envelopes USING btree (worker_id)

Generated by tbls