Table studip30.config Generated by
SchemaSpy
Legend: SourceForge.net
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
config_id varchar 32
extern_config.config_id Implied Constraint R
parent_id varchar 32
field varchar 255
value text 65535
is_default tinyint 3 0
type enum 8 boolean
range enum 7 global
section varchar 255
position int 10 0
mkdate int 10 0
chdate int 10 0
description varchar 255
comment text 65535
message_template varchar 255

Table contained 135 rows at Do Aug 02 15:05 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
config_id Primary key Asc PRIMARY
field + range Performance Asc/Asc field
parent_id Performance Asc parent_id

Close relationships: