Repository Opensesame Bps Table Schema (repository_opensesame_bps)


Description

Link an OpenSesame course to a bundle

repository_opensesame_bps table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
bundleid BIGINT 19 null
repository_opensesame_bdls.id repoopenbps_bun2_fk R
packageid BIGINT 19 null
repository_opensesame_pkgs.id repoopenbps_pac2_fk R

Table contained -1 rows

repository_opensesame_bps table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
repoopenbps_bun_ix Performance Asc bundleid
repoopenbps_bunpac_uix Must be unique Asc/Asc bundleid + packageid
repoopenbps_pac_ix Performance Asc packageid

repository_opensesame_bps table relationships

Close relationships within degrees of separation