facetoface table columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | BIGINT | 19 | √ | null |
|
|
||||||
| course | BIGINT | 19 | 0 |
|
|
|||||||
| name | VARCHAR | 255 | √ | null |
|
|
||||||
| intro | LONGTEXT | 2147483647 | √ | null |
|
|
intro |
|||||
| introformat | TINYINT | 3 | 0 |
|
|
introformat |
||||||
| thirdparty | VARCHAR | 255 | √ | null |
|
|
email address of a third party involved in this activity |
|||||
| thirdpartywaitlist | BIT | 1 | 0 |
|
|
Set to 1 if the third party wants to receive signups/cancellations about wait-listed sessions, 0 otherwise. |
||||||
| display | BIGINT | 19 | 0 |
|
|
|||||||
| timecreated | BIGINT | 19 | 0 |
|
|
|||||||
| timemodified | BIGINT | 19 | 0 |
|
|
|||||||
| shortname | VARCHAR | 32 | √ | null |
|
|
||||||
| showoncalendar | BIT | 1 | 1 |
|
|
|||||||
| usercalentry | BIT | 1 | 1 |
|
|
|||||||
| multiplesessions | BIT | 1 | √ | 0 |
|
|
||||||
| completionstatusrequired | VARCHAR | 255 | √ | null |
|
|
||||||
| managerreserve | SMALLINT | 5 | √ | 0 |
|
|
Can managers make reservations/bookings on behalf of their team |
|||||
| maxmanagerreserves | INT | 10 | √ | 1 |
|
|
How many reservations can each manager make |
|||||
| reservecanceldays | INT | 10 | √ | 1 |
|
|
Number days before the session when all unconfirmed reservations are deleted |
|||||
| reservedays | INT | 10 | √ | 2 |
|
|
Number days before the session when reservations are closed |
|||||
| declareinterest | BIT | 1 | 0 |
|
|
Allow users to declare interest in the facetoface |
||||||
| interestonlyiffull | BIT | 1 | 0 |
|
|
Only allow users to declare interest if all sessions are full |
||||||
| allowcancellationsdefault | BIT | 1 | 1 |
|
|
|||||||
| cancellationscutoffdefault | BIGINT | 19 | 86400 |
|
|
|||||||
| selectjobassignmentonsignup | BIT | 1 | 0 |
|
|
Users with multiple job assignments will select one on signup |
||||||
| forceselectjobassignment | BIT | 1 | 0 |
|
|
Error if no suitable job assignment is available when signing up |
||||||
| approvaltype | BIGINT | 19 | 0 |
|
|
|||||||
| approvalrole | BIGINT | 19 | √ | null |
|
|
||||||
| approvalterms | LONGTEXT | 2147483647 | √ | null |
|
|
||||||
| approvaladmins | VARCHAR | 255 | √ | null |
|
|
||||||
| multisignupfully | BIT | 1 | 0 |
|
|
|||||||
| multisignuppartly | BIT | 1 | 0 |
|
|
|||||||
| multisignupnoshow | BIT | 1 | 0 |
|
|
|||||||
| multisignupmaximum | BIGINT | 19 | 0 |
|
|
|||||||
| waitlistautoclean | BIT | 1 | 0 |
|
|
Table contained -1 rows
facetoface table indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| face_cou_ix | Performance | Asc | course |
facetoface table relationships
Close relationships within degrees of separation
