blogroll_tags

Table actions

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

10 rows where blogroll_id = 16

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
88 Piero Scaruffi 16 AI
89 Piero Scaruffi 16 cognitive science
90 Piero Scaruffi 16 music history
91 Piero Scaruffi 16 poetry
92 Piero Scaruffi 16 visual arts
93 Piero Scaruffi 16 internet culture
94 Piero Scaruffi 16 philosophy
95 Piero Scaruffi 16 Silicon Valley
96 Piero Scaruffi 16 knowledge systems
97 Piero Scaruffi 16 interdisciplinary

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