Facetoface Room Table Schema (facetoface_room)


Description

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

Close relationships within degrees of separation