Schema reference

Declared schema · schema.sql · not a live database

tables

columns

references

enums

Diagram

Left to right by dependency: a table sits right of everything it references, so this order is one the tables can be created in.

Column	Type	Null	Key	Default	References	Comment
id	INTEGER	—	primary
name	VARCHAR(120)	—

Column	Type	Null	Key	References
id	INTEGER	—	primary
book_id	INTEGER	—		→ books(id)
tag_id	INTEGER	—		→ tags(id)

Column	Type	Null	Key	References
id	INTEGER	—	primary
author_id	INTEGER	—		→ authors(id)
title	VARCHAR(240)	—
summary	TEXT	null