Schema diff
Declared schema · file · not a live database
4
tables
10
columns
2
references
0
enums
Diagram
addedchangedremoved
Left to right by dependency: a table sits right of everything it references, so this order is one the tables can be created in.
Tables
books
changed| Column | Type | Null | Key | Default | References | Comment |
|---|---|---|---|---|---|---|
| id | INTEGER | null | primary | |||
| author_id | INTEGER | — | → authors(id) | |||
| title | TEXT | — | '' |
legacy_notes
removed| Column | Type | Null | Key | Default | References | Comment |
|---|---|---|---|---|---|---|
| id | INTEGER | null | primary | |||
| body | TEXT | null |
reviews
added| Column | Type | Null | Key | Default | References | Comment |
|---|---|---|---|---|---|---|
| id | INTEGER | null | primary | |||
| book_id | INTEGER | — | → books(id) | |||
| rating | INTEGER | — |