Facetoface Asset Table Schema (facetoface_asset)


Table for storing seminar assets data

facetoface_asset table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
facetoface_asset_dates.assetid faceassedate_ass2_fk R
facetoface_asset_info_data.facetofaceassetid faceasseinfodata_fac2_fk R
name VARCHAR 100 null
allowconflicts BIT 1 0
description LONGTEXT 2147483647 null
custom BIT 1 0

1 means room is created secifically for one session only and cannot be reused

hidden BIT 1 0

Do not show this asset in add/search asset dialogs

usercreated BIGINT 19 null
user.id faceasse_use3_fk R

user id who created the asset

usermodified BIGINT 19 null
user.id faceasse_use4_fk R

user id who modified the asset

timecreated BIGINT 19 0
timemodified BIGINT 19 0

Table contained -1 rows

facetoface_asset table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
faceasse_cus_ix Performance Asc custom
faceasse_use2_ix Performance Asc usermodified
faceasse_use_ix Performance Asc usercreated

facetoface_asset table relationships