TaskCategories
Create, update, delete, and query Task Categories.
Table Specific Information
Insert
To insert a new Task Category, provide at least a Category Name and a Color.
INSERT INTO TaskCategories (Name, Color) VALUES('A unique task category', '5df4b5')
Columns
Name | Type | ReadOnly | References | Description |
Id [KEY] | Integer | True |
The unique identifier of the task category. | |
Name | String | False |
The name of the task category. | |
Color | String | False |
The color as a hex value. | |
AccountId | Integer | True |
The Id of the account associated with the task category. | |
ElementsCount | Integer | True |
The number of task categories. | |
CreatedAt | Datetime | True |
The date and time when the task category was created. | |
UpdatedAt | Datetime | True |
The date and time when the task category was last updated. |