blogroll_tags
Data license: All Rights Reserved · Data source: krisyotam.com · About: Kris Yotam
5 rows where blogroll_id = 3
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
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)
);