blogroll_tags

Table actions

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

8 rows where blogroll_id = 61

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
533 Reading the Middle Ages 61 medieval literature
534 Reading the Middle Ages 61 Middle Ages
535 Reading the Middle Ages 61 King Arthur
536 Reading the Middle Ages 61 art
537 Reading the Middle Ages 61 culture
538 Reading the Middle Ages 61 literary history
539 Reading the Middle Ages 61 myth
540 Reading the Middle Ages 61 historical influence

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