Lesson Branch Table Schema (lesson_branch)


Description

branches for each lesson/user

lesson_branch table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
lessonid BIGINT 19 0
lesson.id lessbran_les2_fk R
userid BIGINT 19 0
user.id Implied Constraint R
pageid BIGINT 19 0
lesson_pages.id lessbran_pag2_fk R
retry BIGINT 19 0
flag SMALLINT 5 0
timeseen BIGINT 19 0
nextpageid BIGINT 19 0

Table contained -1 rows

lesson_branch table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lessbran_les_ix Performance Asc lessonid
lessbran_pag_ix Performance Asc pageid
lessbran_use_ix Performance Asc userid

lesson_branch table relationships

Close relationships within degrees of separation