| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| visible |
BIT |
1 |
|
|
1 |
|
|
Is this course package visible? |
| zipfilename |
VARCHAR |
255 |
|
|
|
|
|
|
| title |
VARCHAR |
1333 |
|
|
|
|
|
OpenSesame course title |
| expirationdate |
VARCHAR |
20 |
|
|
|
|
|
Date the license is valid until as text |
| mobilecompatibility |
VARCHAR |
255 |
|
|
|
|
|
Options are allDevices, ios, android and empty |
| externalid |
VARCHAR |
255 |
|
|
|
|
|
OpenSesame course identifier - unique id |
| description |
LONGTEXT |
2147483647 |
|
|
null |
|
|
OpenSesame course description |
| duration |
VARCHAR |
20 |
|
|
|
|
|
Duration of course |
| timecreated |
BIGINT |
19 |
|
|
null |
|
|
Date when package added |
| timemodified |
BIGINT |
19 |
|
|
null |
|
|
Date when package last modified |