CustomerTier
All customer tiers defined in the workspace.
Table-Specific Information
SELECT
Retrieve Linear CustomerTier records:SELECT * FROM CustomerTier LIMIT 1
INSERT
To insert a CustomerTier record:INSERT INTO CustomerTier (color, name, description) VALUES ('#5e6ad2', 'sample', 'sample')
UPDATE
To update a CustomerTier record:UPDATE CustomerTier SET name = 'sample' WHERE id = 'fe3c27e1-ca82-4e04-ad1b-68a12be85536'
DELETE
To delete a CustomerTier record:DELETE FROM CustomerTier WHERE id = 'fe3c27e1-ca82-4e04-ad1b-68a12be85536'
Columns
| Name | Type | ReadOnly | Description |
| id [KEY] | String | False |
The unique identifier of the entity. |
| createdAt | Datetime | True |
The time at which the entity was created. |
| updatedAt | Datetime | True |
The last time at which the entity was meaningfully updated. This is the same as the creation time if the entity hasn't been updated after creation. |
| archivedAt | Datetime | True |
The time at which the entity was archived. Null if the entity has not been archived. |
| name | String | False |
The internal name of the tier. Must be unique within the workspace. Used as the default display name if no displayName is explicitly set. |
| color | String | False |
The color of the tier indicator in the UI, as a HEX string (e.g., '#ff0000'). |
| description | String | False |
An optional description explaining what this tier represents and its intended use for customer segmentation. |
| position | Double | False |
The sort position of the tier in the workspace's customer tier ordering. Lower values appear first. Collisions are automatically resolved by redistributing positions. |
| displayName | String | False |
The user-facing display name of the tier shown in the UI. Defaults to the internal name if not explicitly set. |