home screens tables
This page is generated by bin/prototype.hs table-html prototype_metadata.
prototype_metadata
The metadata table contains the metadata block extracted from Markdown source files. In addition of the path to the file (as the source column), there is a type column, currently fixed to markdown (in case some other source files contain metadata that we would want in this table). Its records are automatically inserted by db.Makefile.
CREATE TABLE prototype_metadata (
source TEXT PRIMARY KEY,
type TEXT NOT NULL,
data JSON
);
Defined: sql/prototype.sql:34
source type data
------------------------------- -------- ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
screens/view-item.md markdown {"screen":"VIEW","destination":"screens/view-item.html","ids":"SELECT id FROM items","route":"/item/:id","query":"SELECT json_object(‘id’, id, ‘description’, description, ‘status’, status) FROM items WHERE id=?","source":"screens/view-item.md","type":"markdown"}
README.md markdown {"destination":"README.html","source":"README.md","type":"markdown"}
tables/prototype_screens.md markdown {"destination":"tables/prototype_screens.html","source":"tables/prototype_screens.md","type":"markdown"}
tables/sqlite_sequence.md markdown {"destination":"tables/sqlite_sequence.html","source":"tables/sqlite_sequence.md","type":"markdown"}
tables/prototype_sources.md markdown {"destination":"tables/prototype_sources.html","source":"tables/prototype_sources.md","type":"markdown"}
tables/prototype_directories.md markdown {"destination":"tables/prototype_directories.html","source":"tables/prototype_directories.md","type":"markdown"}
tables/prototype_pages.md markdown {"destination":"tables/prototype_pages.html","source":"tables/prototype_pages.md","type":"markdown"}
tables/items.md markdown {"destination":"tables/items.html","source":"tables/items.md","type":"markdown"}
tables/prototype_metadata.md markdown {"destination":"tables/prototype_metadata.html","source":"tables/prototype_metadata.md","type":"markdown"}
pages/index.md markdown {"destination":"pages/index.html","source":"pages/index.md","title":"Prototype","type":"markdown"}
pages/80-characters.md markdown {"destination":"pages/80-characters.html","source":"pages/80-characters.md","type":"markdown"}
pages/database.md markdown {"destination":"pages/database.html","source":"pages/database.md","title":"Database","type":"markdown"}
Command: sqlite3 prototype.db "SELECT * FROM prototype_metadata LIMIT 100"