panoptes
panoptes copied to clipboard
Missing foreign key relations
We're missing a FK between projects and workflows, so:
SELECT * FROM workflows
LEFT OUTER JOIN projects on workflows.project_id = projects.id
WHERE projects.id IS NULL;
returns 22 rows.
There's only 7 FK relations in the schema, so we're probably missing others too?