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 XML R
app_facetoface_facilitator_dates.sessionsdateid Defined in XML R
app_facetoface_notification_hist.sessiondateid Defined in XML R
app_facetoface_room_dates.sessionsdateid Defined in XML R
app_facetoface_room_dates_virtualmeeting.sessionsdateid Defined in XML R
app_facetoface_signups_dates_status.sessiondateid Defined in XML R
sessionid int8 19 0
app_facetoface_sessions.id Defined in XML R
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