propel:
  td_users:
    _attributes:        { phpName: User }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: false }
    authsys_login:      { type: varchar(25), required: true, index: unique }
    email:              { type: varchar(75), required: true, index: unique }
    firstname:          { type: varchar(25), required: false }
    lastname:           { type: varchar(50), required: false }
    role:               { type: bigint, required: true, default: 1 }
    active_email:       { type: boolean, required: true, default: false }
  td_tasks:
    _attributes:        { phpName: Task }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: false }
    user_id:            { type: integer, required: true, index: true, foreignTable: td_users, foreignReference: id, onDelete: setnull }
    is_deleted:         { type: boolean, required: true, default: false }
    type:               { type: smallint, required: true, default: 0, index: true }
    status:             { type: smallint, required: true, default: 1, index: true }
    priority:           { type: smallint, required: true, default: 1, index: true }
    description:        { type: longvarchar, required: true }
  td_tasks_notes:
    _attributes:        { phpName: TaskNote }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: false }
    task_id:            { type: integer, required: true, index: true, foreignTable: td_tasks, foreignReference: id, onDelete: setnull }
    user_id:            { type: integer, required: true, index: true, foreignTable: td_users, foreignReference: id, onDelete: setnull }
    note:               { type: longvarchar, required: true }