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 text 65535  √  null system preference values
options mediumtext 16777215  √  null options for multiple choice system preferences
explanation text 65535  √  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 Tue Dec 27 18:01 NZDT 2016

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