app_facetoface_sessions

0 rows


Description

Describes seminar events

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_sessioncancel_info_data.facetofacesessioncancelid 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
normalcost varchar 255 '0'::character varying
discountcost varchar 255 '0'::character varying
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
sendcapacityemail int2 5 √ 0
registrationtimestart int8 19 0
registrationtimefinish int8 19 0
cancelledstatus 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_use_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation