home / github / issue_comments

Menu
  • Search all tables
  • GraphQL API

issue_comments: 749771231

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/1099#issuecomment-749771231 https://api.github.com/repos/simonw/datasette/issues/1099 749771231 MDEyOklzc3VlQ29tbWVudDc0OTc3MTIzMQ== 9599 2020-12-22T20:54:25Z 2020-12-22T20:54:25Z OWNER

https://latest.datasette.io/_internal/foreign_keys (use https://latest.datasette.io/login-as-root first) is now a compound foreign key table: sql CREATE TABLE foreign_keys ( "database_name" TEXT, "table_name" TEXT, "id" INTEGER, "seq" INTEGER, "table" TEXT, "from" TEXT, "to" TEXT, "on_update" TEXT, "on_delete" TEXT, "match" TEXT, PRIMARY KEY (database_name, table_name, id, seq), FOREIGN KEY (database_name) REFERENCES databases(database_name), FOREIGN KEY (database_name, table_name) REFERENCES tables(database_name, table_name) ); Currently the database_name column becomes a link (because it's a single foreign key) but the table_name one remains a non-link:

My original idea for compound foreign keys was to turn both of those columns into links, but that doesn't fit here because database_name is already part of a different foreign key.

{
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
743371103  
Powered by Datasette · Queries took 0.827ms · About: github-to-sqlite