Employee:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    sf_guard_user_id:
      type: integer
    name:
      type: string(155)
    start_date:
      type: date
    position_id:
      type: integer
  relations:
    User:
      class: sfGuardUser
      foreignType: one
      foreignAlias: Employee
    Specialties:
      class: EmployeeSpecialty
      refClass: EmployeeSpecialtyRef
      local: employee_id
      foreign: employee_specialty_id
      foreignAlias: Employees

Department:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    title:
      type: string(155)
    manager_id:
      type: integer

Payout:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true

Rank:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    title:
      type: string(155)
    description:
      type: blob

Specialty:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    title:
      type: string(155)

Position:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    title:
      type: string(155)

Badge:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    title:
      type: string(155)

Review:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true

Payout:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    achievement_id:
      type: integer
    status:
      type: enum
      values: [Paid, Unpaid]
    date:
      type: date

EmployeeSpecialtyRef:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    employee_id:
      type: integer
    employee_specialty_id:
      type: integer
  relations:
    Employee:
      class: Employee
      foreignType: many
      foreignAlias: SpecialtyRef
    EmployeeSpecialty:
      class: EmployeeSpecialty
      foreignType: many
      foreignAlias: EmployeeRef

EmployeeSpecialty:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    specialty_id:
      type: integer
    level:
      type: integer
    notes:
      type: blob
  relations:
    Specialty:
      class: Specialty
      foreignType: one
      foreignAlias: EmployeeSpecialty

EmployeeBadge:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    employee_id:
      type: integer
    badge_id:
      type: integer

EmployeeRank:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    employee_id:
      type: integer
    rank_id:
      type: integer