app_facetoface_sessions_dates

0 rows


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.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_facetoface_sessions_dates_id_seq'::regclass)
app_facetoface_asset_dates.sessionsdateid Defined in XMLR
app_facetoface_notification_hist.sessiondateid Defined in XMLR
sessionid int8 19 0
app_facetoface_sessions.id Defined in XMLR
sessiontimezone varchar 100 √ null
roomid int8 19 √ null
app_facetoface_room.id Defined in XMLR
timestart int8 19 0
timefinish int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_facesessdate_id_pk Primary key Asc id
app_facesessdate_roo_ix Performance Asc roomid
app_facesessdate_ses_ix Performance Asc sessionid
app_facesessdate_sestim2_uix Must be unique Asc/Asc sessionid + timefinish
app_facesessdate_sestim_uix Must be unique Asc/Asc sessionid + timestart

Relationships

Close relationships within degrees of separation