schema madness

event status table
added constraints to fields
auto populate date fields