Facetoface Asset Table Schema (facetoface_asset)


Description

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

Close relationships within degrees of separation