search

geoffcorvera / aphis-inspection-reports-dashboard

0 stars 0 forks source link

Add foreign key constraint to citations table #7

Closed geoffcorvera closed 4 months ago

geoffcorvera commented 5 months ago

I want to click on "hash_id" in citations and be taken to the linked inspection record.

Check https://docs.datasette.io/en/stable/ecosystem.html#sqlite-utils

geoffcorvera commented 4 months ago

Adding fk with sqlite_utils worked. When you load a table, the values in citations.hash_id link to the inspection record - but not when you view a result table (via SQL query or basic operation)