Table ezp54_community.ezuser Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
contentobject_id int 10 0
ezcollab_group.user_id ezcollab_group_ibfk_2 R
ezcollab_item.creator_id ezcollab_item_ibfk_1 R
ezcollab_item_group_link.user_id ezcollab_item_group_link_ibfk_3 R
ezcollab_item_message_link.participant_id ezcollab_item_message_link_ibfk_3 R
ezcollab_item_status.user_id ezcollab_item_status_ibfk_2 R
ezcollab_profile.user_id ezcollab_profile_ibfk_2 R
ezcollab_simple_message.creator_id ezcollab_simple_message_ibfk_1 R
ezcontentbrowsebookmark.user_id ezcontentbrowsebookmark_ibfk_2 R
ezcontentbrowserecent.user_id ezcontentbrowserecent_ibfk_2 R
ezcontentclass.creator_id ezcontentclass_ibfk_1 R
ezcontentclass.modifier_id ezcontentclass_ibfk_3 R
ezcontentclassgroup.creator_id ezcontentclassgroup_ibfk_1 R
ezcontentclassgroup.modifier_id ezcontentclassgroup_ibfk_2 R
ezcontentobject.owner_id ezcontentobject_ibfk_3 R
ezforgot_password.user_id ezforgot_password_ibfk_1 R
ezinfocollection.creator_id ezinfocollection_ibfk_2 R
ezorder.status_modifier_id ezorder_ibfk_3 R
ezorder.user_id ezorder_ibfk_4 R
ezorder_status_history.modifier_id ezorder_status_history_ibfk_1 R
ezpdf_export.creator_id ezpdf_export_ibfk_3 R
ezpdf_export.modifier_id ezpdf_export_ibfk_2 R
ezpreferences.user_id ezpreferences_ibfk_1 R
ezprest_authcode.user_id ezprest_authcode_ibfk_2 R
ezprest_authorized_clients.user_id ezprest_authorized_clients_ibfk_2 R
ezprest_clients.owner_id ezprest_clients_ibfk_1 R
ezrss_export.creator_id ezrss_export_ibfk_2 R
ezrss_export.modifier_id ezrss_export_ibfk_1 R
ezrss_import.creator_id ezrss_import_ibfk_2 R
ezrss_import.modifier_id ezrss_import_ibfk_4 R
ezrss_import.object_owner_id ezrss_import_ibfk_5 R
ezsession.user_id ezsession_ibfk_1 R
ezstarrating_data.user_id ezstarrating_data_ibfk_1 R
ezsubtree_notification_rule.user_id ezsubtree_notification_rule_ibfk_2 R
ezuser_accountkey.user_id ezuser_accountkey_ibfk_1 R
ezuser_setting.user_id ezuser_setting_ibfk_1 R
ezuservisit.user_id ezuservisit_ibfk_1 R
ezwishlist.user_id ezwishlist_ibfk_2 R
ezworkflow.creator_id ezworkflow_ibfk_1 R
ezworkflow.modifier_id ezworkflow_ibfk_2 R
ezworkflow_group.creator_id ezworkflow_group_ibfk_1 R
ezworkflow_group.modifier_id ezworkflow_group_ibfk_2 R
ezworkflow_process.user_id ezworkflow_process_ibfk_2 R
ezcontentobject.id ezuser_ibfk_1 R
email varchar 150
login varchar 150
password_hash varchar 50  √  null
password_hash_type int 10 1

Analyzed at ? 7 07 11:43 CEST 2015

Indexes:
Column(s) Type Sort Constraint Name
contentobject_id Primary key Asc PRIMARY
login Performance Asc ezuser_login

Close relationships  within of separation: