Skip to content

app.personal_access_token_scopes

TableRow level security on

A capability group a personal API token may use (Section 4.5.6 personal settings item 15), one row per group. Fixed when the token is created.

Primary key: id

Columns of app.personal_access_token_scopes
ColumnTypeNullableDescription
iduuidNoPrimary key, UUID v7.
org_iduuidNoOwning org, derived from app.personal_access_tokens on insert; never accepted from the caller and never changed.References app.organizations.id
personal_access_token_iduuidNoToken the scope belongs to.References app.personal_access_tokens.id
scopetextNoCapability group: the first segment of capability codes in the registry, for example work.
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.