fields_meta_data


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
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 10 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 5 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 10 null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_fields_meta_data_custom_module_name Must be unique Asc/Asc custom_module + name

Relationships