public.generated_employment_contract_documents¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| created_at | timestamp with time zone | false | ||||
| employment_contract_id | bigint | false | public.employment_contracts | |||
| 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_employment_contract_documents_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| generated_employment_employment_contract__8b1de1db_fk_employmen | FOREIGN KEY | FOREIGN KEY (employment_contract_id) REFERENCES employment_contracts(id) DEFERRABLE INITIALLY DEFERRED |
Indexes¶
| Name | Definition |
|---|---|
| generated_e_is_pres_e32ca4_idx | CREATE INDEX generated_e_is_pres_e32ca4_idx ON public.generated_employment_contract_documents USING btree (is_present_locally) |
| generated_e_salesfo_e1da73_idx | CREATE INDEX generated_e_salesfo_e1da73_idx ON public.generated_employment_contract_documents USING btree (salesforce_ref) |
| generated_employment_contr_employment_contract_id_8b1de1db | CREATE INDEX generated_employment_contr_employment_contract_id_8b1de1db ON public.generated_employment_contract_documents USING btree (employment_contract_id) |
| generated_employment_contract_documents_pkey | CREATE UNIQUE INDEX generated_employment_contract_documents_pkey ON public.generated_employment_contract_documents USING btree (id) |
Generated by tbls