Table ab509734.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 varchar 255
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

Analyzed at Mon Jun 15 09:01 UTC 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
custom_module + deleted Performance Asc/Asc idx_meta_cm_del
id + deleted Performance Asc/Asc idx_meta_id_del