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
    Specialties:
      class: EmployeeSpecialty
      refClass: EmployeeSpecialtyRef
      local: employee_id
      foreign: employee_specialty_id
      foreignAlias: Employees

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

EmployeeSpecialtyRef:
  columns:
    employee_id:
      type: integer
      primary: true
    employee_specialty_id:
      type: integer
      primary: true
  relations:
    Employee:
      class: Employee
      onDelete: CASCADE
    EmployeeSpecialty:
      class: EmployeeSpecialty
      onDelete: CASCADE

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