Moodle LMS 3.9
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
Book Chapters Table Schema (book_chapters)
Description
Defines book_chapters
book_chapters table columns
Related columns
Constraint
Comments
Search:
Column
Type
Size
Nulls
Auto
Default
Children
Parents
Comments
id
BIGINT
19
√
null
bookid
BIGINT
19
0
book
.id
bookchap_boo_fk
R
pagenum
BIGINT
19
0
subchapter
BIGINT
19
0
title
VARCHAR
255
content
LONGTEXT
2147483647
null
contentformat
SMALLINT
5
0
hidden
TINYINT
3
0
timecreated
BIGINT
19
0
timemodified
BIGINT
19
0
importsrc
VARCHAR
255
Showing 1 to 11 of 11 entries
Table contained
-1
rows
book_chapters table indexes
Search:
Constraint Name
Type
Sort
Column(s)
PRIMARY
Primary key
Asc
id
bookchap_boo_fk
Performance
Asc
bookid
Showing 1 to 2 of 2 entries
book_chapters table relationships
Close relationships within degrees of separation
One