Created sqlite schema

- Includes constraint checks to ensure individual status of different type are
  valid and contain the info required.