blogroll_tags

Table actions

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

10 rows where blogroll_id = 55

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
469 Theron Martin 55 anime
470 Theron Martin 55 light novels
471 Theron Martin 55 reviews
472 Theron Martin 55 fantasy
473 Theron Martin 55 Doctor Who
474 Theron Martin 55 Dungeons and Dragons
475 Theron Martin 55 Terraforming Mars
476 Theron Martin 55 education
477 Theron Martin 55 board games
478 Theron Martin 55 USA Anime

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