app_facetoface_sessions_dates

0 rows


Description

Describes sessions of event. Specifies the start time, end time. 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_facilitator_dates.sessionsdateid Defined in XMLR
app_facetoface_notification_hist.sessiondateid Defined in XMLR
app_facetoface_room_dates.sessionsdateid Defined in XMLR
app_facetoface_room_dates_virtualmeeting.sessionsdateid Defined in XMLR
app_facetoface_signups_dates_status.sessiondateid Defined in XMLR
sessionid int8 19 0
app_facetoface_sessions.id Defined in XMLR
sessiontimezone varchar 100 √ null
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_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