blogroll_tags

Table actions

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

9 rows where blogroll_id = 67

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
601 Sinolit 67 Chinese literature
602 Sinolit 67 Sinology
603 Sinolit 67 Fengshen Yanyi
604 Sinolit 67 Nezha
605 Sinolit 67 obscure books
606 Sinolit 67 literary adventure
607 Sinolit 67 classical Chinese
608 Sinolit 67 PhD research
609 Sinolit 67 bibliophilia

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