issue_comments: 552252074
This data as json
| html_url | issue_url | id | node_id | user | created_at | updated_at | author_association | body | reactions | issue | performed_via_github_app |
|---|---|---|---|---|---|---|---|---|---|---|---|
| https://github.com/simonw/datasette/issues/620#issuecomment-552252074 | https://api.github.com/repos/simonw/datasette/issues/620 | 552252074 | MDEyOklzc3VlQ29tbWVudDU1MjI1MjA3NA== | 9599 | 2019-11-11T00:28:28Z | 2019-11-11T00:30:53Z | OWNER | So for foreign key definitions it could look like this: `/db/table?_fk.article_id=articles.id` Or for columns and table names that themselves contain dots it could be: `/db/table?_fk.article_id={"table":"articles","column":"id"}` The value (before the =) is unambiguous -it's `?fk.XXX` where XXX could be a column name that includes periods without breaking anything. Added bonus: if you're referencing another table's single primary key you can omit the `.id` entirely (since it can be automatically detected) - so you could do `?_fk.article_id=articles`. | {"total_count": 0, "+1": 0, "-1": 0, "laugh": 0, "hooray": 0, "confused": 0, "heart": 0, "rocket": 0, "eyes": 0} | 520667773 |