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 = 3

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
11 Maggie Appleton 3 design
12 Maggie Appleton 3 anthropology
13 Maggie Appleton 3 illustrations
14 Maggie Appleton 3 programming
15 Maggie Appleton 3 digital garden

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 · 13.118ms · krisyotam.com