propel:
  student:
        _attributes: { phpName: Student }
        id:
        first_name: varchar(100)
        last_name: varchar(100)
        email: varchar(255)
        address1: varchar(255)
        address2: varchar(255)
        city: varchar(100)
        state: varchar(30)
        postal_code: varchar(30)
        country: varchar(50)
        home_phone: varchar(30)
        mobile_phone: 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 }
        reservation_id: { type: integer, foreignTable: reservation, 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_detail:
        _attributes: { phpName: CourseDetail }
        id:
        name: varchar(100)
        type: varchar(100)
        description: longvarchar
        created_at: timestamp
        updated_at: timestamp

  course:
        _attributes: { phpName: Course }
        id:
        start_date: date
        end_date: date
        created_at: timestamp
        updated_at: timestamp
        school_id: { type: integer, foreignTable: school, foreignReference: id, required: true, onDelete: cascade }
        course_detail_id: { type: integer, foreignTable: course_detail, foreignReference: id, required: true, onDelete: cascade }


  accommodation:
        _attributes: { phpName: Accommodation }
        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

  reservation:
        _attributed: {phpName: Reservation}
        id:
        created_at: timestamp
        student_id: { type: integer, foreignTable: student, foreignReference: id, required: true, onDelete: cascade }
        course_id: { type: integer, foreignTable: course, foreignReference: id, required: true, onDelete: cascade }
        accommodation_id: { type: integer, foreignTable: accommodation, foreignReference: id, required: true, onDelete: cascade }