support_access_grant_log


Description

{“what”:“Log of support access grants with start/end times and revocation details.”,“why”:“Audits who had support access and when, for security and compliance.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:12:58.398701106+00:00”}

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
core_user.id fk_support_access_grant_log_user_id N

{“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
core_user.id fk_support_access_grant_log_revoked_by_user_id N

{“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

Relationships