lesson_pages

0 rows


Description

Defines lesson_pages

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
lesson_answers.pageid lessansw_pag2_fkR
lesson_attempts.pageid lessatte_pag2_fkR
lesson_branch.pageid lessbran_pag2_fkR
lessonid BIGINT 19 0
lesson.id lesspage_les2_fkR
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

Indexes

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

Relationships