Pos Type Info Data Table Schema (pos_type_info_data)


Description

Stores custom field data related to positions

pos_type_info_data table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
pos_type_info_data_param.dataid postypeinfodatapara_dat2_fk R
fieldid BIGINT 19 null
pos_type_info_field.id postypeinfodata_fie2_fk R
positionid BIGINT 19 null
pos.id postypeinfodata_pos2_fk R
data LONGTEXT 2147483647 √ null

Table contained -1 rows

pos_type_info_data table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
postypeinfodata_fie_ix Performance Asc fieldid
postypeinfodata_fiepos_uix Must be unique Asc/Asc fieldid + positionid
postypeinfodata_pos_ix Performance Asc positionid

pos_type_info_data table relationships

Close relationships within degrees of separation