public.generated_arrival_contact_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_arrival_co_contact_id_c60c73ed_fk_contacts_ | FOREIGN KEY | FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED |
| generated_arrival_co_placement_id_cc874157_fk_placement | FOREIGN KEY | FOREIGN KEY (placement_id) REFERENCES placements(id) DEFERRABLE INITIALLY DEFERRED |
| generated_arrival_contact_documents_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| generated_a_is_pres_1a68b2_idx | CREATE INDEX generated_a_is_pres_1a68b2_idx ON public.generated_arrival_contact_documents USING btree (is_present_locally) |
| generated_a_salesfo_3df268_idx | CREATE INDEX generated_a_salesfo_3df268_idx ON public.generated_arrival_contact_documents USING btree (salesforce_ref) |
| generated_arrival_contact_documents_contact_id_c60c73ed | CREATE INDEX generated_arrival_contact_documents_contact_id_c60c73ed ON public.generated_arrival_contact_documents USING btree (contact_id) |
| generated_arrival_contact_documents_pkey | CREATE UNIQUE INDEX generated_arrival_contact_documents_pkey ON public.generated_arrival_contact_documents USING btree (id) |
| generated_arrival_contact_documents_placement_id_cc874157 | CREATE INDEX generated_arrival_contact_documents_placement_id_cc874157 ON public.generated_arrival_contact_documents USING btree (placement_id) |
Generated by tbls