Auditor:
  columns:
    id:
      type: integer
      autoincrement: true
      primary: true
    username:
      type: string(255)
    password:
      type: string(255)
    fullname:
      type: string(255)
    is_auditor:
      type: integer
    is_manager:
      type: integer
    is_director:
      type: integer

Task:
  columns:
    id:
      type: integer
      autoincrement: true
      primary: true
    client:
      type: string(255)
    start_date:
      type: date
    end_date:
      type: date
    assigned_by:
      type: string(255)
    comments:
      type: string
    status:
      type: integer
  relations:
    Auditors:
      foreignAlias: Tasks
      class: Auditor
      refClass: AuditorTask

AuditorTask:
  columns:
    auditor_id:
      type: integer
      primary: true
    task_id:
      type: integer
      primary: true
  relations:
    Auditor:
      foreignAlias: AuditorTasks
    Task:
      foreignAlias: AuditorTasks

Expense:
  columns:
    id:
      type: integer
      autoincrement: true
      primary: true
    auditor_task_id:
      type: integer
    date:
      type: date
    hours_spent:
      type: integer
    transport_cost:
      type: float
    remarks:
      type: string
  relations:
    AuditorTask:
      foreignAlias: Expenses

Error i'm getting:
SQLSTATE[42000]: Syntax error or access violation: 1072 Key column 'id' doesn't exist in table. Failing Query: "CREATE TABLE auditor_task (auditor_id BIGINT,task_id BIGINT, INDEX id_idx (id), PRIMARY KEY(auditor_id, task_id))ENGINE = INNODB". Failing Query: CREATE TABLE auditor_task (auditor_id BIGINT, task_id BIGINT, INDEX id_idx (id), PRIMARY KEY(auditor_id, task_id)) ENGINE = INNODB