home / notedb

Schema for notedb

CREATE TABLE "notes" (
    id TEXT PRIMARY KEY,
    user TEXT NOT NULL,
    folder TEXT NOT NULL DEFAULT '',
    content TEXT NOT NULL,
    tag TEXT NOT NULL DEFAULT '[]',
    enable TEXT NOT NULL DEFAULT 'T',
    created_at TEXT NOT NULL,
    updated_at TEXT NOT NULL
);
CREATE INDEX idx_notes_user ON notes(user);
CREATE INDEX idx_notes_enable ON notes(enable);
CREATE INDEX idx_notes_updated ON notes(updated_at)
Powered by Datasette