organization_invitations


Description

{“what”:“Invitations for users to join an organization with a role.”,“why”:“Tracks pending, cancelled, and answered invitations to control access.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:29.086503732+00:00”}

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
organizations.id organization_invitations_organization_id_fkey R

{“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
users.id organization_invitations_created_by_fkey R

{“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
users.id organization_invitations_answered_by_fkey R

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

Relationships