kikaku/wireframes — pull request #2 by tomreay (2014-02-23 18:28:35+00:00)
Title: Create a datamodel

Written using PostgreSQL datatypes, some questions I've thought about to start the discussion off:

* Using Numeric datatype for the standard and result tables value column, will these always be numbers?
* Are there any extra fields we need for the seconds, some of them look a little simple but paper trail gives us almost all the meta data I think we need
* Is text enough for the full_text fields as they will likely contain some markup
* Is there a better way of handing ordering of the criteria? Int means all rows have to be updated to change the ordering, but is simple to understand and use. We could use decimals, which means one update to change order at the expense of complexity and readability. I don't think a project would ever have enough criteria for it to be a performance problem