Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“Unique identifier for each invitation row.”,“why”:“Enables referencing and joining invitation data.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.115527864+00:00”} |
|||||
| sent_to | varchar | 255 | null |
|
|
{“what”:“Email address the invitation was sent to.”,“why”:“Identifies the invitee and is used for delivery and lookup.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.142770137+00:00”} |
|||||
| organization_id | uuid | 2147483647 | null |
|
|
{“what”:“Organization the invitee is asked to join.”,“why”:“Determines which organization’s membership is being granted.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.154100040+00:00”} |
|||||
| expire_at | timestamp | 29,6 | null |
|
|
{“what”:“UTC timestamp after which the invitation is no longer valid.”,“why”:“Prevents indefinite pending invitations and enforces time limits.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.170132902+00:00”} |
|||||
| created_by | uuid | 2147483647 | null |
|
|
{“what”:“User ID of the person who created the invitation.”,“why”:“Provides audit trail and accountability for invitations.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.244568900+00:00”} |
|||||
| created_at | timestamp | 29,6 | null |
|
|
{“what”:“UTC timestamp when the invitation was created.”,“why”:“Enables sorting and tracking invitation age.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.361709455+00:00”} |
|||||
| cancel_at | timestamp | 29,6 | √ | null |
|
|
{“what”:“UTC timestamp when the invitation was cancelled, if ever.”,“why”:“Distinguishes cancelled invitations from pending or answered ones.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.479010368+00:00”} |
||||
| answered_by | uuid | 2147483647 | √ | null |
|
|
{“what”:“User ID of the invitee who responded, if any.”,“why”:“Links the response to the invitee’s account for verification.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.634696014+00:00”} |
||||
| refused_at | timestamp | 29,6 | √ | null |
|
|
{“what”:“UTC timestamp when the invitee declined the invitation.”,“why”:“Records rejection to prevent re-invitation and track decisions.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.679503761+00:00”} |
||||
| accepted_at | timestamp | 29,6 | √ | null |
|
|
{“what”:“UTC timestamp when the invitee accepted the invitation.”,“why”:“Marks successful onboarding and triggers membership creation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.707372545+00:00”} |
||||
| role | varchar | 255 | √ | null |
|
|
{“what”:“Role assigned to the invitee upon acceptance, e.g., ‘admin’.”,“why”:“Defines initial permissions; null if not specified or pending.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.719451529+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| organization_invitations_pkey | Primary key | Asc | id |
| organization_invitations_organization_id_index | Performance | Asc | organization_id |