Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| table_id | int4 | 10 | null |
|
|
{“what”:“Integer ID of the table that the privileges apply to.”,“why”:“Identifies which table the privilege row governs; without it the grant is meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.788914046+00:00”} |
|||||
| role | varchar | 255 | √ | null |
|
|
{“what”:“Role name that the privileges are granted to; null if the grant is not role-specific.”,“why”:“Determines which role gets the privileges; without it, the grant cannot be applied to the intended user or group.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.848792334+00:00”} |
||||
| select | bool | 1 | false |
|
|
{“what”:“Boolean flag: true if the role can SELECT rows from the table.”,“why”:“Controls read access; without it, read permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.870763913+00:00”} |
|||||
| update | bool | 1 | false |
|
|
{“what”:“Boolean flag: true if the role can UPDATE rows in the table.”,“why”:“Controls write access; without it, update permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:16.910110776+00:00”} |
|||||
| insert | bool | 1 | false |
|
|
{“what”:“Boolean flag: true if the role can INSERT rows into the table.”,“why”:“Controls insert access; without it, insert permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:17.088193110+00:00”} |
|||||
| delete | bool | 1 | false |
|
|
{“what”:“Boolean flag: true if the role can DELETE rows from the table.”,“why”:“Controls delete access; without it, delete permissions are undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:13:17.151979954+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| idx_table_privileges_role | Performance | Asc | role |
| idx_table_privileges_table_id | Performance | Asc | table_id |