Add foreign key and constraints to data tables

[makingglitches]

To speed performance there need to be FK's added at the very least.
There should also be a built in guard against code mistakes inserting duplicate data.