Prog User Assignment table / prog_user_assignment - Totara Learn 11 Database schema / Zoola Analytics

prog_user_assignment table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

programid

BIGINT

19

0

prog.id

Implied Constraint R

userid

BIGINT

19

0

user.id

Implied Constraint R

assignmentid

BIGINT

19

0

timeassigned

BIGINT

19

0

exceptionstatus

BIGINT

19

0

Showing 1 to 6 of 6 entries

Table contained -1 rows

prog_user_assignment table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
proguserassi_ass_ix	Performance	Asc	assignmentid
proguserassi_exc_ix	Performance	Asc	exceptionstatus
proguserassi_pro_ix	Performance	Asc	programid
proguserassi_prouseass_uix	Must be unique	Asc/Asc/Asc	programid + userid + assignmentid
proguserassi_use_ix	Performance	Asc	userid

Showing 1 to 6 of 6 entries

Prog User Assignment Table Schema (prog_user_assignment)

Description

prog_user_assignment table columns

prog_user_assignment table indexes

prog_user_assignment table relationships

Close relationships within degrees of separation