Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int4 | 10 | √ | null |
|
|
{“what”:“Unique numeric identifier for each grant log entry.”,“why”:“Needed to reference a specific grant record; without it, rows cannot be uniquely identified.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.427380092+00:00”} |
||||
| user_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the user who received support access.”,“why”:“Without it, the grant cannot be attributed to a user, making access history ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.441726223+00:00”} |
||||
| ticket_number | varchar | 100 | √ | null |
|
|
{“what”:“Support ticket number associated with this grant.”,“why”:“Links the grant to a support request; without it, the reason for access is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.456631395+00:00”} |
||||
| notes | varchar | 255 | √ | null |
|
|
{“what”:“Free-text notes about the grant.”,“why”:“Captures context or justification; without it, the purpose of the grant may be unclear.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.538507817+00:00”} |
||||
| grant_start_timestamp | timestamptz | 35,6 | null |
|
|
{“what”:“Date and time when the access grant becomes effective.”,“why”:“Defines the beginning of the access window; without it, the grant period is undefined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.560928226+00:00”} |
|||||
| grant_end_timestamp | timestamptz | 35,6 | null |
|
|
{“what”:“Date and time when the access grant expires.”,“why”:“Defines the end of the access window; without it, the grant would be open-ended.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.577573754+00:00”} |
|||||
| revoked_at | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Date and time when the grant was revoked, if any.”,“why”:“Indicates early termination; without it, we cannot know if the grant was revoked before expiry.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.595952369+00:00”} |
||||
| revoked_by_user_id | int4 | 10 | √ | null |
|
|
{“what”:“Identifier of the user who revoked the grant.”,“why”:“Records who performed the revocation; without it, accountability for revocation is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.638264118+00:00”} |
||||
| created_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when this log entry was created.”,“why”:“Provides audit trail of when the record was inserted; without it, the log’s chronological order is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.658183145+00:00”} |
|||||
| updated_at | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp of the last update to this log entry.”,“why”:“Tracks modifications; without it, we cannot know if the record was changed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.684825468+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| support_access_grant_log_pkey | Primary key | Asc | id |
| idx_support_access_grant_log_active | Performance | Asc/Asc | grant_end_timestamp + revoked_at |
| idx_support_access_grant_log_revoked_by_user_id | Performance | Asc | revoked_by_user_id |
| idx_support_access_grant_log_user_id | Performance | Asc | user_id |