Fix model's column types & lengths

Registered by Tim Black on 2010-08-12

Set each column to the correct type & length - mostly just verify that they are the correct column types.
See http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html

Blueprint information

Status:
Complete
Approver:
None
Priority:
Undefined
Drafter:
None
Direction:
Approved
Assignee:
Diana Graham
Definition:
Approved
Series goal:
None
Implementation:
Implemented
Milestone target:
milestone icon 0.1
Started by
Diana Graham on 2010-08-26
Completed by
Diana Graham on 2010-08-26

Related branches

Sprints

Whiteboard

So far all we've done is assign this to Diana and Mona.

         - Diana will do the Congregations table
         - Mona will do the People table

TODO:
Integer & Boolean columns should not have a length of 255! Both need no length, so should be written like this:

Boolean
Integer

DONE:
The nullable=False argument means that this column must contain data or you can't write anything to the other columns in this record in the database; i.e., nullable=False makes this column a required column ( = a required field in a form). Tim edited each column's nullable setting accordingly.

(?)

Work Items

This blueprint contains Public information 
Everyone can see this information.