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 |
|
|
Relationships
Close relationships within degrees of separation
