Auth0 schema and ERD

40 tables

Loading diagram…

action

action_trigger

client

client_grant

connection

event_stream

grants

log_stream

logs

organization

organization_member

resource_server

role

users

action

string

name

string

code

string

runtime

string

status

string

installed_integration_id

string

all_changes_deployed

boolean

built_at

date

created_at

date

action_supported_trigger

string

action_id

string

version

string

status

string

default_runtime

string

_weld_synced

date

action_secret

action_id

string

name

string

updated_at

date

_weld_synced

date

action_dependency

action_id

string

name

string

version

string

registry_url

string

_weld_synced

date

action_integration

string

action_id

string

catalog_id

string

url_slug

string

partner_id

string

name

string

description

string

short_description

string

logo

string

feature_type

string

action_trigger

string

version

string

status

string

default_runtime

string

_weld_synced

date

action_trigger_runtime

action_trigger_id

string

action_trigger_version

string

runtime

string

_weld_synced

date

action_trigger_compatible

string

action_trigger_id

string

index

long

action_trigger_version

string

version

string

_weld_synced

date

client

client_id

string

name

string

description

string

app_type

string

tenant

string

logo_uri

string

callback_url_template

string

initiate_login_uri

string

token_endpoint_auth_method

string

client_callback

client_id

string

callback

string

_weld_synced

date

client_grant_type

client_id

string

index

long

grant_type

string

_weld_synced

date

client_metadata

client_id

string

name

string

value

string

_weld_synced

date

client_grant

string

client_id

string

audience

string

organization_usage

string

subject_type

string

default_for

string

allow_any_organization

boolean

is_system

boolean

allow_all_scopes

boolean

_weld_synced

date

client_grant_scope

client_grant_id

string

client_id

string

index

long

scope

string

_weld_synced

date

connection

string

name

string

display_name

string

strategy

string

is_domain_connection

boolean

show_as_button

boolean

authentication_active

boolean

connected_accounts_active

boolean

_weld_synced

date

connection_realm

connection_id

string

index

long

realm

string

_weld_synced

date

connection_enabled_client

connection_id

string

client_id

string

_weld_synced

date

connection_metadata

connection_id

string

name

string

value

string

_weld_synced

date

event_stream

string

name

string

status

string

created_at

date

updated_at

date

destination_type

string

destination_configuration_webhook_endpoint

string

destination_configuration_webhook_authorization_method

string

destination_configuration_webhook_authorization_username

string

event_stream_subscription

event_stream_id

string

event_type

string

_weld_synced

date

grants

string

client_id

string

user_id

string

audience

string

_weld_synced

date

grant_scope

index

long

grant_id

string

scope

string

_weld_synced

date

log_stream

string

name

string

type

string

status

string

is_priority

boolean

_weld_synced

date

log_stream_sink

log_stream_id

string

name

string

value

string

_weld_synced

date

logs

connection_id

string

client_id

string

organization_id

string

log_id

string

date

type

string

description

string

connection

string

client_name

string

hostname

string

log_detail_accessed_secret

index

long

log_id

string

accessed_secret

string

_weld_synced

date

organization

string

name

string

display_name

string

branding_logo_url

string

branding_colors_primary

string

branding_colors_page_background

string

_weld_synced

date

organization_metadata

organization_id

string

name

string

value

string

_weld_synced

date

organization_member

organization_id

string

user_id

string

name

string

picture

string

_weld_synced

date

organization_member_role

string

organization_id

string

member_id

string

name

string

_weld_synced

date

resource_server

string

client_id

string

name

string

identifier

string

signing_alg

string

token_dialect

string

consent_policy

string

is_system

boolean

allow_offline_access

boolean

skip_consent_for_verifiable_first_party_clients

boolean

enforce_policies

boolean

token_lifetime

long

token_lifetime_for_web

long

_weld_synced

date

resource_server_scopes

resource_server_id

string

value

string

description

string

_weld_synced

date

role

string

name

string

description

string

_weld_synced

date

role_permission

role_id

string

resource_server_identifier

string

permission_name

string

resource_server_name

string

description

string

_weld_synced

date

stats_daily

date

logins

long

signups

long

leaked_passwords

long

created_at

date

updated_at

date

_weld_synced

date

users

user_id

string

email_verified

boolean

username

string

phone_number

string

phone_verified

boolean

created_at

date

updated_at

date

user_identities

user_id

string

index

long

user_identity_id

string

connection

string

provider

string

is_social

boolean

expires_in

long

_weld_synced

date

user_profile_data

user_id

string

user_identities_index

long

name

string

value

string

_weld_synced

date

user_app_metadata

user_id

string

name

string

value

string

_weld_synced

date

user_metadata

user_id

string

name

string

value

string

_weld_synced

date