Totara Learn 11
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Facetoface Asset Info Data Table Schema (facetoface_asset_info_data)
Description
Stores custom field data related to assets
facetoface_asset_info_data table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
facetoface_asset_info_data_param
.dataid
faceasseinfodatapara_dat2_fk
R
data
LONGTEXT
2147483647
√
null
fieldid
BIGINT
19
null
facetoface_asset_info_field
.id
faceasseinfodata_fie2_fk
R
facetofaceassetid
BIGINT
19
null
facetoface_asset
.id
faceasseinfodata_fac2_fk
R
Showing 1 to 4 of 4 entries
Table contained
-1
rows
facetoface_asset_info_data table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
faceasseinfodata_fac_ix
Performance
Asc
facetofaceassetid
faceasseinfodata_fie_ix
Performance
Asc
fieldid
faceasseinfodata_fiefac_uix
Must be unique
Asc
/
Asc
fieldid + facetofaceassetid
Showing 1 to 4 of 4 entries
facetoface_asset_info_data table relationships
Close relationships within degrees of separation
One
Two degrees
