tried to add defaults so the data would load, but we need to write triggers for it, also I did the constraints but we'll need to test it with data once we can load it in