Table testsql_comments.systempreferences Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
variable varchar 50 system preference name
value mediumtext 16777215  √  null system preference values
options longtext 2147483647  √  null options for multiple choice system preferences
explanation mediumtext 16777215  √  null descriptive text for the system preference
type varchar 20  √  null type of question this preference asks (multiple choice, plain text, yes or no, etc)

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

Column(s) Type Sort Constraint Name
variable Primary key Asc PRIMARY