ple_assessment_options

5966 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
ple_assessment_response_keys.assessment_option_id ple_assessment_response_keys_assessment_option_id_foreign R
assessment_question_id CHAR 36 null
ple_assessment_questions.id ple_assessment_options_assessment_question_id_foreign C
option VARCHAR 1000 null
sort_order INT 10 null
is_correct_option BIT 1 √ 1

correct - True | incorrect - False | null - NA
score FLOAT 5,2 √ 0.00
created_by CHAR 36 null
users.id ple_assessment_options_created_by_foreign R
tenant_id CHAR 36 null
tenants.id ple_assessment_options_tenant_id_foreign R
created_at TIMESTAMP 19 √ null
updated_at TIMESTAMP 19 √ null
deleted_at TIMESTAMP 19 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ple_assessment_options_assessment_question_id_foreign Performance Asc assessment_question_id
ple_assessment_options_created_by_foreign Performance Asc created_by
ple_assessment_options_tenant_id_foreign Performance Asc tenant_id

Relationships

Close relationships within degrees of separation