Labels are lightweight tags, similar to the labels/tags implemented within the workboard interface on github, gitlab and trello.
Labels can have a color, an icon and a short text string
The label is associated with a project and a task id. This way different workboards can use different labels and the labels can have a meaning that is specific to that workboard.
The schema would look like this:
Schema
project_label
| Key | Type |
|---|---|
| id | int(64) |
| label | varchar(32) |
| phid | PHID |
| projectPHID | PHID |
| icon | int(8) |
| color | int(8) |
project_tasklabel
| Key | Type |
|---|---|
| labelPHID | project_label.phid |
| projectPHID | project.phid |
| taskPHID | task.phid |
| value | varchar(64) |