Prog Completion Log table / prog_completion_log - Totara Learn 11 Database schema / Zoola Analytics

prog_completion_log table columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

programid

BIGINT

19

null

prog.id

progcomplog_pro2_fk R

Program ID

userid

BIGINT

19

√

null

user.id

progcomplog_use2_fk R

Users id

changeuserid

BIGINT

19

√

null

user.id

progcomplog_cha2_fk R

User id of the person who caused the change

description

LONGTEXT

2147483647

null

Description of what changed, English only

timemodified

BIGINT

19

null

Showing 1 to 6 of 6 entries

Table contained -1 rows

prog_completion_log table indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
progcomplog_cha_ix	Performance	Asc	changeuserid
progcomplog_pro_ix	Performance	Asc	programid
progcomplog_use_ix	Performance	Asc	userid

Showing 1 to 4 of 4 entries

Prog Completion Log Table Schema (prog_completion_log)

Description

prog_completion_log table columns

prog_completion_log table indexes

prog_completion_log table relationships

Close relationships within degrees of separation