Columns
| Column | Type | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|
| helper_verification_id | int8 |
|
|
The ID associated to the helper verification, e.g. 546 |
|||
| helper_id | int8 |
|
|
The ID of the helper that is the subject of the verification, e.g. 14. |
|||
| profile_id | int4 |
|
|
The profile ID of the helper that is the subject of the verification, e.g. 10. |
|||
| verification_id | int8 |
|
|
The ID of the verification, e.g. 20. |
|||
| verification | varchar |
|
|
The name of the verification, e.g. |
|||
| verification_file_type_id | int8 |
|
|
The ID of the verification file type, e.g. 5. |
|||
| verification_file_type | varchar |
|
|
There can be different files associated with a specific verification, e.g. |
|||
| created_at | timestamp |
|
|
The time that the verification was created in UTC, e.g.2021-03-02 00:15:49.996204. |
|||
| expires_on | date |
|
|
||||
| state | text |
|
|
Whether the verification is one of |
|||
| days_to_expiry | int4 |
|
|
The number of days remaining until the verification expires, e.g. 154. |
|||
| company_id | int8 |
|
|
The company ID, e.g.: 345. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| fct_helper_verifications_pkey | Primary key | Asc | helper_verification_id |
| fct_helper_verifications_company_id_idx | Performance | Asc | company_id |
| fct_helper_verifications_helper_id_idx | Performance | Asc | helper_id |