Facetoface Sessions Dates Table Schema (facetoface_sessions_dates)


Description

Describes sessions of event. Specifies the start time, end time and optionally room and assets. Sessions can be set over multiple days or blocks of time.

facetoface_sessions_dates table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
facetoface_asset_dates.sessionsdateid faceassedate_ses2_fk R
facetoface_notification_hist.sessiondateid facenotihist_ses4_fk R
sessionid BIGINT 19 0
facetoface_sessions.id facesessdate_ses2_fk R
sessiontimezone VARCHAR 100 √ null

Timezone used for display of dates and times, 99 means use user timeozone
roomid BIGINT 19 √ null
facetoface_room.id facesessdate_roo2_fk R

Foreign key to facetoface_room
timestart BIGINT 19 0
timefinish BIGINT 19 0

Table contained -1 rows

facetoface_sessions_dates table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
facesessdate_roo_ix Performance Asc roomid
facesessdate_ses_ix Performance Asc sessionid
facesessdate_sestim2_uix Must be unique Asc/Asc sessionid + timefinish
facesessdate_sestim_uix Must be unique Asc/Asc sessionid + timestart

facetoface_sessions_dates table relationships

Close relationships within degrees of separation