Book Chapters Table Schema (book_chapters)


Description

Defines book_chapters

book_chapters table columns

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

Table contained -1 rows

book_chapters table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
bookchap_boo_fk Performance Asc bookid

book_chapters table relationships

Close relationships within degrees of separation