blogroll_tags

Table actions

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

5 rows where blogroll_id = 89

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
821 Weland's Work 89 medieval literature
822 Weland's Work 89 Beowulf
823 Weland's Work 89 Northern Europe
824 Weland's Work 89 criticism
825 Weland's Work 89 blog

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