Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
---|---|---|---|---|---|---|---|---|---|---|
id | int4 | 10 | √ | null |
|
|
||||
serial | varchar | 2147483647 | √ | null |
|
|
||||
name | varchar | 2147483647 | √ | null |
|
|
||||
template_code | varchar | 2147483647 | √ | null |
|
|
||||
template_name | varchar | 2147483647 | √ | null |
|
|
||||
applicant | varchar | 2147483647 | √ | null |
|
|
||||
org_name | varchar | 2147483647 | √ | null |
|
|
||||
stage | varchar | 2147483647 | √ | null |
|
|
||||
stage_colour | varchar | 2147483647 | √ | null |
|
|
||||
status | application_status | 2147483647 | √ | null |
|
|
||||
outcome | application_outcome | 2147483647 | √ | null |
|
|
||||
last_active_date | timestamptz | 35,6 | √ | null |
|
|
||||
assigners | _varchar | 2147483647 | √ | null |
|
|
||||
reviewers | _varchar | 2147483647 | √ | null |
|
|
||||
reviewer_action | reviewer_action | 2147483647 | √ | null |
|
|
||||
assigner_action | assigner_action | 2147483647 | √ | null |
|
|
||||
is_fully_assigned_level_1 | bool | 1 | √ | null |
|
|
||||
assigned_questions_level_1 | int8 | 19 | √ | null |
|
|
||||
total_questions | int8 | 19 | √ | null |
|
|