app_facetoface_sessions

0 rows


Description

A given facetoface activity may be given at different times and places

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_facetoface_sessions_id_seq'::regclass)
app_facetoface_notification_hist.sessionid Defined in XMLR
app_facetoface_notification_sent.sessionid Defined in XMLR
app_facetoface_session_info_data.facetofacesessionid Defined in XMLR
app_facetoface_session_roles.sessionid Defined in XMLR
app_facetoface_sessions_dates.sessionid Defined in XMLR
app_facetoface_signups.sessionid Defined in XMLR
facetoface int8 19 0
app_facetoface.id Defined in XMLR
capacity int8 19 0
allowoverbook int2 5 0
waitlisteveryone int2 5 0
details text 2147483647 √ null
datetimeknown int2 5 0
duration int8 19 √ null
normalcost varchar 255 '0'::character varying
discountcost varchar 255 '0'::character varying
roomid int8 19 0
app_facetoface_room.id Defined in XMLR
allowcancellations int2 5 1
cancellationcutoff int8 19 86400
timecreated int8 19 0
timemodified int8 19 0
usermodified int8 19 null
app_user.id Defined in XMLR
selfapproval int2 5 0
mincapacity int8 19 √ 0
cutoff int8 19 √ 86400
availablesignupnote int2 5 0

Indexes

Constraint Name Type Sort Column(s)
app_facesess_id_pk Primary key Asc id
app_facesess_fac_ix Performance Asc facetoface
app_facesess_roo_ix Performance Asc roomid
app_facesess_use_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation