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 10 null
lessonid bigint 10 0
lesson.id lessbran_les2_fk R
userid bigint 10 0
user.id Implied Constraint R
pageid bigint 10 0
lesson_pages.id lessbran_pag2_fk R
retry bigint 10 0
flag smallint 3 0
timeseen bigint 10 0
nextpageid bigint 10 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