Tables


SchemaSpy Analysis of /host/demo_export.db

Generated on Sun Nov 06 14:02 GMT 2022

Insertion Order Deletion Order
TABLES 19
VIEWS 0
COLUMNS 107
Constraints 8
Anomalies 10
Routines 0

Database Properties

Database Type: SQLite - 3.36.0

Tables

Table / View Children Parents Columns Rows Type Comments
fields 0 0 3 34872 Table
response_textvars 0 1 3 15686 Table
respondents 1 1 6 891 Table
protocols 2 1 5 172 Table
professionals 3 0 3 227 Table
response_values 0 3 5 3096891 Table
protocol_subscriptions 0 3 8 409 Table
question_options 0 0 5 98132 Table
non_responses 1 0 7 63008 Table
measurements 1 2 8 295 Table
response_flags 0 1 3 54726 Table
questions 0 1 6 28752 Table
responses 4 8 22 67722 Table
response_scores 0 1 4 26104 Table
questionnaires 8 0 6 686 Table
teams 1 0 3 21 Table
scores 0 2 6 4819 Table
dossiers 3 0 3 454 Table
schema_info 0 0 1 1 Table