external_guest_invites
Stores invitations sent to external users (non-tenant users) to access specific resources.
Purpose
Enable controlled sharing of data with external stakeholders.
Columns
| Column | Type | Description |
|---|---|---|
| id | uuid | Primary key |
| text | Invitee email | |
| token | text | Secure invite token |
| resource_type | text | What is shared |
| resource_id | uuid | Target resource |
| expires_at | timestamptz | Expiry |
| status | text | pending/accepted/expired |
Usage
- Used for external sharing (drawings, docs)
- Token-based access flow