propel:
  dw_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 }
  dw_teams:
    _attributes:        { phpName: Team }
    id:                 { type: integer, required: true, primaryKey: true, autoIncrement: true }
    created_at:         { type: timestamp, required: true }
    updated_at:         { type: timestamp, required: false }
    shortname:          { type: varchar(25), required: false }
    longname:           { type: varchar(255), required: false }
  dw_users2teams:
    _attributes:        { phpName: User2Team }
    user_id:            { type: integer, required: true, primaryKey: true, foreignTable: dw_users, foreignReference: id, onDelete: setnull }
    team_id:            { type: integer, required: true, primaryKey: true, foreignTable: dw_teams, foreignReference: id, onDelete: setnull }
  dw_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: dw_users, foreignReference: id, onDelete: setnull }
    is_deleted:         { type: boolean, required: true, default: false }
    status:             { type: smallint, required: true, default: 1, index: true }
    description:        { type: longvarchar, required: true }
  dw_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: dw_tasks, foreignReference: id, onDelete: setnull }
    user_id:            { type: integer, required: true, index: true, foreignTable: dw_users, foreignReference: id, onDelete: setnull }
    note:               { type: longvarchar, required: true }