cloud.user_oauth_logins

Schema: cloud
English table: cloud.user_oauth_logins
Italian original table: cloud._oauth_logins
Description: Stores active OAuth sessions and external provider mapping for users.

Overview

• Columns: 7
• Primary key: uol_login_id
• Outgoing foreign keys: 0
• Incoming foreign keys: 0
• Indexes: 0

Columns

English column	Italian original column	Type	Null	Default / Generated	Description
uol_login_id	oauth_id	integer	NO		Primary key: auto-incrementing ID for the OAuth login record.
uol_user_id	oauth_user_id	uuid	NO		Reference to the internal system user (cloud.users).
uol_provider_id	oauth_provider_id	uuid	NO		Reference to the specific OAuth provider (cloud.oauth_providers).
uol_external_provider_user_id	oauth_provider_userid	uuid	NO		The unique ID returned by the external provider (e.g., Google Sub ID).
uol_access_token	oauth_token	character varying	NO		The authentication token provided by the OAuth service.
uol_created_at	oauth_created_at	timestamp without time zone	YES	CURRENT_TIMESTAMP	Timestamp of when the OAuth link was first created.
uol_updated_at	oauth_updated_at	timestamp without time zone	YES	CURRENT_TIMESTAMP	Timestamp of the last login or token refresh.

Relationships

Outgoing foreign keys

No outgoing foreign keys found.

Referenced by

No incoming foreign keys found.

Constraints

• Primary key: pk_user_oauth_logins → uol_login_id

Indexes

No indexes detected.

Navigation

• Back to main index
• [Back to cloud index]../)