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 10 null
lesson_answers.pageid lessansw_pag2_fk R
lesson_attempts.pageid lessatte_pag2_fk R
lesson_branch.pageid lessbran_pag2_fk R
lessonid bigint 10 0
lesson.id lesspage_les2_fk R
prevpageid bigint 10 0
nextpageid bigint 10 0
qtype smallint 3 0
qoption smallint 3 0
layout smallint 3 1
display smallint 3 1
timecreated bigint 10 0
timemodified bigint 10 0
title varchar 255
contents longtext 2147483647 null
contentsformat tinyint 2 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