propel:
  language:
    _attributes:    { phpName: Language }
    code:           { type: varchar, size: 6, primaryKey: true }
    created_at:     { type: timestamp }
    updated_at:     { type: timestamp }
    language:       { type: varchar, size: 80, required: true }

  user:
    _attributes:    { phpName: User }
    id:             { type: integer, primaryKey: true, autoIncrement: true }
    created_at:     { type: timestamp }
    updated_at:     { type: timestamp }
    firstname:      { type: varchar, size: 80, index: true, required: true }
    lastname:       { type: varchar, size: 80, required: true }
    login:          { type: varchar, size: 40, required: true, index: unique }
    pass:           { type: varchar, size: 40, required: true }

  student:
    _attributes:    { phpName: Student }
    id:             { type: integer, primaryKey: true, autoIncrement: true }
    created_at:     { type: timestamp }
    updated_at:     { type: timestamp }
    firstname:      { type: varchar, size: 80, index: true, required: true }
    lastname:       { type: varchar, size: 80, required: true }
    city:           { type: varchar, size: 120 }
    birthday:       { type: date }
    photo:          { type: varchar, size: 32 }

  student_board:
    _attributes:    { phpName: StudentBoard }
    id:             { type: integer, primaryKey: true, autoIncrement: true }
    created_at:     { type: timestamp }
    updated_at:     { type: timestamp }
    student_id:     { type: integer, foreignTable: student, foreignReference: id, onDelete: cascade }
    language_code:  { type: varchar, size: 6, foreignTable: language, foreignReference: code, onDelete: cascade }
    subject:        { type: varchar, size: 80, required: true }
    comments:       { type: longvarchar, required: true }

  blackboard:
    _attributes:    { phpName: Blackboard }
    id:             { type: integer, primaryKey: true, autoIncrement: true }
    created_at:     { type: timestamp }
    updated_at:     { type: timestamp }
    language_code:  { type: varchar, size: 6, foreignTable: language, foreignReference: code, onDelete: cascade }
    user_id:        { type: integer, foreignTable: user, foreignReference: id }
    subject:        { type: varchar, size: 80, required: true }
    comments:       { type: longvarchar, required: true }
    published:      { type: boolean, default: false, index: true }

  page:
    _attributes:    { phpName: Page }
    id:             { type: integer, primaryKey: true, autoIncrement: true }
    created_at:     { type: timestamp }
    updated_at:     { type: timestamp }
    language_code:  { type: varchar, size: 6, index: unique, foreignTable: language, foreignReference: code, onDelete: cascade }
    section:        { type: varchar, size: 120, index: unique }