home   screens   tables

This page is generated by bin/prototype.hs table-html items.
items

The items table contains lines of a (single) todolist. Each item has a status (TODO, or DONE), and a textual description.

CREATE TABLE items (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  status ENUM NOT NULL CHECK(status IN ('TODO','DONE')),
  description TEXT NOT NULL CHECK(length(description) > 0)
);
  Defined: sql/prototype.sql:49

id  status  description                                                              
--  ------  -------------------------------------------------------------------------
1   TODO    Add the first characters of each table description to /tables/index.html.
2   TODO    Extract the values of each ENUMs to reuse them in table descriptions.    
  Command: sqlite3 prototype.db "SELECT * FROM items LIMIT 100"