Columns
| Column | Type | Children | Parents | Comments |
|---|---|---|---|---|
| id | int8 |
|
|
|
| company_id | int8 |
|
|
The foreign key to the company. @example 1 |
| payroll_award_agreements_higher_duty_id | int8 |
|
|
The foreign key to the higher duty. @example 1 |
| custom_funding_scheme_type_id | int8 |
|
|
The foreign key to the custom funding scheme type. @example 1 |
| created_at | timestamp |
|
|
|
| updated_at | timestamp |
|
|
|
| created_at_in_company_tz | timestamp |
|
|
|
| updated_at_in_company_tz | timestamp |
|
|
|
| company_timezone | varchar |
|
|
The company timezone. E.g. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| edge_payroll_award_agreements_higher_duties_custom_schemes_pkey | Primary key | Asc | id |
| idx_ae3a14314abdd2882b1308cc8fdf1242 | Performance | Asc | custom_funding_scheme_type_id |
| idx_d1fbccc252be175dd431057333a812df | Performance | Asc | payroll_award_agreements_higher_duty_id |
| idx_f1beed35f199e516cf797d195764b084 | Performance | Asc | company_id |