Working around Sqlite's not supporting enum

- I was going to have type tables for events and states
- I changed my mind and plan to implement with a constant data structure
  instead
- Added some related TODOs to Event and Notification