blogroll_tags

Table actions

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

9 rows where blogroll_id = 65

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
580 The Lyre and the Lexicon 65 Classics
581 The Lyre and the Lexicon 65 Greek
582 The Lyre and the Lexicon 65 Latin
583 The Lyre and the Lexicon 65 translations
584 The Lyre and the Lexicon 65 ancient literature
585 The Lyre and the Lexicon 65 philology
586 The Lyre and the Lexicon 65 commentary
587 The Lyre and the Lexicon 65 language
588 The Lyre and the Lexicon 65 personal 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)
);