Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| helper_verification_renewal_id | int8 |
|
|
A unique ID assigned to each helper verification renewal, e.g. 15. |
|||
| helper_verification_id | int8 |
|
|
The ID of the verification that the helper needs for renewal, e.g. 20. |
|||
| helper_id | int8 |
|
|
The ID of the helper that is the subject of the verification renewal, e.g. 14. |
|||
| expires_on | date |
|
|
The time the verification expires in UTC. |
|||
| status | varchar |
|
|
Cancelled: A renewal is no longer being renewed or collected. Recollecting: The uploaded file is not valid. Approved: Updates the existing helper verification with the updated file and expiry date. Received: When a new verification file is received. Pending: This is the default status. |
|||
| created_at | timestamp |
|
|
The time that the verification renewal was created in UTC, e.g.2021-03-02 00:15:49.996204. |
|||
| updated_at | timestamp |
|
|
The time that the verification renewal was updated in UTC, e.g.2021-03-02 00:15:49.996204. |
|||
| new_file_id | int8 |
|
|
The file ID of the new verification form, e.g. 83375. |
|||
| previous_file_id | int8 |
|
|
The file ID of the previous verification form, e.g. 95537. |
|||
| ticket_id | int8 |
|
|
The ID of the ticket associated with the verification renewal, e.g. 9525. |
|||
| company_id | int8 |
|
|
The ID of the company that the associated ticket is linked to, e.g. 95. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_helper_verification_renewals_pkey | Primary key | Asc | helper_verification_renewal_id |
| fct_helper_verification_renewals_company_id_idx | Performance | Asc | company_id |
| fct_helper_verification_renewals_helper_verification_id_idx | Performance | Asc | helper_verification_id |