Auth0 Tables

Tables

Auth0Actions

Name	Type	Description
AllChangesDeployed	boolean	True if all of an Action's contents have been deployed.
BuiltAt	timestamp	The time when this action was built successfully.
Code	string	The source code of the action.
CreatedAt	timestamp	The time when this action was created.
Dependencies	string	List of third party npm modules, and their versions, hat this action depends on.
DeployedVersion	string	Version of the action that is currently deployed.
ActionID	string	A unique ID for the action.
Name	string	The name of the action.
Runtime	string	The Node runtime. For example `node16`, defaults to `node12`.
Secrets	string	List of secrets that are included in an action or a version of an action.
Status	string	The build status of this action.
SupportedTriggers	string	List of triggers that this action supports. At this time, an action can only target a single trigger at a time.
UpdatedAt	timestamp	The time when this action was updated.
ConfigID	int	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

Auth0Clients

Name	Type	Description
ClientID	string	ID of this client.
Tenant	string	Name of the tenant this client belongs to.
Name	string	Name of this client (min length: 1 character, does not allow `<` or `>`).
Description	string	Free string description of this client (max length: 140 characters).
Global	string	Whether this is your global 'All Applications' client representing legacy tenant settings (true) or a regular client (false).
AppType	string	Type of client used to determine which settings are applicable. Can be spa, native, non_interactive, or regular_web.
IsFirstParty	boolean	Whether this client a first party client (true) or not (false).
OIDCConformant	boolean	Whether this client conforms to strict OIDC specifications (true) or uses legacy features (false).
CallBacks	string	Comma-separated list of URLs whitelisted for Auth0 to use as a callback to the client after authentication.
AllowedOrigins	string	Comma-separated list of URLs allowed to make requests from JavaScript to Auth0 API (typically used with CORS). By default, all your callback URLs will be allowed. This field allows you to enter other origins if necessary. You can also use wildcards at the subdomain level (e.g., `https://*.contoso.com`). Query strings and hash information are not taken into account when validating these URLs.
WebOrigins	string	Comma-separated list of allowed origins for use with Cross-Origin Authentication, Device Flow, and web message response mode.
ClientAliases	string	List of audiences/realms for SAML protocol. Used by the WS-Fed addon.
AllowedClients	string	List of allow clients and API ids that are allowed to make delegation requests. Empty means all all your clients are allowed.
AllowedLogoutUrls	string	Comma-separated list of URLs that are valid to redirect to after logout from Auth0. Wildcards are allowed for subdomains.
GrantTypes	string	List of grant types supported for this application. Can include `authorization_code`, `implicit`, `refresh_token`, `client_credentials`, `password`, `http://auth0.com/oauth/grant-type/password-realm`, `http://auth0.com/oauth/grant-type/mfa-oob`, `http://auth0.com/oauth/grant-type/mfa-otp`, `http://auth0.com/oauth/grant-type/mfa-recovery-code`, and `urn:ietf:params:oauth:grant-type:device_code`.
SSO	boolean	Applies only to SSO clients and determines whether Auth0 will handle Single Sign On (true) or whether the Identity Provider will (false).
SSODisabled	boolean	Whether Single Sign On is disabled (true) or enabled (true). Defaults to true.
CrossOriginAuthentication	boolean	Whether this client can be used to make cross-origin authentication requests (true) or it is not allowed to make such requests (false).
CrossOriginLOC	string	URL of the location in your site where the cross origin verification takes place for the cross-origin auth flow when performing Auth in your own domain instead of Auth0 hosted login page. Format:`url`
CustomLoginPageOn	boolean	Whether a custom login page is to be used (true) or the default provided login page (false).
CustomLoginPage	string	The content (HTML, CSS, JS) of the custom login page.
CustomLoginPagePreview	string	The content (HTML, CSS, JS) of the custom login page. (Used on Previews)
TokenEndpointAuthMethod	string	Defines the requested authentication method for the token endpoint. Can be none (public client without a client secret), client_secret_post (client uses HTTP POST parameters), or client_secret_basic (client uses HTTP Basic). Possible values: `none`, `client_secret_post`, `client_secret_basic`
InitiateLoginURI	string	Initiate login uri, must be https Format: `absolute-https-uri-or-empty`
OrganizationUsage	string	Defines how to proceed during an authentication transaction with regards an organization. Can be deny (default), allow or require. Possible values: `deny`, `allow`, `require`
OrganizationRequireBehavior	string	Defines how to proceed during an authentication transaction when `client.organization_usage: require'. Possible values: `n_prompt`, `pre_login_prompt`, `post_login_prompt`
RequirePushedAuthorizationRequests	boolean	Makes the use of Pushed Authorization Requests mandatory for this client
RequireProofOfPossession	string	Makes the use of Proof-of-Possession mandatory for this client
ComplianceLevel	string	Defines the compliance level for this client, which may restrict its capabilities Possible values: `none`, `fapi1_adv_pkj_par`, `fapi1_adv_mtls_par, null`
ConfigID	int	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

Auth0Connections

Name	Type	Description
DisplayName	string	Connection name used in login screen.
Name	string	The name of the connection
ConnectionID	string	The connection's identifier.
Strategy	string	The type of the connection, related to the identity provider.
Realms	string	Defines the realms for which the connection will be used (ie: email domains). If the array is empty or the property is not specified, the connection name will be added as realm.
IsDomainConnection	boolean	True if the connection is domain level.
ConfigID	int	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

Auth0DeviceCredentials

Name	Type	Description
DeviceCredentialsId	string	ID of this device.
DeviceName	string	User agent for this device.
DeviceId	string	Unique identifier for the device. NOTE: This field is generally not populated for refresh_tokens and rotating_refresh_tokens.
Type	string	Type of credential. Possible values: `public_key`, `refresh_token`, `rotating_refresh_token`
UserId	string	`user_id` this credential is associated with.
ClientId	string	`client_id` of the client (application) this credential is for.
ConfigID	int	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

Auth0Hooks

Name	Type	Description
HookId	string	ID of this hook.
Name	string	Name of this hook.
Script	string	Code to be executed when this hook runs.
TriggerId	string	Trigger ID
ConfigID	int	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

Auth0Log

Name	Type	Description
LogId	string	Unique ID of the event.
Date	datetime	Date when the event occurred in ISO 8601 format.
Type	string	Type of event.
Connection	string	Name of the connection the event relates to.
ConnectionId	string	ID of the connection the event relates to.
ClientId	string	ID of the client (application).
ClientName	string	Name of the client (application).
Ip	string	IP address of the log event source.
UserAgent	string	User agent string from the client device that caused the event.
ElapsedTime	int	Elapsed time.
SessionId	string	Identifier for the session.
LoginsCount	int	Number of logins.
Hostname	string	Hostname the event applies to.
UserId	string	ID of the user involved in the event.
UserName	string	Name of the user involved in the event.
Strategy	string	Name of the strategy involved in the event.
StrategyType	string	Type of strategy involved in the event.
IsMobile	boolean	Whether the client was a mobile device (true) or desktop/laptop/server (false).
CountryCode	string	Two-letter Alpha-2 ISO 3166-1 country code.
CountryCode3	string	Three-letter Alpha-3 ISO 3166-1 country code.
CountryName	string	Full country name in English.
CityName	string	Full city name in English.
Latitude	float	Global latitude (horizontal) position.
Longitude	float	Global longitude (vertical) position.
TimeZone	string	Time zone name as found in the tz database.
ContinentCode	string	Continent the country is located within. Can be AF (Africa), AN (Antarctica), AS (Asia), EU (Europe), NA (North America), OC (Oceania) or SA (South America).
ConfigID	int	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.
CompletedAt	datetime	The time when the log entry was completed at.
InitiatedAt	datetime	The time when the log entry was initiated at.

Auth0Organizations

Name	Type	Description
OrgID	string	Organization identifier.
Name	string	The name of this organization.
DisplayName	string	Friendly name of this organization.
ConfigID	int	The ID of the configuration within Compyl.
BatchDate	datetime	The sync date.

Auth0Permission

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
PermissionId	int	Identifier for the permission.
PermissionName	string	Name of this permission.
Description	string	Description of this permission.
ResourceServerIdentifier	string	Resource server (API) identifier that this permission is for.
ResourceServerName	string	Resource server (API) name this permission is for.
BatchDate	datetime	The sync date.

Auth0Role

Name	Type	Description
RoleId	string	ID for this role.
Name	varchar	Name of this role.
Description	varchar	Description of this role.
BatchDate	datetime	The sync date.
ConfigId	int	The ID of the configuration within Compyl.

Auth0Rules

Name	Type	Description
ConfigID	int	The ID of the configuration within Compyl.
Name	string	Name of this rule.
Enabled	boolean	Whether the rule is enabled (true), or disabled (false).
Order	int	Order that this rule should execute in relative to other rules. Lower-valued rules execute first.
Script	string	Code to be executed when this rule runs.
Stage	string	Execution stage of this rule. Can be login_success, login_failure, or pre_authorize.
BatchDate	datetime	The sync date.
RuleID	string	The ID of the rule.

Auth0Users

Name	Type	Description
UserID	string	ID of the user which can be used when interacting with other APIs.
Email	varchar	Email address of this user.
UpdatedAt	datetime	Date and time when this user was last updated/modified (ISO_8601 format).
Connect	varchar	Name of the connection containing this identity.
Provider	varchar	The type of identity provider
IsSocial	boolean	Whether this identity is from a social provider (true) or not (false).
Name	varchar	Name of this user.
NickName	varchar	Preferred nickname or alias of this user.
CreatedAt	datetime	Date and time when this user was created (ISO_8601 format).
LastLogin	datetime	Last date and time this user logged in (ISO_8601 format).
LastIp	varchar	Last IP address from which this user logged in.
LoginsCount	int	Total number of logins this user has performed.
BatchDate	datetime	The sync date.
ConfigId	int	The ID of the configuration within Compyl.
IsMFAEnabled	boolean	Whether this user has multi-factor authentication enabled on their account.
MFAProviders	string	List of multi-factor authentication providers with which this user has enrolled.

Bridge Tables

Auth0Permissions_Auth0Roles

Name	Type	Description
PermissionId	int	Identifier for the permission granted by the role.
RoleId	string	Identifier for the role.
ConfigID	int	The ID of the configuration within Compyl.

Auth0Roles_Auth0Users

Name	Type	Description
RoleId	string	Identifier for the role.
UserId	string	Identifier for the user.
ConfigID	int	The ID of the configuration within Compyl.

Permissions

Name	Permissions
Auth0DeviceCredentials	read:device_credentials
Auth0Organizations	read:organizations read:organizations_summary
Auth0Hooks	read:hooks
Auth0Clients	read:clients, read:client_keys, read:client_credentials, read:client_summary
Auth0Connections	read:connections
Auth0Actions	read:actions
Auth0Users	read:users, read:user_idp_tokens
Auth0Logs	read:logs, read:logs_users
Auth0Rules	read:rules
Auth0Roles	read:roles
Auth0Permissions	read:roles

Tables

Auth0Actions

Auth0Clients

Auth0Connections

Auth0DeviceCredentials

Auth0Hooks

Auth0Log

Auth0Organizations

Auth0Permission

Auth0Role

Auth0Rules

Auth0Users

Bridge Tables

Auth0Permissions_Auth0Roles

Auth0Roles_Auth0Users

Permissions

Learn more...