Facetoface Room Table Schema (facetoface_room)


Table for storing seminar room data

facetoface_room table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
facetoface_room_info_data.facetofaceroomid faceroominfodata_fac2_fk R
facetoface_sessions_dates.roomid facesessdate_roo2_fk R
name VARCHAR 100 null
capacity BIGINT 19 0
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 room in add/search room dialogs

usercreated BIGINT 19 null
user.id faceroom_use3_fk R

user id who created the room

usermodified BIGINT 19 null
user.id faceroom_use4_fk R

user id who modified the room

timecreated BIGINT 19 0
timemodified BIGINT 19 0

Table contained -1 rows

facetoface_room table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
faceroom_cus_ix Performance Asc custom
faceroom_use2_ix Performance Asc usermodified
faceroom_use_ix Performance Asc usercreated

facetoface_room table relationships