scorm_scoes_track

Columns

Related columns Constraint Comments

Search:

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

BIGINT

19

√

null

userid

BIGINT

19

0

user.id

Implied ConstraintR

scormid

BIGINT

19

0

scorm.id

scorscoetrac_sco3_fkR

scoid

BIGINT

19

0

scorm_scoes.id

scorscoetrac_sco4_fkR

attempt

BIGINT

19

1

element

VARCHAR

255

value

LONGTEXT

2147483647

null

timemodified

BIGINT

19

0

Showing 1 to 8 of 8 entries

Indexes

Search:

Constraint Name	Type	Sort	Column(s)
PRIMARY	Primary key	Asc	id
scorscoetrac_ele2_ix	Performance	Asc	element
scorscoetrac_sco6_ix	Performance	Asc	scormid
scorscoetrac_sco8_ix	Performance	Asc	scoid
scorscoetrac_use2_ix	Performance	Asc	userid
scorscoetrac_usescoscoatt2_uix	Must be unique	Asc/Asc/Asc/Asc/Asc	userid + scormid + scoid + attempt + element

Showing 1 to 6 of 6 entries

Description

Columns

Indexes

Relationships

Close relationships within degrees of separation