ple_assessment_response_keys

3019315 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
assessment_responses_id CHAR 36 null
ple_assessment_responses.id ple_assessment_response_keys_assessment_responses_id_foreign R
assessment_question_id CHAR 36 null
ple_assessment_questions.id ple_assessment_response_keys_assessment_question_id_foreign R
assessment_option_id CHAR 36 √ null
ple_assessment_options.id ple_assessment_response_keys_assessment_option_id_foreign R
response_text VARCHAR 125 √ null
created_by CHAR 36 null
users.id ple_assessment_response_keys_created_by_foreign R
tenant_id CHAR 36 null
tenants.id ple_assessment_response_keys_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_response_keys_assessment_option_id_foreign Performance Asc assessment_option_id
ple_assessment_response_keys_assessment_question_id_foreign Performance Asc assessment_question_id
ple_assessment_response_keys_assessment_responses_id_foreign Performance Asc assessment_responses_id
ple_assessment_response_keys_created_by_foreign Performance Asc created_by
ple_assessment_response_keys_tenant_id_foreign Performance Asc tenant_id

Relationships

Close relationships within degrees of separation