applications


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
application_daily_active_users.applications_id application_daily_active_users_fk_1 R
application_monthly_active_users.applications_id application_monthly_active_users_fk_1 R
application_oauth_scopes.applications_id application_oauth_scopes_fk_1 R
application_registration_counts.applications_id application_registration_counts_fk_1 R
application_roles.applications_id application_roles_fk_1 R
clean_speak_applications.applications_id clean_speak_applications_fk_1 R
external_identifiers.applications_id external_identifiers_fk_2 R
hourly_logins.applications_id hourly_logins_fk_1 R
identity_providers_applications.applications_id identity_providers_applications_fk_1 R
instance.tenant_manager_applications_id instance_fk_1 R
raw_logins.applications_id raw_logins_fk_1 R
refresh_tokens.applications_id refresh_tokens_fk_2 R
user_action_logs_applications.applications_id user_action_logs_applications_fk_1 C
user_registrations.applications_id user_registrations_fk_1 R
access_token_populate_lambdas_id uuid 2147483647 √ null
lambdas.id applications_fk_3 R
access_token_signing_keys_id uuid 2147483647 √ null
keys.id applications_fk_7 R
active bool 1 null
admin_registration_forms_id uuid 2147483647 null
forms.id applications_fk_15 R
data text 2147483647 null
email_update_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_28 R
email_verification_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_10 R
email_verified_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_23 R
forgot_password_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_11 R
forms_id uuid 2147483647 √ null
forms.id applications_fk_9 R
id_token_populate_lambdas_id uuid 2147483647 √ null
lambdas.id applications_fk_4 R
id_token_signing_keys_id uuid 2147483647 √ null
keys.id applications_fk_8 R
insert_instant int8 19 null
last_update_instant int8 19 null
login_id_in_use_on_create_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_29 R
login_id_in_use_on_update_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_30 R
login_new_device_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_24 R
login_suspicious_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_25 R
multi_factor_email_message_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_19 R
multi_factor_requirement_lambdas_id uuid 2147483647 √ null
lambdas.id applications_fk_50 R
multi_factor_sms_message_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_20 R
name varchar 191 null
passwordless_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_12 R
password_update_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_31 R
password_reset_success_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_26 R
phone_configuration_forgot_password_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_39 R
phone_configuration_identity_update_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_41 R
phone_configuration_login_id_in_use_on_create_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_42 R
phone_configuration_login_id_in_use_on_update_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_43 R
phone_configuration_login_new_device_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_44 R
phone_configuration_login_suspicious_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_45 R
phone_configuration_passwordless_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_36 R
phone_configuration_password_reset_success_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_46 R
phone_configuration_password_update_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_47 R
phone_configuration_set_password_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_40 R
phone_configuration_two_factor_method_add_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_48 R
phone_configuration_two_factor_method_remove_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_49 R
phone_configuration_verification_complete_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_38 R
phone_configuration_verification_templates_id uuid 2147483647 √ null
message_templates.id applications_fk_37 R
samlv2_default_verification_keys_id uuid 2147483647 √ null
keys.id applications_fk_14 R
samlv2_issuer varchar 191 √ null
samlv2_keys_id uuid 2147483647 √ null
keys.id applications_fk_5 R
samlv2_logout_keys_id uuid 2147483647 √ null
keys.id applications_fk_16 R
samlv2_logout_default_verification_keys_id uuid 2147483647 √ null
keys.id applications_fk_17 R
samlv2_populate_lambdas_id uuid 2147483647 √ null
lambdas.id applications_fk_6 R
samlv2_single_logout_keys_id uuid 2147483647 √ null
keys.id applications_fk_18 R
self_service_registration_validation_lambdas_id uuid 2147483647 √ null
lambdas.id applications_fk_34 R
self_service_user_forms_id uuid 2147483647 √ null
forms.id applications_fk_21 R
set_password_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_13 R
tenants_id uuid 2147483647 √ null
tenants.id applications_fk_2 R
themes_id uuid 2147483647 √ null
themes.id applications_fk_22 R
two_factor_method_add_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_32 R
two_factor_method_remove_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_33 R
ui_ip_access_control_lists_id uuid 2147483647 √ null
ip_access_control_lists.id applications_fk_27 R
universal bool 1 false
userinfo_populate_lambdas_id uuid 2147483647 √ null
lambdas.id applications_fk_35 R
verification_email_templates_id uuid 2147483647 √ null
email_templates.id applications_fk_1 R

Indexes

Constraint Name Type Sort Column(s)
applications_pkey Primary key Asc id
applications_i_1 Performance Asc tenants_id
applications_uk_1 Must be unique Asc/Asc name + tenants_id
applications_uk_2 Must be unique Asc/Asc samlv2_issuer + tenants_id

Relationships

Close relationships within degrees of separation