Question Dataset Definitions Table Schema (question_dataset_definitions)


Description

Organises and stores properties for dataset items

question_dataset_definitions table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
question_datasets.datasetdefinition quesdata_dat2_fk R
category BIGINT 19 0
question_categories.id quesdatadefi_cat2_fk R
name VARCHAR 255
type BIGINT 19 0
options VARCHAR 255
itemcount BIGINT 19 0

Table contained -1 rows

question_dataset_definitions table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
quesdatadefi_cat_ix Performance Asc category

question_dataset_definitions table relationships