symfony kanban wiki

Symfony Kanban Database/Model Structure:

each task is broken down into phases (e.g. backlog, in progress, testing, archived)

Model Name: Phase:
  tableName: phase
  columns:
    id:
    name:
    description:
    slug:

the smallest unit of work

One to Many mapping with Phase ( many tasks in one phase ) Many to Many mapping with Department (many departments work on many tasks) Model Name: Task: tableName: task columns: id: name: description: slug: task_color: estimated_mins_to_complete: actual_mins_to_complete: phase_id: department_id:

who is responsible for the task (e.g. design, programming, project management)

Many to Many Mapping with Task (many departments work on many tasks)
Department:
  tableName: department
  columns:
    id:
    name:
    description:
    short_name:
    task_color:

many to many model mapping

TaskDepartment: tableName: task_department columns: task_id: department_id: