Tables


SchemaSpy Analysis of fusionauth.public

Generated on Sat Jun 27 19:57 UTC 2026

XML Representation
Insertion Order Deletion Order
TABLES 91
VIEWS 0
COLUMNS 657
Constraints 200
Anomalies 16
Routines 0

Database Properties

Database Type: PostgreSQL - 15.8 (Debian 15.8-1.pgdg110+1)

Schema public

standard public schema

Tables

Table / View Children Parents Columns Type Comments
event_logs 0 0 4 Table
application_oauth_scopes 0 1 6 Table
entity_types 4 1 6 Table
groups 3 1 6 Table
user_action_logs_applications 0 2 2 Table
common_breached_passwords 0 0 1 Table
system_configuration 0 0 4 Table
application_daily_active_users 0 1 3 Table
previous_passwords 0 1 6 Table
entity_type_permissions 2 1 8 Table
user_comments 0 2 5 Table
entity_entity_grant_permissions 0 2 2 Table
identity_provider_links 0 4 7 Table
user_action_logs 1 3 18 Table
raw_global_registration_counts 0 0 4 Table
webhooks 2 2 15 Table
user_registrations_application_roles 0 2 2 Table
identity_providers_tenants 0 2 3 Table
families 0 1 7 Table
group_application_roles 0 2 2 Table
group_members 0 2 5 Table
current_usage_stats 0 0 3 Table
messengers 2 0 6 Table
entities 6 4 10 Table
webhooks_tenants 0 2 2 Table
user_actions 2 4 18 Table
breached_password_metrics 0 1 6 Table
migrations 0 0 2 Table
entity_user_grants 1 2 6 Table
identities 0 2 28 Table
form_steps 0 2 6 Table
themes 2 0 5 Table
user_consents_email_plus 0 1 3 Table
ip_location_database 0 0 3 Table
instance 0 1 8 Table
global_registration_counts 0 0 3 Table
raw_global_daily_active_users 0 0 2 Table
scim_external_id_groups 0 2 3 Table
email_templates 40 0 13 Table
usage_stats 0 0 9 Table
ip_location_meta_data 0 0 2 Table
audit_logs 0 0 5 Table
external_identifiers 3 3 8 Table
users 18 1 29 Table
connectors_tenants 0 2 4 Table
identity_providers_applications 0 3 5 Table
raw_logins 0 2 6 Table
identity_providers 4 4 11 Table
lambdas 17 0 8 Table
user_action_reasons 0 0 6 Table
master_record 0 0 2 Table
webauthn_credentials 0 2 7 Table
entity_user_grant_permissions 0 2 2 Table
kickstart_files 0 0 3 Table
keys 16 0 13 Table
applications 14 50 58 Table
ip_access_control_lists 3 0 5 Table
message_templates 30 0 6 Table
authentication_keys 0 2 12 Table
tenants 17 52 57 Table
locks 0 0 2 Table
refresh_tokens 0 3 12 Table
webhook_attempt_logs 0 2 6 Table
consents 2 2 7 Table
application_roles 2 1 8 Table
integrations 0 0 1 Table
global_daily_active_users 0 0 2 Table
raw_application_daily_active_users 0 0 3 Table
nodes 1 0 6 Table
application_monthly_active_users 0 1 3 Table
user_registrations 1 2 14 Table
asynchronous_tasks 0 1 8 Table
scim_external_id_users 0 2 3 Table
connectors 1 2 8 Table
clean_speak_applications 0 1 2 Table
hourly_logins 0 1 4 Table
request_frequencies 0 2 5 Table
raw_global_monthly_active_users 0 0 2 Table
forms 5 0 6 Table
raw_application_monthly_active_users 0 0 3 Table
last_login_instants 0 0 6 Table
webhook_event_logs 1 0 9 Table
raw_application_registration_counts 0 0 5 Table
global_monthly_active_users 0 0 2 Table
form_fields 1 1 6 Table
data_sets 0 0 2 Table
version 0 0 1 Table
entity_entity_grants 1 2 6 Table
application_registration_counts 0 1 4 Table
user_consents 1 3 7 Table
federated_domains 0 2 3 Table