blogroll_tags

Table actions

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

8 rows where blogroll_id = 74

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
677 Rohan Maitzen 74 Victorian literature
678 Rohan Maitzen 74 academic blogging
679 Rohan Maitzen 74 literary criticism
680 Rohan Maitzen 74 public humanities
681 Rohan Maitzen 74 women writers
682 Rohan Maitzen 74 pedagogy
683 Rohan Maitzen 74 English literature
684 Rohan Maitzen 74 Canadian academia

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