blogroll_tags

Table actions

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

9 rows where blogroll_id = 15

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
79 Bret Victor 15 dynamic media
80 Bret Victor 15 interface design
81 Bret Victor 15 spatial computing
82 Bret Victor 15 tools for thought
83 Bret Victor 15 education
84 Bret Victor 15 visualization
85 Bret Victor 15 programming
86 Bret Victor 15 climate
87 Bret Victor 15 design theory

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)
);