app_facetoface_notification

0 rows


Description

Facetoface notifications

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_facetoface_notification_id_seq'::regclass)
app_facetoface_notification_hist.notificationid Defined in XMLR
app_facetoface_notification_sent.notificationid Defined in XMLR
type int2 5 null
conditiontype int8 19 √ null
scheduleunit int2 5 √ null
scheduleamount int2 5 √ null
scheduletime int8 19 √ null
ccmanager int2 5 0
managerprefix text 2147483647 √ null
title varchar 255 ''::character varying
body text 2147483647 null
booked int2 5 0
waitlisted int2 5 0
cancelled int2 5 0
courseid int8 19 null
app_course.id Defined in XMLR
facetofaceid int8 19 null
app_facetoface.id Defined in XMLR
status int2 5 0
issent int2 5 0
timemodified int8 19 √ null
usermodified int8 19 √ null
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_facenoti_id3_pk Primary key Asc id
app_facenoti_cou_ix Performance Asc courseid
app_facenoti_fac_ix Performance Asc facetofaceid
app_facenoti_iss_ix Performance Asc issent
app_facenoti_sta_ix Performance Asc status
app_facenoti_tit_ix Performance Asc title
app_facenoti_typ_ix Performance Asc type
app_facenoti_use_ix Performance Asc usermodified

Relationships

Close relationships within degrees of separation