SchemaSpy Analysis of ezp54_community - ColumnseZ Publish 5.4 Database Schema Diagram Generated by
SchemaSpy
Generated by SchemaSpy on ? 7 07 11:43 CEST 2015
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

ezp54_community contains 821 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
ezapprove_items collaboration_id int 10 0
ezapprove_items id int 10  √ 
ezapprove_items workflow_process_id int 10 0
ezbasket id int 10  √ 
ezbasket order_id int 10 0
ezbasket productcollection_id int 10 0
ezbasket session_id varchar 255
ezbinaryfile contentobject_attribute_id int 10 0
ezbinaryfile download_count int 10 0
ezbinaryfile filename varchar 255
ezbinaryfile mime_type varchar 255
ezbinaryfile original_filename varchar 255
ezbinaryfile version int 10 0
ezcobj_state default_language_id bigint 19 0
ezcobj_state group_id int 10 0
ezcobj_state id int 10  √ 
ezcobj_state identifier varchar 45
ezcobj_state language_mask bigint 19 0
ezcobj_state priority int 10 0
ezcobj_state_group default_language_id bigint 19 0
ezcobj_state_group id int 10  √ 
ezcobj_state_group identifier varchar 45
ezcobj_state_group language_mask bigint 19 0
ezcobj_state_group_language contentobject_state_group_id int 10 0
ezcobj_state_group_language description longtext 2147483647
ezcobj_state_group_language language_id bigint 19 0
ezcobj_state_group_language name varchar 45
ezcobj_state_group_language real_language_id bigint 19 0
ezcobj_state_language contentobject_state_id int 10 0
ezcobj_state_language description longtext 2147483647
ezcobj_state_language language_id bigint 19 0
ezcobj_state_language name varchar 45
ezcobj_state_link contentobject_id int 10 0
ezcobj_state_link contentobject_state_id int 10 0
ezcollab_group created int 10 0
ezcollab_group depth int 10 0
ezcollab_group id int 10  √ 
ezcollab_group is_open int 10 1
ezcollab_group modified int 10 0
ezcollab_group parent_group_id int 10 0
ezcollab_group path_string varchar 255
ezcollab_group priority int 10 0
ezcollab_group title varchar 255
ezcollab_group user_id int 10 0
ezcollab_item created int 10 0
ezcollab_item creator_id int 10 0
ezcollab_item data_float1 float 12 0
ezcollab_item data_float2 float 12 0
ezcollab_item data_float3 float 12 0
ezcollab_item data_int1 int 10 0
ezcollab_item data_int2 int 10 0
ezcollab_item data_int3 int 10 0
ezcollab_item data_text1 longtext 2147483647
ezcollab_item data_text2 longtext 2147483647
ezcollab_item data_text3 longtext 2147483647
ezcollab_item id int 10  √ 
ezcollab_item modified int 10 0
ezcollab_item status int 10 1
ezcollab_item type_identifier varchar 40
ezcollab_item_group_link collaboration_id int 10 0
ezcollab_item_group_link created int 10 0
ezcollab_item_group_link group_id int 10 0
ezcollab_item_group_link is_active int 10 1
ezcollab_item_group_link is_read int 10 0
ezcollab_item_group_link last_read int 10 0
ezcollab_item_group_link modified int 10 0
ezcollab_item_group_link user_id int 10 0
ezcollab_item_message_link collaboration_id int 10 0
ezcollab_item_message_link created int 10 0
ezcollab_item_message_link id int 10  √ 
ezcollab_item_message_link message_id int 10 0
ezcollab_item_message_link message_type int 10 0
ezcollab_item_message_link modified int 10 0
ezcollab_item_message_link participant_id int 10 0
ezcollab_item_participant_link collaboration_id int 10 0
ezcollab_item_participant_link created int 10 0
ezcollab_item_participant_link is_active int 10 1
ezcollab_item_participant_link is_read int 10 0
ezcollab_item_participant_link last_read int 10 0
ezcollab_item_participant_link modified int 10 0
ezcollab_item_participant_link participant_id int 10 0
ezcollab_item_participant_link participant_role int 10 1
ezcollab_item_participant_link participant_type int 10 1
ezcollab_item_status collaboration_id int 10 0
ezcollab_item_status is_active int 10 1
ezcollab_item_status is_read int 10 0
ezcollab_item_status last_read int 10 0
ezcollab_item_status user_id int 10 0
ezcollab_notification_rule collab_identifier varchar 255
ezcollab_notification_rule id int 10  √ 
ezcollab_notification_rule user_id varchar 255
ezcollab_profile created int 10 0
ezcollab_profile data_text1 longtext 2147483647
ezcollab_profile id int 10  √ 
ezcollab_profile main_group int 10 0
ezcollab_profile modified int 10 0
ezcollab_profile user_id int 10 0
ezcollab_simple_message created int 10 0
ezcollab_simple_message creator_id int 10 0
ezcollab_simple_message data_float1 float 12 0
ezcollab_simple_message data_float2 float 12 0
ezcollab_simple_message data_float3 float 12 0
ezcollab_simple_message data_int1 int 10 0
ezcollab_simple_message data_int2 int 10 0
ezcollab_simple_message data_int3 int 10 0
ezcollab_simple_message data_text1 longtext 2147483647
ezcollab_simple_message data_text2 longtext 2147483647
ezcollab_simple_message data_text3 longtext 2147483647
ezcollab_simple_message id int 10  √ 
ezcollab_simple_message message_type varchar 40
ezcollab_simple_message modified int 10 0
ezcontent_language disabled int 10 0
ezcontent_language id bigint 19 0
ezcontent_language locale varchar 20
ezcontent_language name varchar 255
ezcontentbrowsebookmark id int 10  √ 
ezcontentbrowsebookmark name varchar 255
ezcontentbrowsebookmark node_id int 10 0
ezcontentbrowsebookmark user_id int 10 0
ezcontentbrowserecent created int 10 0
ezcontentbrowserecent id int 10  √ 
ezcontentbrowserecent name varchar 255
ezcontentbrowserecent node_id int 10 0
ezcontentbrowserecent user_id int 10 0
ezcontentclass always_available int 10 0
ezcontentclass contentobject_name varchar 255  √  null
ezcontentclass created int 10 0
ezcontentclass creator_id int 10 0
ezcontentclass id int 10  √ 
ezcontentclass identifier varchar 50
ezcontentclass initial_language_id bigint 19 0
ezcontentclass is_container int 10 0
ezcontentclass language_mask bigint 19 0
ezcontentclass modified int 10 0
ezcontentclass modifier_id int 10 0
ezcontentclass remote_id varchar 100
ezcontentclass serialized_description_list longtext 2147483647  √  null
ezcontentclass serialized_name_list longtext 2147483647  √  null
ezcontentclass sort_field int 10 1
ezcontentclass sort_order int 10 1
ezcontentclass url_alias_name varchar 255  √  null
ezcontentclass version int 10 0
ezcontentclass_attribute can_translate int 10  √  1
ezcontentclass_attribute category varchar 25
ezcontentclass_attribute contentclass_id int 10 0
ezcontentclass_attribute data_float1 double 22  √  null
ezcontentclass_attribute data_float2 double 22  √  null
ezcontentclass_attribute data_float3 double 22  √  null
ezcontentclass_attribute data_float4 double 22  √  null
ezcontentclass_attribute data_int1 int 10  √  null
ezcontentclass_attribute data_int2 int 10  √  null
ezcontentclass_attribute data_int3 int 10  √  null
ezcontentclass_attribute data_int4 int 10  √  null
ezcontentclass_attribute data_text1 varchar 50  √  null
ezcontentclass_attribute data_text2 varchar 50  √  null
ezcontentclass_attribute data_text3 varchar 50  √  null
ezcontentclass_attribute data_text4 varchar 255  √  null
ezcontentclass_attribute data_text5 longtext 2147483647  √  null
ezcontentclass_attribute data_type_string varchar 50
ezcontentclass_attribute id int 10  √ 
ezcontentclass_attribute identifier varchar 50
ezcontentclass_attribute is_information_collector int 10 0
ezcontentclass_attribute is_required int 10 0
ezcontentclass_attribute is_searchable int 10 0
ezcontentclass_attribute placement int 10 0
ezcontentclass_attribute serialized_data_text longtext 2147483647  √  null
ezcontentclass_attribute serialized_description_list longtext 2147483647  √  null
ezcontentclass_attribute serialized_name_list longtext 2147483647
ezcontentclass_attribute version int 10 0
ezcontentclass_classgroup contentclass_id int 10 0
ezcontentclass_classgroup contentclass_version int 10 0
ezcontentclass_classgroup group_id int 10 0
ezcontentclass_classgroup group_name varchar 255  √  null
ezcontentclass_name contentclass_id int 10 0
ezcontentclass_name contentclass_version int 10 0
ezcontentclass_name language_id bigint 19 0
ezcontentclass_name language_locale varchar 20
ezcontentclass_name name varchar 255
ezcontentclassgroup created int 10 0
ezcontentclassgroup creator_id int 10 0
ezcontentclassgroup id int 10  √ 
ezcontentclassgroup modified int 10 0
ezcontentclassgroup modifier_id int 10 0
ezcontentclassgroup name varchar 255  √  null
ezcontentobject contentclass_id int 10 0
ezcontentobject current_version int 10  √  null
ezcontentobject id int 10  √ 
ezcontentobject initial_language_id bigint 19 0
ezcontentobject language_mask bigint 19 0
ezcontentobject modified int 10 0
ezcontentobject name varchar 255  √  null
ezcontentobject owner_id int 10 0
ezcontentobject published int 10 0
ezcontentobject remote_id varchar 100  √  null
ezcontentobject section_id int 10 0
ezcontentobject status int 10  √  0
ezcontentobject_attribute attribute_original_id int 10  √  0
ezcontentobject_attribute contentclassattribute_id int 10 0
ezcontentobject_attribute contentobject_id int 10 0
ezcontentobject_attribute data_float double 22  √  null
ezcontentobject_attribute data_int int 10  √  null
ezcontentobject_attribute data_text longtext 2147483647  √  null
ezcontentobject_attribute data_type_string varchar 50  √ 
ezcontentobject_attribute id int 10  √ 
ezcontentobject_attribute language_code varchar 20
ezcontentobject_attribute language_id bigint 19 0
ezcontentobject_attribute sort_key_int int 10 0
ezcontentobject_attribute sort_key_string varchar 255
ezcontentobject_attribute version int 10 0
ezcontentobject_link contentclassattribute_id int 10 0
ezcontentobject_link from_contentobject_id int 10 0
ezcontentobject_link from_contentobject_version int 10 0
ezcontentobject_link id int 10  √ 
ezcontentobject_link relation_type int 10 1
ezcontentobject_link to_contentobject_id int 10 0
ezcontentobject_name content_translation varchar 20
ezcontentobject_name content_version int 10 0
ezcontentobject_name contentobject_id int 10 0
ezcontentobject_name language_id bigint 19 0
ezcontentobject_name name varchar 255  √  null
ezcontentobject_name real_translation varchar 20  √  null
ezcontentobject_trash contentobject_id int 10  √  null
ezcontentobject_trash contentobject_version int 10  √  null
ezcontentobject_trash depth int 10 0
ezcontentobject_trash is_hidden int 10 0
ezcontentobject_trash is_invisible int 10 0
ezcontentobject_trash main_node_id int 10  √  null
ezcontentobject_trash modified_subnode int 10  √  0
ezcontentobject_trash node_id int 10 0
ezcontentobject_trash parent_node_id int 10 0
ezcontentobject_trash path_identification_string longtext 2147483647  √  null
ezcontentobject_trash path_string varchar 255
ezcontentobject_trash priority int 10 0
ezcontentobject_trash remote_id varchar 100
ezcontentobject_trash sort_field int 10  √  1
ezcontentobject_trash sort_order int 10  √  1
ezcontentobject_tree contentobject_id int 10  √  null
ezcontentobject_tree contentobject_is_published int 10  √  null
ezcontentobject_tree contentobject_version int 10  √  null
ezcontentobject_tree depth int 10 0
ezcontentobject_tree is_hidden int 10 0
ezcontentobject_tree is_invisible int 10 0
ezcontentobject_tree main_node_id int 10  √  null
ezcontentobject_tree modified_subnode int 10  √  0
ezcontentobject_tree node_id int 10  √ 
ezcontentobject_tree parent_node_id int 10 0
ezcontentobject_tree path_identification_string longtext 2147483647  √  null
ezcontentobject_tree path_string varchar 255
ezcontentobject_tree priority int 10 0
ezcontentobject_tree remote_id varchar 100
ezcontentobject_tree sort_field int 10  √  1
ezcontentobject_tree sort_order int 10  √  1
ezcontentobject_version contentobject_id int 10  √  null
ezcontentobject_version created int 10 0
ezcontentobject_version creator_id int 10 0
ezcontentobject_version id int 10  √ 
ezcontentobject_version initial_language_id bigint 19 0
ezcontentobject_version language_mask bigint 19 0
ezcontentobject_version modified int 10 0
ezcontentobject_version status int 10 0
ezcontentobject_version user_id int 10 0
ezcontentobject_version version int 10 0
ezcontentobject_version workflow_event_pos int 10  √  0
ezcurrencydata auto_rate_value decimal 10,5 0.00000
ezcurrencydata code varchar 4
ezcurrencydata custom_rate_value decimal 10,5 0.00000
ezcurrencydata id int 10  √ 
ezcurrencydata locale varchar 255
ezcurrencydata rate_factor decimal 10,5 1.00000
ezcurrencydata status int 10 1
ezcurrencydata symbol varchar 255
ezdiscountrule id int 10  √ 
ezdiscountrule name varchar 255
ezdiscountsubrule discount_percent float 12  √  null
ezdiscountsubrule discountrule_id int 10 0
ezdiscountsubrule id int 10  √ 
ezdiscountsubrule limitation char 1  √  null
ezdiscountsubrule name varchar 255
ezdiscountsubrule_value discountsubrule_id int 10 0
ezdiscountsubrule_value issection int 10 0
ezdiscountsubrule_value value int 10 0
ezenumobjectvalue contentobject_attribute_id int 10 0
ezenumobjectvalue contentobject_attribute_version int 10 0
ezenumobjectvalue enumelement varchar 255
ezenumobjectvalue enumid int 10 0
ezenumobjectvalue enumvalue varchar 255
ezenumvalue contentclass_attribute_id int 10 0
ezenumvalue contentclass_attribute_version int 10 0
ezenumvalue enumelement varchar 255
ezenumvalue enumvalue varchar 255
ezenumvalue id int 10  √ 
ezenumvalue placement int 10 0
ezfind_elevate_configuration contentobject_id int 10 0
ezfind_elevate_configuration language_code varchar 20
ezfind_elevate_configuration search_query varchar 255
ezforgot_password hash_key varchar 32
ezforgot_password id int 10  √ 
ezforgot_password time int 10 0
ezforgot_password user_id int 10 0
ezgeneral_digest_user_settings day varchar 255
ezgeneral_digest_user_settings digest_type int 10 0
ezgeneral_digest_user_settings id int 10  √ 
ezgeneral_digest_user_settings receive_digest int 10 0
ezgeneral_digest_user_settings time varchar 255
ezgeneral_digest_user_settings user_id int 10 0
ezgmaplocation address varchar 150  √  null
ezgmaplocation contentobject_attribute_id int 10 0
ezgmaplocation contentobject_version int 10 0
ezgmaplocation latitude double 22 0
ezgmaplocation longitude double 22 0
ezimagefile contentobject_attribute_id int 10 0
ezimagefile filepath longtext 2147483647
ezimagefile id int 10  √ 
ezinfocollection contentobject_id int 10 0
ezinfocollection created int 10 0
ezinfocollection creator_id int 10 0
ezinfocollection id int 10  √ 
ezinfocollection modified int 10  √  0
ezinfocollection user_identifier varchar 34  √  null
ezinfocollection_attribute contentclass_attribute_id int 10 0
ezinfocollection_attribute contentobject_attribute_id int 10  √  null
ezinfocollection_attribute contentobject_id int 10  √  null
ezinfocollection_attribute data_float float 12  √  null
ezinfocollection_attribute data_int int 10  √  null
ezinfocollection_attribute data_text longtext 2147483647  √  null
ezinfocollection_attribute id int 10  √ 
ezinfocollection_attribute informationcollection_id int 10 0
ezisbn_group description varchar 255
ezisbn_group group_number int 10 0
ezisbn_group id int 10  √ 
ezisbn_group_range from_number int 10 0
ezisbn_group_range group_from varchar 32
ezisbn_group_range group_length int 10 0
ezisbn_group_range group_to varchar 32
ezisbn_group_range id int 10  √ 
ezisbn_group_range to_number int 10 0
ezisbn_registrant_range from_number int 10 0
ezisbn_registrant_range id int 10  √ 
ezisbn_registrant_range isbn_group_id int 10 0
ezisbn_registrant_range registrant_from varchar 32
ezisbn_registrant_range registrant_length int 10 0
ezisbn_registrant_range registrant_to varchar 32
ezisbn_registrant_range to_number int 10 0
ezkeyword class_id int 10 0
ezkeyword id int 10  √ 
ezkeyword keyword varchar 255  √  null
ezkeyword_attribute_link id int 10  √ 
ezkeyword_attribute_link keyword_id int 10 0
ezkeyword_attribute_link objectattribute_id int 10 0
ezm_block block_type varchar 255  √  null
ezm_block fetch_params longtext 2147483647  √  null
ezm_block id char 32
ezm_block is_removed int unsigned 10  √  0
ezm_block last_update int unsigned 10  √  0
ezm_block name varchar 255  √  null
ezm_block node_id int unsigned 10
ezm_block overflow_id char 32  √  null
ezm_block rotation_interval int unsigned 10  √  null
ezm_block rotation_type int unsigned 10  √  null
ezm_block zone_id char 32
ezm_pool block_id char 32
ezm_pool moved_to char 32  √  null
ezm_pool node_id int unsigned 10
ezm_pool object_id int unsigned 10
ezm_pool priority int unsigned 10  √  0
ezm_pool rotation_until int unsigned 10  √  0
ezm_pool ts_hidden int unsigned 10  √  0
ezm_pool ts_publication int 10  √  0
ezm_pool ts_visible int unsigned 10  √  0
ezmedia contentobject_attribute_id int 10 0
ezmedia controls varchar 50  √  null
ezmedia filename varchar 255
ezmedia has_controller int 10  √  0
ezmedia height int 10  √  null
ezmedia is_autoplay int 10  √  0
ezmedia is_loop int 10  √  0
ezmedia mime_type varchar 50
ezmedia original_filename varchar 255
ezmedia pluginspage varchar 255  √  null
ezmedia quality varchar 50  √  null
ezmedia version int 10 0
ezmedia width int 10  √  null
ezmessage body longtext 2147483647  √  null
ezmessage destination_address varchar 50
ezmessage id int 10  √ 
ezmessage is_sent int 10 0
ezmessage send_method varchar 50
ezmessage send_time varchar 50
ezmessage send_weekday varchar 50
ezmessage title varchar 255
ezmodule_run function_name varchar 255  √  null
ezmodule_run id int 10  √ 
ezmodule_run module_data longtext 2147483647  √  null
ezmodule_run module_name varchar 255  √  null
ezmodule_run workflow_process_id int 10  √  null
ezmultipricedata contentobject_attr_id int 10 0
ezmultipricedata contentobject_attr_version int 10 0
ezmultipricedata currency_code varchar 4
ezmultipricedata id int 10  √ 
ezmultipricedata type int 10 0
ezmultipricedata value decimal 15,2 0.00
eznode_assignment contentobject_id int 10  √  null
eznode_assignment contentobject_version int 10  √  null
eznode_assignment from_node_id int 10  √  0
eznode_assignment id int 10  √ 
eznode_assignment is_hidden int 10 0
eznode_assignment is_main int 10 0
eznode_assignment op_code int 10 0
eznode_assignment parent_node int 10  √  null
eznode_assignment parent_remote_id varchar 100
eznode_assignment priority int 10 0
eznode_assignment remote_id varchar 100 0
eznode_assignment sort_field int 10  √  1
eznode_assignment sort_order int 10  √  1
eznotificationcollection data_subject longtext 2147483647
eznotificationcollection data_text longtext 2147483647
eznotificationcollection event_id int 10 0
eznotificationcollection handler varchar 255
eznotificationcollection id int 10  √ 
eznotificationcollection transport varchar 255
eznotificationcollection_item address varchar 255
eznotificationcollection_item collection_id int 10 0
eznotificationcollection_item event_id int 10 0
eznotificationcollection_item id int 10  √ 
eznotificationcollection_item send_date int 10 0
eznotificationevent data_int1 int 10 0
eznotificationevent data_int2 int 10 0
eznotificationevent data_int3 int 10 0
eznotificationevent data_int4 int 10 0
eznotificationevent data_text1 longtext 2147483647
eznotificationevent data_text2 longtext 2147483647
eznotificationevent data_text3 longtext 2147483647
eznotificationevent data_text4 longtext 2147483647
eznotificationevent event_type_string varchar 255
eznotificationevent id int 10  √ 
eznotificationevent status int 10 0
ezoperation_memento id int 10  √ 
ezoperation_memento main int 10 0
ezoperation_memento main_key varchar 32
ezoperation_memento memento_data longtext 2147483647
ezoperation_memento memento_key varchar 32
ezorder account_identifier varchar 100 default
ezorder created int 10 0
ezorder data_text_1 longtext 2147483647  √  null
ezorder data_text_2 longtext 2147483647  √  null
ezorder email varchar 150  √ 
ezorder id int 10  √ 
ezorder ignore_vat int 10 0
ezorder is_archived int 10 0
ezorder is_temporary int 10 1
ezorder order_nr int 10 0
ezorder productcollection_id int 10 0
ezorder status_id int 10  √  0
ezorder status_modified int 10  √  0
ezorder status_modifier_id int 10  √  0
ezorder user_id int 10 0
ezorder_item description varchar 255  √  null
ezorder_item id int 10  √ 
ezorder_item is_vat_inc int 10 0
ezorder_item order_id int 10 0
ezorder_item price float 12  √  null
ezorder_item type varchar 30  √  null
ezorder_item vat_value float 12 0
ezorder_nr_incr id int 10  √ 
ezorder_status id int 10  √ 
ezorder_status is_active int 10 1
ezorder_status name varchar 255
ezorder_status status_id int 10 0
ezorder_status_history id int 10  √ 
ezorder_status_history modified int 10 0
ezorder_status_history modifier_id int 10 0
ezorder_status_history order_id int 10 0
ezorder_status_history status_id int 10 0
ezpackage id int 10  √ 
ezpackage install_date int 10 0
ezpackage name varchar 100
ezpackage version varchar 30 0
ezpaymentobject id int 10  √ 
ezpaymentobject order_id int 10 0
ezpaymentobject payment_string varchar 255
ezpaymentobject status int 10 0
ezpaymentobject workflowprocess_id int 10 0
ezpdf_export created int 10  √  null
ezpdf_export creator_id int 10  √  null
ezpdf_export export_classes varchar 255  √  null
ezpdf_export export_structure varchar 255  √  null
ezpdf_export id int 10  √ 
ezpdf_export intro_text longtext 2147483647  √  null
ezpdf_export modified int 10  √  null
ezpdf_export modifier_id int 10  √  null
ezpdf_export pdf_filename varchar 255  √  null
ezpdf_export show_frontpage int 10  √  null
ezpdf_export site_access varchar 255  √  null
ezpdf_export source_node_id int 10  √  null
ezpdf_export status int 10  √  null
ezpdf_export sub_text longtext 2147483647  √  null
ezpdf_export title varchar 255  √  null
ezpdf_export version int 10 0
ezpending_actions action varchar 64
ezpending_actions created int 10  √  null
ezpending_actions id int 10  √ 
ezpending_actions param longtext 2147483647  √  null
ezpolicy function_name varchar 255  √  null
ezpolicy id int 10  √ 
ezpolicy module_name varchar 255  √  null
ezpolicy original_id int 10 0
ezpolicy role_id int 10  √  null
ezpolicy_limitation id int 10  √ 
ezpolicy_limitation identifier varchar 255
ezpolicy_limitation policy_id int 10  √  null
ezpolicy_limitation_value id int 10  √ 
ezpolicy_limitation_value limitation_id int 10  √  null
ezpolicy_limitation_value value varchar 255  √  null
ezpreferences id int 10  √ 
ezpreferences name varchar 100  √  null
ezpreferences user_id int 10 0
ezpreferences value longtext 2147483647  √  null
ezprest_authcode client_id varchar 200
ezprest_authcode expirytime bigint 19 0
ezprest_authcode id varchar 200
ezprest_authcode scope varchar 200  √  null
ezprest_authcode user_id int 10 0
ezprest_authorized_clients created int 10  √  null
ezprest_authorized_clients id int 10  √ 
ezprest_authorized_clients rest_client_id int 10  √  null
ezprest_authorized_clients user_id int 10  √  null
ezprest_clients client_id varchar 200  √  null
ezprest_clients client_secret varchar 200  √  null
ezprest_clients created int 10 0
ezprest_clients description longtext 2147483647  √  null
ezprest_clients endpoint_uri varchar 200  √  null
ezprest_clients id int 10  √ 
ezprest_clients name varchar 100  √  null
ezprest_clients owner_id int 10 0
ezprest_clients updated int 10 0
ezprest_clients version int 10 0
ezprest_token client_id varchar 200
ezprest_token expirytime bigint 19 0
ezprest_token id varchar 200
ezprest_token refresh_token varchar 200
ezprest_token scope varchar 200  √  null
ezprest_token user_id int 10 0
ezproductcategory id int 10  √ 
ezproductcategory name varchar 255
ezproductcollection created int 10  √  null
ezproductcollection currency_code varchar 4
ezproductcollection id int 10  √ 
ezproductcollection_item contentobject_id int 10 0
ezproductcollection_item discount float 12  √  null
ezproductcollection_item id int 10  √ 
ezproductcollection_item is_vat_inc int 10  √  null
ezproductcollection_item item_count int 10 0
ezproductcollection_item name varchar 255
ezproductcollection_item price float 12  √  0
ezproductcollection_item productcollection_id int 10 0
ezproductcollection_item vat_value float 12  √  null
ezproductcollection_item_opt id int 10  √ 
ezproductcollection_item_opt item_id int 10 0
ezproductcollection_item_opt name varchar 255
ezproductcollection_item_opt object_attribute_id int 10  √  null
ezproductcollection_item_opt option_item_id int 10 0
ezproductcollection_item_opt price float 12 0
ezproductcollection_item_opt value varchar 255
ezpublishingqueueprocesses created int 10  √  null
ezpublishingqueueprocesses ezcontentobject_version_id int 10 0
ezpublishingqueueprocesses finished int 10  √  null
ezpublishingqueueprocesses pid int 10  √  null
ezpublishingqueueprocesses started int 10  √  null
ezpublishingqueueprocesses status int 10  √  null
ezrole id int 10  √ 
ezrole is_new int 10 0
ezrole name varchar 255
ezrole value char 1  √  null
ezrole version int 10  √  0
ezrss_export access_url varchar 255  √  null
ezrss_export active int 10  √  null
ezrss_export created int 10  √  null
ezrss_export creator_id int 10  √  null
ezrss_export description longtext 2147483647  √  null
ezrss_export id int 10  √ 
ezrss_export image_id int 10  √  null
ezrss_export main_node_only int 10 1
ezrss_export modified int 10  √  null
ezrss_export modifier_id int 10  √  null
ezrss_export node_id int 10  √  null
ezrss_export number_of_objects int 10 0
ezrss_export rss_version varchar 255  √  null
ezrss_export site_access varchar 255  √  null
ezrss_export status int 10 0
ezrss_export title varchar 255  √  null
ezrss_export url varchar 255  √  null
ezrss_export_item category varchar 255  √  null
ezrss_export_item class_id int 10  √  null
ezrss_export_item description varchar 255  √  null
ezrss_export_item enclosure varchar 255  √  null
ezrss_export_item id int 10  √ 
ezrss_export_item rssexport_id int 10  √  null
ezrss_export_item source_node_id int 10  √  null
ezrss_export_item status int 10 0
ezrss_export_item subnodes int 10 0
ezrss_export_item title varchar 255  √  null
ezrss_import active int 10  √  null
ezrss_import class_description varchar 255  √  null
ezrss_import class_id int 10  √  null
ezrss_import class_title varchar 255  √  null
ezrss_import class_url varchar 255  √  null
ezrss_import created int 10  √  null
ezrss_import creator_id int 10  √  null
ezrss_import destination_node_id int 10  √  null
ezrss_import id int 10  √ 
ezrss_import import_description longtext 2147483647
ezrss_import modified int 10  √  null
ezrss_import modifier_id int 10  √  null
ezrss_import name varchar 255  √  null
ezrss_import object_owner_id int 10  √  null
ezrss_import status int 10 0
ezrss_import url longtext 2147483647  √  null
ezscheduled_script command varchar 255
ezscheduled_script id int 10  √ 
ezscheduled_script last_report_timestamp int 10 0
ezscheduled_script name varchar 50
ezscheduled_script process_id int 10 0
ezscheduled_script progress int 10  √  0
ezscheduled_script user_id int 10 0
ezsearch_object_word_link contentclass_attribute_id int 10 0
ezsearch_object_word_link contentclass_id int 10 0
ezsearch_object_word_link contentobject_id int 10 0
ezsearch_object_word_link frequency float 12 0
ezsearch_object_word_link id int 10  √ 
ezsearch_object_word_link identifier varchar 255
ezsearch_object_word_link integer_value int 10 0
ezsearch_object_word_link next_word_id int 10 0
ezsearch_object_word_link placement int 10 0
ezsearch_object_word_link prev_word_id int 10 0
ezsearch_object_word_link published int 10 0
ezsearch_object_word_link section_id int 10 0
ezsearch_object_word_link word_id int 10 0
ezsearch_return_count t int 10  √  null
ezsearch_search_phrase id int 10  √ 
ezsearch_search_phrase phrase varchar 250  √  null
ezsearch_search_phrase phrase_count int 10  √  0
ezsearch_search_phrase result_count int 10  √  0
ezsearch_word id int 10  √ 
ezsearch_word object_count int 10 0
ezsearch_word word varchar 150  √  null
ezsection id int 10  √ 
ezsection identifier varchar 255  √  null
ezsection locale varchar 255  √  null
ezsection name varchar 255  √  null
ezsection navigation_part_identifier varchar 100  √  ezcontentnavigationpart
ezsession data longtext 2147483647
ezsession expiration_time int 10 0
ezsession session_key varchar 32
ezsession user_hash varchar 32
ezsession user_id int 10 0
ezsite_data name varchar 60
ezsite_data value longtext 2147483647
ezstarrating contentobject_attribute_id int 10
ezstarrating contentobject_id int 10
ezstarrating rating_average float 12
ezstarrating rating_count int 10
ezstarrating_data contentobject_attribute_id int 10
ezstarrating_data contentobject_id int 10
ezstarrating_data created_at int 10
ezstarrating_data id int 10  √ 
ezstarrating_data rating float 12
ezstarrating_data session_key varchar 32
ezstarrating_data user_id int 10
ezsubtree_notification_rule id int 10  √ 
ezsubtree_notification_rule node_id int 10 0
ezsubtree_notification_rule use_digest int 10  √  0
ezsubtree_notification_rule user_id int 10 0
eztipafriend_counter count int 10 0
eztipafriend_counter node_id int 10 0
eztipafriend_counter requested int 10 0
eztipafriend_request created int 10 0
eztipafriend_request email_receiver varchar 100
eztrigger connect_type char 1
eztrigger function_name varchar 200
eztrigger id int 10  √ 
eztrigger module_name varchar 200
eztrigger name varchar 255  √  null
eztrigger workflow_id int 10  √  null
ezurl created int 10 0
ezurl id int 10  √ 
ezurl is_valid int 10 1
ezurl last_checked int 10 0
ezurl modified int 10 0
ezurl original_url_md5 varchar 32
ezurl url longtext 2147483647  √  null
ezurl_object_link contentobject_attribute_id int 10 0
ezurl_object_link contentobject_attribute_version int 10 0
ezurl_object_link url_id int 10 0
ezurlalias destination_url longtext 2147483647
ezurlalias forward_to_id int 10 0
ezurlalias id int 10  √ 
ezurlalias is_imported int 10 0
ezurlalias is_internal int 10 1
ezurlalias is_wildcard int 10 0
ezurlalias source_md5 varchar 32  √  null
ezurlalias source_url longtext 2147483647
ezurlalias_ml action longtext 2147483647
ezurlalias_ml action_type varchar 32
ezurlalias_ml alias_redirects int 10 1
ezurlalias_ml id int 10 0
ezurlalias_ml is_alias int 10 0
ezurlalias_ml is_original int 10 0
ezurlalias_ml lang_mask bigint 19 0
ezurlalias_ml link int 10 0
ezurlalias_ml parent int 10 0
ezurlalias_ml text longtext 2147483647
ezurlalias_ml text_md5 varchar 32
ezurlalias_ml_incr id int 10  √ 
ezurlwildcard destination_url longtext 2147483647
ezurlwildcard id int 10  √ 
ezurlwildcard source_url longtext 2147483647
ezurlwildcard type int 10 0
ezuser contentobject_id int 10 0
ezuser email varchar 150
ezuser login varchar 150
ezuser password_hash varchar 50  √  null
ezuser password_hash_type int 10 1
ezuser_accountkey hash_key varchar 32
ezuser_accountkey id int 10  √ 
ezuser_accountkey time int 10 0
ezuser_accountkey user_id int 10 0
ezuser_discountrule contentobject_id int 10  √  null
ezuser_discountrule discountrule_id int 10  √  null
ezuser_discountrule id int 10  √ 
ezuser_discountrule name varchar 255
ezuser_role contentobject_id int 10  √  null
ezuser_role id int 10  √ 
ezuser_role limit_identifier varchar 255  √ 
ezuser_role limit_value varchar 255  √ 
ezuser_role role_id int 10  √  null
ezuser_setting is_enabled int 10 0
ezuser_setting max_login int 10  √  null
ezuser_setting user_id int 10 0
ezuservisit current_visit_timestamp int 10 0
ezuservisit failed_login_attempts int 10 0
ezuservisit last_visit_timestamp int 10 0
ezuservisit login_count int 10 0
ezuservisit user_id int 10 0
ezvatrule country_code varchar 255
ezvatrule id int 10  √ 
ezvatrule vat_type int 10 0
ezvatrule_product_category product_category_id int 10 0
ezvatrule_product_category vatrule_id int 10 0
ezvattype id int 10  √ 
ezvattype name varchar 255
ezvattype percentage float 12  √  null
ezview_counter count int 10 0
ezview_counter node_id int 10 0
ezwaituntildatevalue contentclass_attribute_id int 10 0
ezwaituntildatevalue contentclass_id int 10 0
ezwaituntildatevalue id int 10  √ 
ezwaituntildatevalue workflow_event_id int 10 0
ezwaituntildatevalue workflow_event_version int 10 0
ezwishlist id int 10  √ 
ezwishlist productcollection_id int 10 0
ezwishlist user_id int 10 0
ezworkflow created int 10 0
ezworkflow creator_id int 10 0
ezworkflow id int 10  √ 
ezworkflow is_enabled int 10 0
ezworkflow modified int 10 0
ezworkflow modifier_id int 10 0
ezworkflow name varchar 255
ezworkflow version int 10 0
ezworkflow workflow_type_string varchar 50
ezworkflow_assign access_type int 10 0
ezworkflow_assign as_tree int 10 0
ezworkflow_assign id int 10  √ 
ezworkflow_assign node_id int 10 0
ezworkflow_assign workflow_id int 10 0
ezworkflow_event data_int1 int 10  √  null
ezworkflow_event data_int2 int 10  √  null
ezworkflow_event data_int3 int 10  √  null
ezworkflow_event data_int4 int 10  √  null
ezworkflow_event data_text1 varchar 255  √  null
ezworkflow_event data_text2 varchar 255  √  null
ezworkflow_event data_text3 varchar 255  √  null
ezworkflow_event data_text4 varchar 255  √  null
ezworkflow_event data_text5 longtext 2147483647  √  null
ezworkflow_event description varchar 50
ezworkflow_event id int 10  √ 
ezworkflow_event placement int 10 0
ezworkflow_event version int 10 0
ezworkflow_event workflow_id int 10 0
ezworkflow_event workflow_type_string varchar 50
ezworkflow_group created int 10 0
ezworkflow_group creator_id int 10 0
ezworkflow_group id int 10  √ 
ezworkflow_group modified int 10 0
ezworkflow_group modifier_id int 10 0
ezworkflow_group name varchar 255
ezworkflow_group_link group_id int 10 0
ezworkflow_group_link group_name varchar 255  √  null
ezworkflow_group_link workflow_id int 10 0
ezworkflow_group_link workflow_version int 10 0
ezworkflow_process activation_date int 10  √  null
ezworkflow_process content_id int 10 0
ezworkflow_process content_version int 10 0
ezworkflow_process created int 10 0
ezworkflow_process event_id int 10 0
ezworkflow_process event_position int 10 0
ezworkflow_process event_state int 10  √  null
ezworkflow_process event_status int 10 0
ezworkflow_process id int 10  √ 
ezworkflow_process last_event_id int 10 0
ezworkflow_process last_event_position int 10 0
ezworkflow_process last_event_status int 10 0
ezworkflow_process memento_key varchar 32  √  null
ezworkflow_process modified int 10 0
ezworkflow_process node_id int 10 0
ezworkflow_process parameters longtext 2147483647  √  null
ezworkflow_process process_key varchar 32
ezworkflow_process session_key varchar 32 0
ezworkflow_process status int 10  √  null
ezworkflow_process user_id int 10 0
ezworkflow_process workflow_id int 10 0