blogroll_tags

Table actions

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

9 rows where blogroll_id = 72

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
657 Warm Days Will Never Cease 72 book reviews
658 Warm Days Will Never Cease 72 English literature
659 Warm Days Will Never Cease 72 librarian
660 Warm Days Will Never Cease 72 reading
661 Warm Days Will Never Cease 72 literary commentary
662 Warm Days Will Never Cease 72 PhD
663 Warm Days Will Never Cease 72 UK
664 Warm Days Will Never Cease 72 bibliophilia
665 Warm Days Will Never Cease 72 classic literature

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