Skip to content

app.workspaces

TableRow level security on

A division of an org, for example a city office or a venue group, that scopes projects and members (Section 4.5.1).

Primary key: id

Columns of app.workspaces
ColumnTypeNullableDescription
iduuidNoWorkspace id.
org_iduuidNoOwning org.References app.organizations.id
slugtextNoLowercase hyphenated key, unique within the org.
nametextNoWorkspace display name.
created_attimestamp with time zoneNoWhen the row was inserted. Set by the database.
created_byuuidYesPerson who inserted the row, or null for a platform process. Set by the database.References app.people.id
updated_attimestamp with time zoneNoWhen the row last changed. Set by the database.
updated_byuuidYesPerson who last changed the row, or null for a platform process. Set by the database.References app.people.id
deleted_attimestamp with time zoneYesSoft delete time. A row with deleted_at set is ignored by every access helper.