app_repository_opensesame_bps

0 rows


Description

Link an OpenSesame course to a bundle

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_repository_opensesame_bps_id_seq'::regclass)
bundleid int8 19 null
app_repository_opensesame_bdls.id Defined in XMLR
packageid int8 19 null
app_repository_opensesame_pkgs.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_repoopenbps_id_pk Primary key Asc id
app_repoopenbps_bun_ix Performance Asc bundleid
app_repoopenbps_bunpac_uix Must be unique Asc/Asc bundleid + packageid
app_repoopenbps_pac_ix Performance Asc packageid

Relationships

Close relationships within degrees of separation