public.generated_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 | ||||
| salesforce_ref | varchar(255) | false | ||||
| sharepoint_ref | varchar(255) | false | ||||
| signed_file | varchar(100) | false | ||||
| type | varchar(100) | false |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| generated_contact_documents_contact_id_c89a8d1e_fk_contacts_id | FOREIGN KEY | FOREIGN KEY (contact_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED |
| generated_contact_documents_pkey | PRIMARY KEY | PRIMARY KEY (id) |
Indexes¶
| Name | Definition |
|---|---|
| generated_c_is_pres_b93436_idx | CREATE INDEX generated_c_is_pres_b93436_idx ON public.generated_contact_documents USING btree (is_present_locally) |
| generated_c_salesfo_481885_idx | CREATE INDEX generated_c_salesfo_481885_idx ON public.generated_contact_documents USING btree (salesforce_ref) |
| generated_contact_documents_contact_id_c89a8d1e | CREATE INDEX generated_contact_documents_contact_id_c89a8d1e ON public.generated_contact_documents USING btree (contact_id) |
| generated_contact_documents_pkey | CREATE UNIQUE INDEX generated_contact_documents_pkey ON public.generated_contact_documents USING btree (id) |
Generated by tbls