responses

67722 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INTEGER 2000000000,10 √ null
response_flags.response_id C
response_scores.response_id C
response_textvars.response_id C
response_values.response_id C
dossier_id INTEGER 2000000000,10 √ null
dossiers.id C
non_response_id INTEGER 2000000000,10 √ null
non_responses.id C
respondent_id INTEGER 2000000000,10 √ null
respondents.id C
entered_by_id INTEGER 2000000000,10 √ null
professionals.id C
measurement_id INTEGER 2000000000,10 √ null
measurements.id C
team_id INTEGER 2000000000,10 √ null
teams.id C
questionnaire_key VARCHAR(255) 2000000000,10 √ null
questionnaires.key Implied ConstraintR
questionnaire_variant VARCHAR(255) 2000000000,10 √ null
status VARCHAR(255) 2000000000,10 √ null
open_from TIMESTAMP 2000000000,10 √ null
open_till TIMESTAMP 2000000000,10 √ null
started_at TIMESTAMP 2000000000,10 √ null
completed_at TIMESTAMP 2000000000,10 √ null
observation_time TIMESTAMP 2000000000,10 √ null
anonymous BOOLEAN 2000000000,10 √ null
notes TEXT 2000000000,10 √ null
_sync TIMESTAMP 2000000000,10 √ null
_sync_quby TIMESTAMP 2000000000,10 √ null
requester_id INTEGER 2000000000,10 √ null
professionals.id C
hide_pii_from_researchers BOOLEAN 2000000000,10 √ null
hide_values_from_professionals BOOLEAN 2000000000,10 √ null

Indexes

Constraint Name Type Sort Column(s)
responses_s_pk Primary key Asc id

Relationships

Close relationships within degrees of separation