gistfile1.txt

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
    EmployeeSpecialtyRef:
      class: EmployeeSpecialtyRef
      foreignType: many
      foreignAlias: SpecialtyRef
Specialty:
  columns:
    id:
      type: integer
      primary: true
      autoincrement: true
    title:
      type: string(155)
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