SchemaSpy - Table testsql_comments.systempreferences

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default	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

Indexes:

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