email_templates


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
applications.email_update_email_templates_id applications_fk_28 R
applications.email_verification_email_templates_id applications_fk_10 R
applications.email_verified_email_templates_id applications_fk_23 R
applications.forgot_password_email_templates_id applications_fk_11 R
applications.login_id_in_use_on_create_email_templates_id applications_fk_29 R
applications.login_id_in_use_on_update_email_templates_id applications_fk_30 R
applications.login_new_device_email_templates_id applications_fk_24 R
applications.login_suspicious_email_templates_id applications_fk_25 R
applications.multi_factor_email_message_templates_id applications_fk_19 R
applications.password_reset_success_email_templates_id applications_fk_26 R
applications.password_update_email_templates_id applications_fk_31 R
applications.passwordless_email_templates_id applications_fk_12 R
applications.set_password_email_templates_id applications_fk_13 R
applications.two_factor_method_add_email_templates_id applications_fk_32 R
applications.two_factor_method_remove_email_templates_id applications_fk_33 R
applications.verification_email_templates_id applications_fk_1 R
consents.consent_email_templates_id consents_fk_1 R
consents.email_plus_email_templates_id consents_fk_2 R
tenants.confirm_child_email_templates_id tenants_fk_5 R
tenants.email_update_email_templates_id tenants_fk_17 R
tenants.email_verified_email_templates_id tenants_fk_18 R
tenants.family_request_email_templates_id tenants_fk_6 R
tenants.forgot_password_email_templates_id tenants_fk_1 R
tenants.login_id_in_use_on_create_email_templates_id tenants_fk_19 R
tenants.login_id_in_use_on_update_email_templates_id tenants_fk_20 R
tenants.login_new_device_email_templates_id tenants_fk_21 R
tenants.login_suspicious_email_templates_id tenants_fk_22 R
tenants.multi_factor_email_message_templates_id tenants_fk_13 R
tenants.parent_registration_email_templates_id tenants_fk_7 R
tenants.password_reset_success_email_templates_id tenants_fk_23 R
tenants.password_update_email_templates_id tenants_fk_24 R
tenants.passwordless_email_templates_id tenants_fk_4 R
tenants.set_password_email_templates_id tenants_fk_2 R
tenants.two_factor_method_add_email_templates_id tenants_fk_25 R
tenants.two_factor_method_remove_email_templates_id tenants_fk_26 R
tenants.verification_email_templates_id tenants_fk_3 R
user_actions.cancel_email_templates_id user_actions_fk_1 R
user_actions.end_email_templates_id user_actions_fk_2 R
user_actions.modify_email_templates_id user_actions_fk_3 R
user_actions.start_email_templates_id user_actions_fk_4 R
default_from_name varchar 255 null
default_html_template text 2147483647 null
default_subject varchar 255 null
default_text_template text 2147483647 null
from_email varchar 255 null
insert_instant int8 19 null
last_update_instant int8 19 null
localized_from_names text 2147483647 null
localized_html_templates text 2147483647 null
localized_subjects text 2147483647 null
localized_text_templates text 2147483647 null
name varchar 191 null

Indexes

Constraint Name Type Sort Column(s)
email_templates_pkey Primary key Asc id
email_templates_uk_1 Must be unique Asc name

Relationships