Repository Opensesame Pkgs Table Schema (repository_opensesame_pkgs)


Description

Totara OpenSesame course packages

repository_opensesame_pkgs table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
repository_opensesame_bps.packageid repoopenbps_pac2_fk R
visible BIT 0 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

Table contained -1 rows

repository_opensesame_pkgs table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repoopenpkgs_ext_uix Must be unique Asc externalid

repository_opensesame_pkgs table relationships