Draft: Introduce foreign keys + improve DB documentation (!66) · Merge requests · tanna.dev / Dependency Management Data · GitLab

Jamie Tanna requested to merge feature/foreign-keys into main Jul 15, 2023

Need to:

Enable PRAGMA foreign_keys=on via https://pkg.go.dev/modernc.org/sqlite#Driver.Open - ?_pragma=foreign_keys(1)
#17 (closed)
Fix schemas in line with https://dba.stackexchange.com/a/195722

Closes #106.

Edited Jul 16, 2023 by Jamie Tanna