UserCategory:
  actAs: { Timestampable: ~ }
  columns:
    user_types: { type: string(255), notnull: true, unique: true }

User:
  actAs: { Timestampable: ~ }
  columns:
    user_category_id:  { type: integer, notnull: true }
    first_name:        { type: string(255), notnull: true }
    last_name:         { type: string(255), notnull: true }
    email:             { type: string(255), notnull: true, unique: true }
    password:          { type: string(255), notnull: true }
    token:             { type: string(255), notnull: true, unique: true }
    date_of_birth:     { type: date, notnull: true }
    gender:
      type: enum
      values: [male, female]
    is_activated:      { type: boolean, notnull: true, default: 0 }
  relations:
    UserCategory: { onDelete: CASCADE, local: user_category_id, foreign: id, foreignAlias: Users }

UserQualification:
  actAs: { Timestampable: ~ }
  columns:
    user_id:                   { type: integer, notnull: true }
    country:                   { type: string(255) }
    type_of_institution:       { type: string(255) }
    university:                { type: string(255) }
    college:                   { type: string(255) }
    degree:                    { type: string(255) }
    subject_of_specialization: { type: string(255) }
    study_year_from_month:     { type: integer(2) }
    study_year_from_year:      { type: year }
    study_year_to_month:       { type: integer(2) }
    study_year_to_year:        { type: year }
  relations:
    User: { onDelete: CASCADE, local: user_id, foreign: id, foreignAlias: Qualifications }