Skip to content

public.generated_placement_documents

Columns

Name Type Default Nullable Children Parents Comment
created_at timestamp with time zone false
file varchar(100) false
id bigint false public.docusign_envelope_documents
is_draft boolean false
is_present_locally boolean false
placement_id bigint false 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_placement__placement_id_08a094cc_fk_placement FOREIGN KEY FOREIGN KEY (placement_id) REFERENCES placements(id) DEFERRABLE INITIALLY DEFERRED
generated_placement_documents_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
generated_p_is_draf_994aac_idx CREATE INDEX generated_p_is_draf_994aac_idx ON public.generated_placement_documents USING btree (is_draft)
generated_p_is_pres_b142d0_idx CREATE INDEX generated_p_is_pres_b142d0_idx ON public.generated_placement_documents USING btree (is_present_locally)
generated_p_salesfo_612b3f_idx CREATE INDEX generated_p_salesfo_612b3f_idx ON public.generated_placement_documents USING btree (salesforce_ref)
generated_placement_documents_pkey CREATE UNIQUE INDEX generated_placement_documents_pkey ON public.generated_placement_documents USING btree (id)
generated_placement_documents_placement_id_08a094cc CREATE INDEX generated_placement_documents_placement_id_08a094cc ON public.generated_placement_documents USING btree (placement_id)

Generated by tbls