Table a1b9088d.fields_meta_data 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
id char 36
name varchar 255  √  null
vname varchar 255  √  null
comments varchar 255  √  null
help varchar 255  √  null
custom_module varchar 255  √  null
type varchar 255  √  null
len int 11  √  null
required bit 1  √  0
default_value varchar 255  √  null
date_modified datetime 19  √  null
deleted bit 1  √  0
audited bit 1  √  0
massupdate bit 1  √  0
duplicate_merge smallint 6  √  0
reportable bit 1  √  1
importable varchar 255  √  null
ext1 varchar 255  √ 
ext2 varchar 255  √ 
ext3 varchar 255  √ 
ext4 text 65535  √  null
autoinc_next int 11  √  null

Analyzed at Fri Mar 05 08:49 UTC 2021

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc PRIMARY  
custom_module + name Must be unique Asc/Asc idx_fields_meta_data_custom_module_name These unique columns are also nullable
custom_module + deleted Performance Asc/Asc idx_meta_cm_del  
id + deleted Performance Asc/Asc idx_meta_id_del