DealCategories
Create, update, delete, and query Deal Categories.
Table Specific Information
Insert
To insert a new Deal Category, at least a Category Name and a Color must be provided.
INSERT INTO DealCategories (Name, Color) VALUES ('A unique deal category', '5df4b5')
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Integer | True |
The unique identifier for the category. | |
| Name | String | False |
The name of the category. | |
| Color | String | False |
The color as a hex value. | |
| AccountId | Integer | True |
A reference to the account. | |
| ElementsCount | Integer | True |
The number of elements in the category. | |
| CreatedAt | Datetime | True |
The date and time when this record was created. | |
| UpdatedAt | Datetime | True |
The date and time when this record was last updated. |