home / system

Menu
  • GraphQL API
  • Search all tables

blogroll_tags

Table actions
  • GraphQL API for blogroll_tags

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

5 rows where blogroll_id = 12

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
56 Maria Popova 12 literature
57 Maria Popova 12 philosophy
58 Maria Popova 12 art
59 Maria Popova 12 science
60 Maria Popova 12 history

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE blogroll_tags (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    blogroll_id INTEGER NOT NULL,
    tag TEXT NOT NULL,
    FOREIGN KEY (blogroll_id) REFERENCES blogroll(id) ON DELETE CASCADE,
    UNIQUE(blogroll_id, tag)
);
Powered by Datasette · 6.32ms · krisyotam.com