path: root/database/schema.sqlite

PRAGMA foreign_keys = ON;
CREATE TABLE journals(
    id INTEGER PRIMARY KEY NOT NULL, --optional 
    date INTEGER NOT NULL,
    fulltext TEXT,
    image_url TEXT
);