panoptes icon indicating copy to clipboard operation
panoptes copied to clipboard

Missing foreign key relations

Open marten opened this issue 9 years ago • 0 comments

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?

marten avatar Sep 16 '15 16:09 marten