0 rows


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.


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 Defined in XMLR
sessiontimezone varchar 100 null
roomid int8 19 null Defined in XMLR
timestart int8 19 0
timefinish int8 19 0


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