til

Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam

119 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date (date), created_at (date)

Next page

CREATE TABLE til (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    title TEXT NOT NULL,
    preview TEXT,
    date TEXT,
    category TEXT,
    slug TEXT UNIQUE NOT NULL,
    cover_image TEXT,
    status TEXT DEFAULT 'published',
    confidence TEXT,
    importance TEXT,
    state TEXT,
    created_at TEXT DEFAULT CURRENT_TIMESTAMP
);
CREATE INDEX idx_til_category ON til(category);
CREATE INDEX idx_til_status ON til(status);
CREATE INDEX idx_til_slug ON til(slug);