# Auth0 schema ERD

Table and field reference for the Fivetran Auth0 connector.

## 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 | PK, FK |
| action_trigger_version | Unknown | PK, FK |

### action_trigger_compatible

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| action_trigger_id | Unknown | PK, FK |
| action_trigger_version | Unknown | PK, FK |
| 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 | PK, FK |
| id | Unknown | PK, FK |
| version | Unknown | PK, FK |

### 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| realms | Unknown |  |

### connection_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| connection_id | Unknown | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| 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 | PK, FK |
| member_id | Unknown | PK, FK |
| organization_id | Unknown | PK, FK |

### 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 | PK, FK |
| organization_id | Unknown | PK, FK |

### connection_enabled_client

| Column | Type | Keys |
| --- | --- | --- |
| client_id | Unknown | PK, FK |
| connection_id | Unknown | PK, FK |

### client_grant_scope

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| client_grant_id | Unknown | PK, FK |
| client_id | Unknown | PK, FK |
| scope | Unknown |  |

### client_grant

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK |
| client_id | Unknown | PK, FK |
| audience | Unknown |  |

### organization_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| organization_id | Unknown | PK, FK |
| 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 | PK, FK |
| users_id | Unknown | PK, FK |
| value | Unknown |  |

### user_identities

| Column | Type | Keys |
| --- | --- | --- |
| index | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 | PK, FK |
| value | Unknown |  |

### user_metadata

| Column | Type | Keys |
| --- | --- | --- |
| name | Unknown | PK |
| users_id | Unknown | PK, FK |
| 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 |  |

### user_role

| Column | Type | Keys |
| --- | --- | --- |
| id | Unknown | PK, FK |
| users_id | Unknown | PK, FK |
| owner_id | Unknown | FK |
| type | Unknown |  |

## Relationships

- resource_server_scopes(resource_server_id) → resource_server(id)
- action_trigger_runtime(action_trigger_id) → action_trigger(id)
- action_trigger_runtime(action_trigger_version) → action_trigger(version)
- action_trigger_compatible(action_trigger_id) → action_trigger(id)
- action_trigger_compatible(action_trigger_version) → action_trigger(version)
- action_supported_trigger(id) → action_trigger(id)
- action_supported_trigger(version) → action_trigger(version)
- action_supported_trigger(action_id) → action(id)
- action_secret(action_id) → action(id)
- action_dependency(action_id) → action(id)
- action_integration(action_id) → action(id)
- client_grant_type(client_id) → client(id)
- client_callback(client_id) → client(id)
- client_metadata(client_id) → client(id)
- connection_realm(connection_id) → connection(id)
- connection_metadata(connection_id) → connection(id)
- log_detail_accessed_secret(log_id) → logs(log_id)
- logs(user_id) → users(id)
- logs(connection_id) → connection(id)
- logs(client_id) → client(id)
- log_stream_sink(log_stream_id) → log_stream(id)
- grant_scope(grant_id) → grants(id)
- grants(user_id) → users(id)
- grants(client_id) → client(id)
- organization_member_role(id) → role(id)
- organization_member_role(member_id) → organization_member(id)
- organization_member_role(organization_id) → organization_member(organization_id)
- organization_member(id) → users(id)
- organization_member(organization_id) → organization(id)
- connection_enabled_client(client_id) → client(id)
- connection_enabled_client(connection_id) → connection(id)
- client_grant_scope(client_grant_id) → client_grant(id)
- client_grant_scope(client_id) → client_grant(client_id)
- client_grant(client_id) → client(id)
- organization_metadata(organization_id) → organization(id)
- role_permission(role_id) → role(id)
- user_profile_data(user_identities_index) → user_identities(index)
- user_profile_data(users_id) → user_identities(users_id)
- user_identities(users_id) → users(id)
- user_app_metadata(users_id) → users(id)
- user_metadata(users_id) → users(id)
- user_role(id) → role(id)
- user_role(owner_id) → organization(id)
- user_role(users_id) → users(id)