series_tags
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_1QAPZ2B9SJSG"
This data as json, CSV (advanced)
| Link | series_id | tag_id |
|---|---|---|
| CNT_1QAPZ2B9SJSG,TAG_1X0XMNRA3Q20 | Yuri Magnetixx CNT_1QAPZ2B9SJSG | School TAG_1X0XMNRA3Q20 |
| CNT_1QAPZ2B9SJSG,TAG_2NMNSTHHHGTG | Yuri Magnetixx CNT_1QAPZ2B9SJSG | Yuri TAG_2NMNSTHHHGTG |
| CNT_1QAPZ2B9SJSG,TAG_3X845AY38F6G | Yuri Magnetixx CNT_1QAPZ2B9SJSG | School Life TAG_3X845AY38F6G |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE series_tags (
series_id TEXT NOT NULL,
tag_id TEXT NOT NULL,
PRIMARY KEY (series_id, tag_id),
FOREIGN KEY (series_id) REFERENCES series(id),
FOREIGN KEY (tag_id) REFERENCES tags(id)
);
CREATE INDEX idx_series_tags_tag ON series_tags(tag_id);