Org Type Info Data Table Schema (org_type_info_data)


Description

Stores custom field data related to organisations

org_type_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
org_type_info_data_param.dataid orgtypeinfodatapara_dat2_fk R
data LONGTEXT 2147483647 √ null
fieldid BIGINT 19 null
org_type_info_field.id orgtypeinfodata_fie2_fk R
organisationid BIGINT 19 null
org.id orgtypeinfodata_org2_fk R

Table contained -1 rows

org_type_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
orgtypeinfodata_fie_ix Performance Asc fieldid
orgtypeinfodata_fieorg_uix Must be unique Asc/Asc fieldid + organisationid
orgtypeinfodata_org_ix Performance Asc organisationid

org_type_info_data table relationships

Close relationships within degrees of separation