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. |