public.employment_contracts¶
Columns¶
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| created_at | timestamp with time zone | false | ||||
| end_date | date | true | ||||
| hours_per_week | numeric(5,2) | true | ||||
| id | bigint | false | public.generated_employment_contract_documents | |||
| salesforce_ref | varchar(255) | false | ||||
| start_date | date | false | ||||
| updated_at | timestamp with time zone | false | ||||
| worker_id | bigint | false | public.contacts |
Constraints¶
| Name | Type | Definition |
|---|---|---|
| employment_contract_end_after_start | CHECK | CHECK (((end_date IS NULL) OR (end_date >= start_date))) |
| employment_contracts_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| employment_contracts_worker_id_2448b089_fk_contacts_id | FOREIGN KEY | FOREIGN KEY (worker_id) REFERENCES contacts(id) DEFERRABLE INITIALLY DEFERRED |
Indexes¶
| Name | Definition |
|---|---|
| employment__salesfo_9236f1_idx | CREATE INDEX employment__salesfo_9236f1_idx ON public.employment_contracts USING btree (salesforce_ref) |
| employment_contracts_pkey | CREATE UNIQUE INDEX employment_contracts_pkey ON public.employment_contracts USING btree (id) |
| employment_contracts_worker_id_2448b089 | CREATE INDEX employment_contracts_worker_id_2448b089 ON public.employment_contracts USING btree (worker_id) |
Generated by tbls