TeamMembership
All team memberships in the workspace.
Table-Specific Information
SELECT
Retrieve Linear TeamMembership records:SELECT * FROM TeamMembership LIMIT 1
INSERT
To insert a TeamMembership record:INSERT INTO TeamMembership (teamId, userId, owner, sortOrder) VALUES ('921cb6bf-d5b6-44bb-9c6b-217b97dd27a2', 'cfa5f5f6-bcd8-4a1e-9844-5186f9af10e3', false, 1)
UPDATE
To update a TeamMembership record:UPDATE TeamMembership SET owner = true WHERE id = 'feb9ca65-ee57-4edd-818a-76b43a0e60f4'
DELETE
To delete a TeamMembership record:DELETE FROM TeamMembership WHERE id = 'feb9ca65-ee57-4edd-818a-76b43a0e60f4'
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. |
| userId | String | False |
The user that the membership is associated with. |
| teamId | String | False |
The team that the membership is associated with. |
| owner | Bool | False |
Whether the user is an owner of the team. Team owners have elevated permissions for managing team settings, members, and resources. |
| sortOrder | Double | False |
The sort order of this team in the user's personal team list. Lower values appear first. |