Operator:
  connection: main
  tableName: operator
  columns:
    id:
      type: integer(4)
      unsigned: true
      primary: true
      autoincrement: true
    type:
      type: integer(4)
    name:
      type: string(255)
    username:
      type: string(50)
    password:
      type: string(40)
    available:
      type: boolean
    tasksperpage:
      type: integer(4)
    generalquota:
      type: integer(4)
      unsigned: true
      notnull: false
  relations:
    ClaimedTasks:
      type: many
      class: Task
      local: id
      foreign: claimedbyid
      onDelete: cascade
    CompletedTasks:
      type: many
      class: Task
      local: id
      foreign: completedbyid
      onDelete: cascade
    SkillSets:
      class: SkillSet
      local: operatorid
      foreign: skillsetid
      refClass: OperatorSkillSet
      onDelete: cascade
    Clients:
      class: Client
      local: operatorid
      foreign: clientid
      refClass: OperatorClient
      onDelete: cascade
Task:
  connection: main
  tableName: task
  columns:
    id:
      type: integer(4)
      unsigned: true
      primary: true
      autoincrement: true
    fileref:
      type: string(50)
    claimedbyid:
      type: integer(4)
      unsigned: true
    completedbyid:
      type: integer(4)
      unsigned: true
    clientid:
      type: integer(4)
      unsigned: true
    workgroup:
      type: string(50)
    actioncode:
      type: string(50)
    createddate:
      type: date(25)
    duedate:
      type: date(25)
    tpiname:
      type: string(50)
    incidentdate:
      type: date(25)
    polcompleted:
      type: boolean
    debtor:
      type: string(50)
    state:
      type: string(50)
    amountowing:
      type: float
    createdby:
      type: string(50)
  relations:
    ClaimedBy:
      class: Operator
      local: claimedbyid
      foreign: id
      onDelete: cascade
    CompletedBy:
      class: Operator
      local: completedbyid
      foreign: id
      onDelete: cascade
    Action:
      class: Action
      local: actioncode
      foreign: code
      onDelete: cascade
    Client:
      class: Client
      local: clientid
      foreign: id
      onDelete: cascade
OperatorSkillSet:
  connection: main
  tableName: operatorskillset
  columns:
    operatorid:
      type: integer(4)
      unsigned: true
      primary: true
    skillsetid:
      type: integer(4)
      unsigned: true
      primary: true
    quota:
      type: integer(4)
      unsigned: true
      notnull: false
  relations:
    Operator:
      class: Operator
      local: operatorid
      foreign: id
      foreignAlias: OperatorSkillSets
      onDelete: cascade
    SkillSet:
      class: SkillSet
      local: skillsetid
      foreign: id
      foreignAlias: OperatorSkillSets
      onDelete: cascade
SkillSet:
  connection: main
  tableName: skillset
  columns:
    id:
      type: integer(4)
      unsigned: true
      primary: true
      autoincrement: true
    name:
      type: string(255)
    priority:
      type: float()
    prioritymod:
      type: float()
  relations:
    Actions:
      type: many
      class: Action
      local: id
      foreign: skillsetid
      onDelete: SET NULL
    Operators:
      class: Operator
      local: skillsetid
      foreign: operatorid
      refClass: OperatorSkillSet
      onDelete: cascade
Action:
  connection: main
  tableName: action
  columns:
    code:
      type: string(50)
      primary: true
    skillsetid:
      type: integer(4)
      unsigned: true
    defaultnotation:
      type: string(50)
  relations:
    SkillSet:
      class: SkillSet
      local: skillsetid
      foreign: id
    Tasks:
      type: many
      class: Task
      local: code
      foreign: actioncode
OperatorClient:
  connection: main
  tableName: operatorclient
  columns:
    operatorid:
      type: integer(4)
      unsigned: true
      primary: true
    clientid:
      type: integer(4)
      unsigned: true
      primary: true
  relations:
    Operator:
      class: Operator
      local: operatorid
      foreign: id
      foreignAlias: OperatorClients
      onDelete: cascade
    Client:
      class: Client
      local: clientid
      foreign: id
      foreignAlias: OperatorClients
      onDelete: cascade
Client:
  connection: main
  tableName: client
  columns:
    id:
      type: integer(4)
      unsigned: true
      primary: true
      autoincrement: true
    name:
      type: string(255)
  relations:
    Operators:
      class: Operator
      local: clientid
      foreign: operatorid
      refClass: OperatorClient
      onDelete: cascade
    Tasks:
      type: many
      class: Task
      local: id
      foreign: clientid
      onDelete: cascade
    OperatorClients:
      type: many
      class: OperatorClient
      local: id
      foreign: clientid
      onDelete: cascade