Auth0

Explore the interactive ERD

Table & Field Reference

role

Column	Type	Keys
`id`	Unknown	PK
`description`	Unknown
`name`	Unknown

resource_server_scopes

Column	Type	Keys
`_fivetran_id`	String	PK
`resource_server_id`	Unknown	FK
`description`	Unknown
`value`	Unknown

resource_server

Column	Type	Keys
`id`	Unknown	PK
`allow_offline_access`	Unknown
`client`	Json
`enforce_policies`	Unknown
`identifier`	Unknown
`is_system`	Unknown
`name`	Unknown
`signing_alg`	Unknown
`signing_secret`	Unknown
`skip_consent_for_verifiable_first_party_clients`	Unknown
`token_dialect`	Unknown
`token_lifetime`	Unknown
`token_lifetime_for_web`	Unknown

stats_daily

Column	Type	Keys
`date`	Unknown	PK
`created_at`	Unknown
`leaked_passwords`	Unknown
`leaked_passwords_reset`	Unknown
`leaked_passwords_signup`	Unknown
`logins`	Unknown
`signups`	Unknown
`updated_at`	Unknown

action_trigger_runtime

Column	Type	Keys
`runtime`	Unknown	PK
`action_trigger_id`	Unknown	PKFK
`action_trigger_version`	Unknown	PKFK

action_trigger_compatible

Column	Type	Keys
`index`	Unknown	PK
`action_trigger_id`	Unknown	PKFK
`action_trigger_version`	Unknown	PKFK
`id`	Unknown
`version`	Unknown

action_trigger

Column	Type	Keys
`id`	Unknown	PK
`version`	Unknown	PK
`default_runtime`	Unknown
`status`	Unknown

action_supported_trigger

Column	Type	Keys
`action_id`	Unknown	PKFK
`id`	Unknown	PKFK
`version`	Unknown	PKFK

action_secret

Column	Type	Keys
`_fivetran_id`	String	PK
`action_id`	Unknown	FK
`name`	Unknown
`updated_at`	Unknown

action_dependency

Column	Type	Keys
`_fivetran_id`	String	PK
`action_id`	Unknown	FK
`name`	Unknown
`registry_url`	Unknown
`version`	Unknown

action_integration

Column	Type	Keys
`id`	Unknown	PK
`action_id`	Unknown	PKFK
`catalog_id`	Unknown
`created_at`	Unknown
`description`	Unknown
`feature_type`	Unknown
`logo`	Unknown
`name`	Unknown
`partner_id`	Unknown
`privacy_policy_url`	Unknown
`public_support_link`	Unknown
`secrets`	Unknown
`short_description`	Unknown
`terms_of_use_url`	Unknown
`updated_at`	Unknown
`url_slug`	Unknown

action

Column	Type	Keys
`id`	Unknown	PK
`all_changes_deployed`	Unknown
`built_at`	Unknown
`code`	Unknown
`created_at`	Unknown
`current_version_build_time`	Unknown
`current_version_code`	Unknown
`current_version_created_at`	Unknown
`current_version_id`	Unknown
`current_version_number`	Unknown
`current_version_runtime`	Unknown
`current_version_status`	Unknown
`current_version_updated_at`	Unknown
`deployed_version_built_at`	Unknown
`deployed_version_code`	Unknown
`deployed_version_created_at`	Unknown
`deployed_version_deployed`	Unknown
`deployed_version_id`	Unknown
`deployed_version_number`	Unknown
`deployed_version_runtime`	Unknown
`deployed_version_secrets`	Unknown
`deployed_version_status`	Unknown
`deployed_version_supported_triggers`	Unknown
`deployed_version_updated_at`	Unknown
`installed_integration_id`	Unknown
`name`	Unknown
`runtime`	Unknown
`status`	Unknown
`updated_at`	Unknown

client_grant_type

Column	Type	Keys
`index`	Unknown	PK
`client_id`	Unknown	PKFK
`grant_type`	Unknown

client_callback

Column	Type	Keys
`_fivetran_id`	String	PK
`client_id`	Unknown	FK
`callback`	Unknown

client_metadata

Column	Type	Keys
`name`	Unknown	PK
`client_id`	Unknown	PKFK
`value`	Unknown

client

Column	Type	Keys
`id`	Unknown	PK
`allowed_origins`	Unknown
`backchannel_logout_urls`	Unknown
`callback_url_template`	Unknown
`cross_origin_auth`	Unknown
`cross_origin_authentication`	Unknown
`cross_origin_loc`	Unknown
`custom_login_page_on`	Unknown
`encryption_key_cert`	Unknown
`encryption_key_pub`	Unknown
`encryption_key_subject`	Unknown
`global`	Unknown
`is_first_party`	Unknown
`is_token_endpoint_ip_header_trusted`	Unknown
`jwt_configuration_alg`	Unknown
`jwt_configuration_lifetime_in_seconds`	Unknown
`jwt_configuration_secret_encoded`	Unknown
`name`	Unknown
`oidc_conformant`	Unknown
`refresh_token_expiration_type`	Unknown
`refresh_token_idle_token_lifetime`	Unknown
`refresh_token_infinite_idle_token_lifetime`	Unknown
`refresh_token_infinite_token_lifetime`	Unknown
`refresh_token_leeway`	Unknown
`refresh_token_rotation_type`	Unknown
`refresh_token_token_lifetime`	Unknown
`sso`	Unknown
`sso_disabled`	Unknown
`tenant`	Unknown

connection_realm

Column	Type	Keys
`index`	Unknown	PK
`connection_id`	Unknown	PKFK
`realms`	Unknown

connection_enabled_client

Column	Type	Keys
`client_id`	Unknown	PKFK
`connection_id`	Unknown	PKFK

connection_metadata

Column	Type	Keys
`name`	Unknown	PK
`connection_id`	Unknown	PKFK
`value`	Unknown

connection

Column	Type	Keys
`id`	Unknown	PK
`is_domain_connection`	Unknown
`name`	Unknown
`strategy`	Unknown

log_detail_accessed_secret

Column	Type	Keys
`index`	Unknown	PK
`log_id`	Unknown	PKFK
`accessedsecret`	Unknown

logs

Column	Type	Keys
`log_id`	Unknown	PK
`client_id`	Unknown	FK
`connection_id`	Unknown	FK
`user_id`	Unknown	FK
`audience`	Unknown
`city_name`	Unknown
`client_name`	Unknown
`continent_code`	Unknown
`country_code`	Unknown
`country_code_3`	Unknown
`country_name`	Unknown
`date`	Instant
`description`	Unknown
`hostname`	Unknown
`ip`	Unknown
`is_mobile`	Unknown
`latitude`	Unknown
`longitude`	Unknown
`page`	Unknown
`request_auth_credential`	Json
`request_auth_strategy`	Unknown
`request_auth_user`	Json
`request_channel`	Unknown
`request_ip`	Unknown
`request_method`	Unknown
`request_path`	Unknown
`request_user_agent`	Unknown
`response_client_id`	Unknown
`response_status_code`	Unknown
`scope`	Unknown
`strategy`	Unknown
`strategy_type`	Unknown
`time_zone`	Unknown
`type`	Unknown
`user_agent`	Unknown

log_stream_sink

Column	Type	Keys
`name`	Unknown	PK
`log_stream_id`	Unknown	PKFK
`value`	Unknown

log_stream

Column	Type	Keys
`id`	Unknown	PK
`name`	Unknown
`status`	Unknown
`type`	Unknown

grant_scope

Column	Type	Keys
`index`	Unknown	PK
`grant_id`	Unknown	PKFK
`scope`	Unknown

grants

Column	Type	Keys
`id`	Unknown	PK
`client_id`	Unknown	FK
`user_id`	Unknown	FK
`audience`	Unknown

organization_member_role

Column	Type	Keys
`id`	Unknown	PKFK
`member_id`	Unknown	PKFK
`organization_id`	Unknown	PKFK

event_stream

Column	Type	Keys
`id`	Unknown	PK
`created_at`	Unknown
`destination_configuration`	Json
`destination_type`	Unknown
`name`	Unknown
`status`	Unknown
`subscription`	Json
`updated_at`	Unknown

organization_member

Column	Type	Keys
`id`	Unknown	PKFK
`organization_id`	Unknown	PKFK

client_grant_scope

Column	Type	Keys
`index`	Unknown	PK
`client_grant_id`	Unknown	PKFK
`client_id`	Unknown	PKFK
`scope`	Unknown

client_grant

Column	Type	Keys
`id`	Unknown	PK
`client_id`	Unknown	PKFK
`audience`	Unknown

organization_metadata

Column	Type	Keys
`name`	Unknown	PK
`organization_id`	Unknown	PKFK
`value`	Unknown

organization

Column	Type	Keys
`id`	Unknown	PK
`branding_colors_page_background`	Unknown
`branding_colors_primary`	Unknown
`branding_logo_url`	Unknown
`display_name`	Unknown
`name`	Unknown

role_permission

Column	Type	Keys
`_fivetran_id`	String	PK
`role_id`	Unknown	FK
`description`	Unknown
`permission_name`	Unknown
`resource_server_identifier`	Unknown
`resource_server_name`	Unknown

user_profile_data

Column	Type	Keys
`name`	Unknown	PK
`user_identities_index`	Unknown	PKFK
`users_id`	Unknown	PKFK
`value`	Unknown

user_identities

Column	Type	Keys
`index`	Unknown	PK
`users_id`	Unknown	PKFK
`access_token`	Unknown
`connection`	Unknown
`expires_in`	Unknown
`is_social`	Unknown
`provider`	Unknown
`user_identity_id`	Unknown

user_app_metadata

Column	Type	Keys
`name`	Unknown	PK
`users_id`	Unknown	PKFK
`value`	Unknown

user_metadata

Column	Type	Keys
`name`	Unknown	PK
`users_id`	Unknown	PKFK
`value`	Unknown

users

Column	Type	Keys
`id`	Unknown	PK
`blocked`	Unknown
`created_at`	Unknown
`deleted`	Unknown
`deleted_at`	Unknown
`email`	Unknown
`email_verified`	Unknown
`family_name`	Unknown
`first_name`	Unknown
`given_name`	Unknown
`identity_api`	Unknown
`idp_tenant_domain`	Unknown
`is_private_email`	Unknown
`last_ip`	Unknown
`last_login`	Unknown
`last_name`	Unknown
`last_password_reset`	Unknown
`logins_count`	Unknown
`name`	Unknown
`nickname`	Unknown
`nonce_supported`	Unknown
`o_id`	Unknown
`phone_number`	Unknown
`phone_verified`	Unknown
`picture`	Unknown
`principal_name`	Unknown
`real_user_status`	Unknown
`tenant_id`	Unknown
`updated_at`	Unknown
`username`	Unknown