cloud.external_integration_tokens
Schema: cloud
English table: cloud.external_integration_tokens
Italian original table: cloud.integration_tokens
Description: Storage for API tokens and access keys used by external client applications.
Overview
- Columns: 8
- Primary key: eit_token_id
- Outgoing foreign keys: 0
- Incoming foreign keys: 0
- Indexes: 1
Columns
| English column | Italian original column | Type | Null | Default / Generated | Description |
|---|---|---|---|---|---|
eit_token_id | id | uuid | NO | Unique UUID for the integration token record. | |
eit_client_application_name | client_app | text | NO | Name or identifier of the external system (e.g., "MobileApp", "PayrollSync"). | |
eit_tenant_uuid | tenant_id | uuid | YES | UUID of the tenant authorized by this token. | |
eit_associated_email | email | text | YES | Email of the user or service account that generated the token. | |
eit_token_value | token | text | NO | The actual secure token string. | |
eit_created_at | created_at | timestamp without time zone | NO | Timestamp when the token was issued. | |
eit_expires_at | expires_at | timestamp without time zone | YES | Timestamp when the token becomes invalid. | |
eit_is_revoked | is_revoked | boolean | NO | false | Boolean flag to manually invalidate the token before its expiration. |
Relationships
Outgoing foreign keys
No outgoing foreign keys found.
Referenced by
No incoming foreign keys found.
Constraints
- Primary key:
pk_external_integration_tokens→eit_token_id
Indexes
| Name | Unique | Method | Columns / expression |
|---|---|---|---|
idx_eit_token_value | NO | btree | eit_token_value |
Navigation
- Back to main index
- [Back to
cloudindex]../)