propel:
  student:
        _attributes: { phpName: Student }
        id:
        first_name: varchar(100)
        last_name: varchar(100)
        email: varchar(255)
        address: varchar(255)
        city: varchar(100)
        state: varchar(30)
        postal_code: varchar(30)
        country: varchar(50)
        phone_number: varchar(30)
        account_type: varchar(255)
        created_at: timestamp
        updated_at: timestamp
        updated_by: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
        notes: longvarchar

    student_response:
        _attributes: { phpName: StudentResponse }
        id:
        question_id: { type: integer, foreignTable: student_question, foreignReference: id, required: true, onDelete: cascade }
        created_at: timestamp
        response: longvarchar

    student_question:
        _attributes: { phpName: StudentQuestion }
        id:
        school_id: { type: integer, foreignTable: school, foreignReference: id, required: true, onDelete: cascade }
        created_at: timestamp
        question: longvarchar

    school:
        _attributes: { phpName: School }
        id:
        name: varchar(100)
        email: varchar(255)
        address: varchar(255)
        city: varchar(100)
        state: varchar(30)
        postal_code: varchar(30)
        country: varchar(50)
        phone_number: varchar(30)
        sha1_password: varchar(40)
        salt: varchar(32)
        base_url: varchar(255)
        created_at: timestamp
        created_by: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
        updated_at: timestamp

    user:
        _attributes: { phpName: User }
        id:
        nickname: varchar(100)
        first_name: varchar(100)
        last_name:  varchar(100)
        email:      varchar(100)
        sha1_password:   varchar(40)
        salt:       varchar(32)
        account_type: varchar(50)
        created_by: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
        updated_by: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
        school_id: { type: integer, foreignTable: school, foreignReference: id, required: true, onDelete: cascade }

    course:
        _attributes: { phpName: Course }
        id:
        name: varchar(100)
        type: varchar(100)
        date: varchar(255)
        created_at: timestamp
        updated_at: timestamp
        created_by: { type: integer, foreignTable: user, foreignReference: id, required: true, onDelete: cascade }
        updated_by: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
        course_detail_id: { type: integer, foreignTable: course_detail, foreignReference: id, required: true, onDelete: cascade }

    course_detail:
        _attributes: { phpName: CourseDetail }
        id:
        description: longvarchar
        created_at: timestamp
        created_by: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
        school_id: { type: integer, foreignTable: school, foreignReference: id, required: true, onDelete: cascade }

    accomodations:
        _attributes: { phpName: Accomodations }
        id:
        name: varchar(100)
        price: float
        school_id: { type: integer, foreignTable: school, foreignReference: id, required: true, onDelete: cascade }
        updated_by: { type: integer, foreignTable: user, foreignReference: id, onDelete: cascade }
        description: longvarchar