blogroll_tags

Table actions

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

8 rows where blogroll_id = 85

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ blogroll_id tag
783 Stephen J. Guyenet 85 obesity
784 Stephen J. Guyenet 85 neuroscience
785 Stephen J. Guyenet 85 nutrition
786 Stephen J. Guyenet 85 public health
787 Stephen J. Guyenet 85 Red Pen Reviews
788 Stephen J. Guyenet 85 The Hungry Brain
789 Stephen J. Guyenet 85 GiveWell
790 Stephen J. Guyenet 85 eating behavior

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