blog_post_tags
6 rows where blog_post_hash = "7fce555577"
This data as json, CSV (advanced)
Link | blog_post_hash | tag_hash |
---|---|---|
7fce555577,0dcb092a8e | Accelerating Software Delivery on AWS 7fce555577 | Blog Post 0dcb092a8e |
7fce555577,6283e6d28d | Accelerating Software Delivery on AWS 7fce555577 | General Startup 6283e6d28d |
7fce555577,63d28acde9 | Accelerating Software Delivery on AWS 7fce555577 | developer-tools 63d28acde9 |
7fce555577,68edd72071 | Accelerating Software Delivery on AWS 7fce555577 | getting-started 68edd72071 |
7fce555577,8ef48176ec | Accelerating Software Delivery on AWS 7fce555577 | startup 8ef48176ec |
7fce555577,fac4afc605 | Accelerating Software Delivery on AWS 7fce555577 | advice-from-aws-solution-architects fac4afc605 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "blog_post_tags" ( [blog_post_hash] TEXT REFERENCES [blog_posts]([hash]), [tag_hash] TEXT REFERENCES [tags]([hash]), PRIMARY KEY ([blog_post_hash], [tag_hash]) ); CREATE INDEX [idx_blog_post_tags_tag_hash] ON [blog_post_tags] ([tag_hash]); CREATE INDEX [idx_blog_post_tags_blog_post_hash] ON [blog_post_tags] ([blog_post_hash]);