Lesson Pages Table Schema (lesson_pages)


Description

Defines lesson_pages

lesson_pages table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
lesson_answers.pageid lessansw_pag2_fk R
lesson_attempts.pageid lessatte_pag2_fk R
lesson_branch.pageid lessbran_pag2_fk R
lessonid BIGINT 19 0
lesson.id lesspage_les2_fk R
prevpageid BIGINT 19 0
nextpageid BIGINT 19 0
qtype SMALLINT 5 0
qoption SMALLINT 5 0
layout SMALLINT 5 1
display SMALLINT 5 1
timecreated BIGINT 19 0
timemodified BIGINT 19 0
title VARCHAR 255
contents LONGTEXT 2147483647 null
contentsformat TINYINT 3 0

Table contained -1 rows

lesson_pages table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
lesspage_les_ix Performance Asc lessonid

lesson_pages table relationships