Question Datasets Table Schema (question_datasets)


Description

Many-many relation between questions and dataset definitions

question_datasets table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
question BIGINT 19 0
question.id quesdata_que2_fk R
datasetdefinition BIGINT 19 0
question_dataset_definitions.id quesdata_dat2_fk R

Table contained -1 rows

question_datasets table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesdata_dat_ix Performance Asc datasetdefinition
quesdata_que_ix Performance Asc question
quesdata_quedat_ix Performance Asc/Asc question + datasetdefinition

question_datasets table relationships

Close relationships within degrees of separation