Tables (6.0.15)
Summary
The 150 tables of the Exponential 6.0.15 kernel schema, with their fields and indexes, as share/db_schema.dba defines them.
Tables
| Table | Fields | Indexes |
|---|---|---|
| exp_data_connection | created int(11), creator_id int(11), database_name varchar(255), description varchar(255), engine varchar(32), id auto_increment, identifier varchar(64), modified int(11), modifier_id int(11), name varchar(255), options longtext, port int(11), read_only int(11), secret varchar(128), server varchar(255), user_name varchar(255) | PRIMARY, exp_data_connection_identifier |
| exp_data_sync | class_name varchar(128), conflict_rule varchar(16), content_class varchar(128), created int(11), creator_id int(11), direction varchar(16), id auto_increment, interval_seconds int(11), key_columns varchar(255), last_run int(11), last_run_id int(11), map longtext, modified int(11), name varchar(255), next_run int(11), options longtext, run_mode varchar(16), state varchar(16), subtree_node_id int(11) | PRIMARY, exp_data_sync_mode |
| exp_data_sync_conflict | content_values longtext, detected int(11), id auto_increment, link_id int(11), object_id int(11), resolution varchar(16), resolved int(11), resolver_id int(11), row_key varchar(255), row_values longtext, state varchar(16), sync_id int(11) | PRIMARY, exp_data_sync_conflict_state |
| exp_data_sync_link | content_hash varchar(32), content_modified int(11), id auto_increment, object_id int(11), row_hash varchar(32), row_key varchar(255), row_modified int(11), sync_id int(11), synced int(11) | PRIMARY, exp_data_sync_link_key, exp_data_sync_link_object |
| exp_migration | caption_id varchar(150), checksum varchar(64), duration_ms int(11), engine varchar(30), environment varchar(50), file_path varchar(255), finished_at int(11), message varchar(1000), migration_id varchar(150), revision varchar(64), run_by varchar(150), run_id varchar(64), source varchar(100), stage varchar(20), started_at int(11), state varchar(20), version varchar(30) | PRIMARY, exp_migration_run_id |
| exp_migration_deploy | deploy_id varchar(64), finished_at int(11), in_sync int(11), message varchar(1000), mode varchar(20), next_stage int(11), run_by varchar(150), stages int(11), started_at int(11), state varchar(20) | PRIMARY, exp_migration_deploy_started |
| exp_migration_deploy_host | address varchar(255), applied int(11), caption varchar(150), deploy_id varchar(64), environment varchar(50), message varchar(1000), remote_id varchar(64), stage int(11), state varchar(20), transport varchar(20) | PRIMARY, exp_migration_deploy_host_remote |
| exp_migration_recording | environment varchar(50), event_count int(11), kind varchar(20), label varchar(255), message varchar(1000), recording_id varchar(64), started_at int(11), state varchar(20), stopped_at int(11), user_id int(11) | PRIMARY, exp_migration_recording_state |
| exp_migration_recording_event | actor_id int(11), audit_name varchar(100), event_id varchar(32), payload longtext, recorded_at int(11), recording_id varchar(64), step_mode varchar(20), step_type varchar(50), subject varchar(255) | PRIMARY |
| exp_migration_run | caption_post varchar(150), caption_pre varchar(150), commit_id varchar(64), environment varchar(50), finished_at int(11), log_file varchar(255), message varchar(1000), push_state varchar(20), run_by varchar(150), run_id varchar(64), started_at int(11), state varchar(20), tag_name varchar(150) | PRIMARY, exp_migration_run_started |
| exp_secret | ciphertext longtext, created int(11), creator_id int(11), description varchar(255), id auto_increment, key_id varchar(16), modified int(11), modifier_id int(11), name varchar(128), scope varchar(64) | PRIMARY, exp_secret_name, exp_secret_scope |
| exp_static_page | built_at int(11), hash varchar(64), node_id int(11), page_bytes int(11), path varchar(255), stale int(11), target varchar(50) | PRIMARY, exp_static_page_node |
| exp_static_run | added int(11), bytes int(11), changed int(11), commit_id varchar(64), files int(11), finished_at int(11), kind varchar(20), message varchar(1000), pages int(11), push_state varchar(20), removed int(11), run_by varchar(150), run_id varchar(64), started_at int(11), state varchar(20), tag_name varchar(150), target varchar(50) | PRIMARY, exp_static_run_target |
| exp_transfer_run | bytes bigint(20), created int(11), detail longtext, detail_url varchar(255), direction varchar(10), duration int(11), engine varchar(16), error varchar(255), file_ref varchar(255), finished int(11), format varchar(32), id auto_increment, job_ref varchar(64), kind varchar(20), modified int(11), rows_done int(11), rows_failed int(11), rows_total int(11), scope varchar(20), scope_ref varchar(255), siteaccess varchar(64), started int(11), state varchar(16), title varchar(255), tool varchar(64), tool_ref varchar(64), user_id int(11) | PRIMARY, exp_transfer_run_started, exp_transfer_run_tool, exp_transfer_run_toolref, exp_transfer_run_user |
| expapikey | created int(11), created_by int(11), expires int(11), id auto_increment, key_prefix varchar(40), last_ip varchar(64), last_used int(11), name varchar(255), revoked int(11), revoked_by int(11), salt varchar(64), scopes varchar(255), secret_hash varchar(128), user_id int(11) | PRIMARY, expapikey_prefix, expapikey_user |
| expaudit_cursor | byte_offset bigint(20), channel varchar(32), file_name varchar(64), last_hash varchar(80), last_seq int(11), updated_ms bigint(20) | PRIMARY |
| expaudit_event | channel varchar(32), depth int(4), domain_name varchar(16), engine varchar(16), file_name varchar(64), id char(26), imported int(4), ip varchar(64), job_id varchar(32), login varchar(150), module_view varchar(128), name varchar(128), object_id varchar(64), object_name varchar(255), object_type varchar(32), parent_id char(26), pseudonymised int(4), reason varchar(32), record longtext, request_id varchar(40), result varchar(8), run_id varchar(40), search_text longtext, seq int(11), session_h varchar(24), severity int(4), siteaccess varchar(64), target_id varchar(64), target_type varchar(32), time_ms bigint(20), ua varchar(128), user_id int(11), verb varchar(32) | PRIMARY, expaudit_event_domain, expaudit_event_file_seq, expaudit_event_ip, expaudit_event_job, expaudit_event_name, expaudit_event_object, expaudit_event_parent, expaudit_event_request, expaudit_event_result, expaudit_event_time, expaudit_event_user |
| expaudit_file | archive_path varchar(255), break_line int(11), channel varchar(32), file_name varchar(64), records int(11), state varchar(16), verified varchar(16), verified_ms bigint(20) | PRIMARY |
| expbookmark_folder | created int(11), id auto_increment, name varchar(255), parent_id int(11), priority int(11), user_id int(11) | PRIMARY, expbookmark_folder_user |
| expbookmark_view | bookmark_id int(11), created int(11), module_name varchar(100), module_uri longtext, user_id int(11), view_name varchar(100), view_parameters longtext | PRIMARY, expbookmark_view_module, expbookmark_view_user |
| exphelp_feedback | created int(11), help_id varchar(80), helpful int(11), id auto_increment, language varchar(20), object_id int(11), reason varchar(32) | PRIMARY, exphelp_feedback_object, exphelp_feedback_created |
| exphelp_help_id | help_id varchar(80), object_id int(11), released int(11) | PRIMARY, exphelp_help_id_object |
| expmail_category | created int(11), default_on int(11), description longtext, double_opt_in int(11), essential int(11), frequencies varchar(100), handler_class varchar(255), id auto_increment, identifier varchar(100), modified int(11), name varchar(255), priority int(11) | PRIMARY, expmail_category_identifier |
| expmail_consent_log | action varchar(30), actor_user_id int(11), anonymised int(11), category varchar(100), created int(11), email varchar(255), id auto_increment, ip varchar(64), new_value varchar(100), old_value varchar(100), recipient_key varchar(80), siteaccess varchar(100), source varchar(20), user_id int(11), wording longtext | PRIMARY, expmail_consent_log_created, expmail_consent_log_recipient, expmail_consent_log_user |
| expmail_pending | category varchar(100), created int(11), data longtext, expires int(11), id auto_increment, kind varchar(20), recipient_key varchar(80), user_id int(11) | PRIMARY, expmail_pending_expires, expmail_pending_recipient |
| expmail_preference | category varchar(100), created int(11), frequency varchar(20), id auto_increment, modified int(11), recipient_key varchar(80), state varchar(20), user_id int(11) | PRIMARY, expmail_preference_category, expmail_preference_recipient, expmail_preference_user |
| expmail_suppression | created int(11), created_by int(11), email_hash varchar(64), id auto_increment, note longtext, reason varchar(30) | PRIMARY, expmail_suppression_hash |
| exppasskey | aaguid varchar(36), algorithm int(11), backup_eligible int(11), backup_state int(11), created int(11), credential_hash varchar(64), credential_id longtext, id auto_increment, last_ip varchar(64), last_used int(11), name varchar(255), public_key longtext, sign_count bigint(20), transports varchar(255), user_handle varchar(128), user_id int(11) | PRIMARY, exppasskey_credential, exppasskey_user |
| expuser_audit | actor_id int(11), actor_login varchar(150), client_ip varchar(64), created int(11), event_id varchar(26), event_name varchar(128), host varchar(255), id auto_increment, module_view varchar(128), reason varchar(64), request_id varchar(40), result varchar(16), siteaccess varchar(64), target_id int(11), target_login varchar(150), target_type varchar(16), time_ms bigint(20), value_after longtext, value_before longtext | PRIMARY, expuser_audit_event, expuser_audit_target, expuser_audit_actor, expuser_audit_name, expuser_audit_created |
| expuser_session | browser varchar(64), created int(11), device_type varchar(16), end_reason varchar(32), ended int(11), ended_by int(11), first_ip varchar(64), id auto_increment, last_active int(11), last_ip varchar(64), method varchar(32), os varchar(64), remember_until int(11), siteaccess varchar(64), token_hash varchar(64), user_agent varchar(512), user_id int(11) | PRIMARY, expuser_session_token, expuser_session_user, expuser_session_active |
| expuser_session_info | auth_detail varchar(32), country varchar(2), host varchar(255), location varchar(128), session_id int(11), user_id int(11) | PRIMARY, expuser_session_info_user |
| ezapprove_items | collaboration_id int(11), id auto_increment, workflow_process_id int(11) | PRIMARY |
| ezbasket | id auto_increment, order_id int(11), productcollection_id int(11), session_id varchar(255) | PRIMARY, ezbasket_session_id |
| ezbinaryfile | contentobject_attribute_id int(11), download_count int(11), filename varchar(255), mime_type varchar(255), original_filename varchar(255), version int(11) | PRIMARY |
| ezcobj_state | default_language_id bigint(20), group_id int(11), id auto_increment, identifier varchar(45), language_mask bigint(20), priority int(11) | PRIMARY, ezcobj_state_identifier, ezcobj_state_lmask, ezcobj_state_priority |
| ezcobj_state_group | default_language_id bigint(20), id auto_increment, identifier varchar(45), language_mask bigint(20) | PRIMARY, ezcobj_state_group_identifier, ezcobj_state_group_lmask |
| ezcobj_state_group_language | contentobject_state_group_id int(11), description longtext, language_id bigint(20), name varchar(45), real_language_id bigint(20) | PRIMARY |
| ezcobj_state_language | contentobject_state_id int(11), description longtext, language_id bigint(20), name varchar(45) | PRIMARY |
| ezcobj_state_link | contentobject_id int(11), contentobject_state_id int(11) | PRIMARY |
| ezcollab_group | created int(11), depth int(11), id auto_increment, is_open int(11), modified int(11), parent_group_id int(11), path_string varchar(255), priority int(11), title varchar(255), user_id int(11) | PRIMARY, ezcollab_group_depth, ezcollab_group_path |
| ezcollab_item | created int(11), creator_id int(11), data_float1 float, data_float2 float, data_float3 float, data_int1 int(11), data_int2 int(11), data_int3 int(11), data_text1 longtext, data_text2 longtext, data_text3 longtext, id auto_increment, modified int(11), status int(11), type_identifier varchar(40) | PRIMARY |
| ezcollab_item_group_link | collaboration_id int(11), created int(11), group_id int(11), is_active int(11), is_read int(11), last_read int(11), modified int(11), user_id int(11) | PRIMARY |
| ezcollab_item_message_link | collaboration_id int(11), created int(11), id auto_increment, message_id int(11), message_type int(11), modified int(11), participant_id int(11) | PRIMARY |
| ezcollab_item_participant_link | collaboration_id int(11), created int(11), is_active int(11), is_read int(11), last_read int(11), modified int(11), participant_id int(11), participant_role int(11), participant_type int(11) | PRIMARY |
| ezcollab_item_status | collaboration_id int(11), is_active int(11), is_read int(11), last_read int(11), user_id int(11) | PRIMARY |
| ezcollab_notification_rule | collab_identifier varchar(255), id auto_increment, user_id varchar(255) | PRIMARY |
| ezcollab_profile | created int(11), data_text1 longtext, id auto_increment, main_group int(11), modified int(11), user_id int(11) | PRIMARY |
| ezcollab_simple_message | created int(11), creator_id int(11), data_float1 float, data_float2 float, data_float3 float, data_int1 int(11), data_int2 int(11), data_int3 int(11), data_text1 longtext, data_text2 longtext, data_text3 longtext, id auto_increment, message_type varchar(40), modified int(11) | PRIMARY |
| ezcontent_language | disabled int(11), id bigint(20), locale varchar(20), name varchar(255) | PRIMARY, ezcontent_language_name |
| ezcontentbrowsebookmark | id auto_increment, name varchar(255), node_id int(11), user_id int(11), folder_id int(11), priority int(11) | PRIMARY, ezcontentbrowsebookmark_folder, ezcontentbrowsebookmark_user |
| ezcontentbrowserecent | created int(11), id auto_increment, name varchar(255), node_id int(11), user_id int(11) | PRIMARY, ezcontentbrowserecent_user |
| ezcontentclass | always_available int(11), contentobject_name varchar(255), created int(11), creator_id int(11), id auto_increment, identifier varchar(50), initial_language_id bigint(20), is_container int(11), language_mask bigint(20), modified int(11), modifier_id int(11), remote_id varchar(100), serialized_description_list longtext, serialized_name_list longtext, sort_field int(11), sort_order int(11), url_alias_name varchar(255), version int(11) | PRIMARY, ezcontentclass_version, ezcontentclass_identifier |
| ezcontentclass_attribute | can_translate int(11), category varchar(25), contentclass_id int(11), data_float1 double, data_float2 double, data_float3 double, data_float4 double, data_int1 int(11), data_int2 int(11), data_int3 int(11), data_int4 int(11), data_text1 varchar(50), data_text2 varchar(50), data_text3 varchar(50), data_text4 varchar(255), data_text5 longtext, data_type_string varchar(50), id auto_increment, identifier varchar(50), is_information_collector int(11), is_required int(11), is_searchable int(11), placement int(11), serialized_data_text longtext, serialized_description_list longtext, serialized_name_list longtext, version int(11) | PRIMARY, ezcontentclass_attr_ccid |
| ezcontentclass_classgroup | contentclass_id int(11), contentclass_version int(11), group_id int(11), group_name varchar(255) | PRIMARY |
| ezcontentclass_name | contentclass_id int(11), contentclass_version int(11), language_id bigint(20), language_locale varchar(20), name varchar(255) | PRIMARY |
| ezcontentclassgroup | created int(11), creator_id int(11), id auto_increment, modified int(11), modifier_id int(11), name varchar(255) | PRIMARY |
| ezcontentobject | contentclass_id int(11), current_version int(11), id auto_increment, initial_language_id bigint(20), language_mask bigint(20), modified int(11), name varchar(255), owner_id int(11), published int(11), remote_id varchar(100), section_id int(11), status int(11) | PRIMARY, ezcontentobject_classid, ezcontentobject_currentversion, ezcontentobject_lmask, ezcontentobject_modified, ezcontentobject_owner, ezcontentobject_pub, ezcontentobject_remote_id, ezcontentobject_status |
| ezcontentobject_attribute | attribute_original_id int(11), contentclassattribute_id int(11), contentobject_id int(11), data_float double, data_int int(11), data_text longtext, data_type_string varchar(50), id auto_increment, language_code varchar(20), language_id bigint(20), sort_key_int int(11), sort_key_string varchar(255), version int(11) | PRIMARY, ezcontentobject_attribute_co_id_ver_lang_code, ezcontentobject_attribute_language_code, ezcontentobject_classattr_id, sort_key_int, sort_key_string |
| ezcontentobject_link | contentclassattribute_id int(11), from_contentobject_id int(11), from_contentobject_version int(11), id auto_increment, relation_type int(11), to_contentobject_id int(11) | PRIMARY, ezco_link_from, ezco_link_to_co_id |
| ezcontentobject_name | content_translation varchar(20), content_version int(11), contentobject_id int(11), language_id bigint(20), name varchar(255), real_translation varchar(20) | PRIMARY, ezcontentobject_name_cov_id, ezcontentobject_name_lang_id, ezcontentobject_name_name |
| ezcontentobject_trash | contentobject_id int(11), contentobject_version int(11), depth int(11), is_hidden int(11), is_invisible int(11), main_node_id int(11), modified_subnode int(11), node_id int(11), parent_node_id int(11), path_identification_string longtext, path_string varchar(255), priority int(11), remote_id varchar(100), sort_field int(11), sort_order int(11), trashed int(11), trashed_by int(11), trashed_via varchar(100) | PRIMARY, ezcobj_trash_co_id, ezcobj_trash_depth, ezcobj_trash_modified_subnode, ezcobj_trash_p_node_id, ezcobj_trash_path, ezcobj_trash_path_ident, ezcobj_trash_trashed_by |
| ezcontentobject_tree | contentobject_id int(11), contentobject_is_published int(11), contentobject_version int(11), depth int(11), is_hidden int(11), is_invisible int(11), main_node_id int(11), modified_subnode int(11), node_id auto_increment, parent_node_id int(11), path_identification_string longtext, path_string varchar(255), priority int(11), remote_id varchar(100), sort_field int(11), sort_order int(11) | PRIMARY, ezcontentobject_tree_remote_id, ezcontentobject_tree_co_id, ezcontentobject_tree_depth, ezcontentobject_tree_p_node_id, ezcontentobject_tree_path, ezcontentobject_tree_path_ident, modified_subnode |
| ezcontentobject_version | contentobject_id int(11), created int(11), creator_id int(11), id auto_increment, initial_language_id bigint(20), language_mask bigint(20), modified int(11), status int(11), user_id int(11), version int(11), workflow_event_pos int(11) | PRIMARY, ezcobj_version_creator_id, ezcobj_version_status, idx_object_version_objver, ezcontobj_version_obj_status |
| ezcurrencydata | auto_rate_value decimal(10,5), code varchar(4), custom_rate_value decimal(10,5), id auto_increment, locale varchar(255), rate_factor decimal(10,5), status int(11), symbol varchar(255) | PRIMARY, ezcurrencydata_code |
| ezdiscountrule | id auto_increment, name varchar(255) | PRIMARY |
| ezdiscountsubrule | discount_percent float, discountrule_id int(11), id auto_increment, limitation char(1), name varchar(255) | PRIMARY |
| ezdiscountsubrule_value | discountsubrule_id int(11), issection int(11), value int(11) | PRIMARY |
| ezenumobjectvalue | contentobject_attribute_id int(11), contentobject_attribute_version int(11), enumelement varchar(255), enumid int(11), enumvalue varchar(255) | PRIMARY |
| ezenumvalue | contentclass_attribute_id int(11), contentclass_attribute_version int(11), enumelement varchar(255), enumvalue varchar(255), id auto_increment, placement int(11) | PRIMARY, ezenumvalue_co_cl_attr_id_co_class_att_ver |
| ezforgot_password | hash_key varchar(32), id auto_increment, time int(11), user_id int(11) | PRIMARY, ezforgot_password_user |
| ezgeneral_digest_user_settings | day varchar(255), digest_type int(11), id auto_increment, receive_digest int(11), time varchar(255), user_id int(11) | PRIMARY, ezgeneral_digest_user_id |
| ezimagefile | contentobject_attribute_id int(11), filepath longtext, id auto_increment | PRIMARY, ezimagefile_coid, ezimagefile_file |
| ezinfocollection | contentobject_id int(11), created int(11), creator_id int(11), id auto_increment, modified int(11), user_identifier varchar(34) | PRIMARY, ezinfocollection_co_id_created |
| ezinfocollection_attribute | contentclass_attribute_id int(11), contentobject_attribute_id int(11), contentobject_id int(11), data_float float, data_int int(11), data_text longtext, id auto_increment, informationcollection_id int(11) | PRIMARY, ezinfocollection_attr_cca_id, ezinfocollection_attr_co_id, ezinfocollection_attr_coa_id, ezinfocollection_attr_ic_id |
| ezisbn_group | description varchar(255), group_number int(11), id auto_increment | PRIMARY |
| ezisbn_group_range | from_number int(11), group_from varchar(32), group_length int(11), group_to varchar(32), id auto_increment, to_number int(11) | PRIMARY |
| ezisbn_registrant_range | from_number int(11), id auto_increment, isbn_group_id int(11), registrant_from varchar(32), registrant_length int(11), registrant_to varchar(32), to_number int(11) | PRIMARY |
| ezkeyword | class_id int(11), id auto_increment, keyword varchar(255) | PRIMARY, ezkeyword_keyword |
| ezkeyword_attribute_link | id auto_increment, keyword_id int(11), objectattribute_id int(11) | PRIMARY, ezkeyword_attr_link_kid_oaid, ezkeyword_attr_link_oaid |
| ezmedia | contentobject_attribute_id int(11), controls varchar(50), filename varchar(255), has_controller int(11), height int(11), is_autoplay int(11), is_loop int(11), mime_type varchar(50), original_filename varchar(255), pluginspage varchar(255), quality varchar(50), version int(11), width int(11) | PRIMARY |
| ezmessage | body longtext, destination_address varchar(50), id auto_increment, is_sent int(11), send_method varchar(50), send_time varchar(50), send_weekday varchar(50), title varchar(255) | PRIMARY |
| ezmodule_run | function_name varchar(255), id auto_increment, module_data longtext, module_name varchar(255), workflow_process_id int(11) | PRIMARY, ezmodule_run_workflow_process_id_s |
| ezmultipricedata | contentobject_attr_id int(11), contentobject_attr_version int(11), currency_code varchar(4), id auto_increment, type int(11), value decimal(15,2) | PRIMARY, ezmultipricedata_coa_id, ezmultipricedata_coa_version, ezmultipricedata_currency_code |
| eznode_assignment | contentobject_id int(11), contentobject_version int(11), from_node_id int(11), id auto_increment, is_main int(11), op_code int(11), parent_node int(11), parent_remote_id varchar(100), remote_id varchar(100), sort_field int(11), sort_order int(11), priority int(11), is_hidden int(11) | PRIMARY, eznode_assignment_co_version, eznode_assignment_coid_cov, eznode_assignment_is_main, eznode_assignment_parent_node |
| eznotificationcollection | data_subject longtext, data_text longtext, event_id int(11), handler varchar(255), id auto_increment, transport varchar(255) | PRIMARY |
| eznotificationcollection_item | address varchar(255), collection_id int(11), event_id int(11), id auto_increment, send_date int(11) | PRIMARY |
| eznotificationevent | data_int1 int(11), data_int2 int(11), data_int3 int(11), data_int4 int(11), data_text1 longtext, data_text2 longtext, data_text3 longtext, data_text4 longtext, event_type_string varchar(255), id auto_increment, status int(11) | PRIMARY |
| ezoperation_memento | id auto_increment, main int(11), main_key varchar(32), memento_data longtext, memento_key varchar(32) | PRIMARY, ezoperation_memento_memento_key_main |
| ezorder | account_identifier varchar(100), created int(11), data_text_1 longtext, data_text_2 longtext, email varchar(150), id auto_increment, ignore_vat int(11), is_archived int(11), is_temporary int(11), order_nr int(11), productcollection_id int(11), siteaccess varchar(255), status_id int(11), status_modified int(11), status_modifier_id int(11), user_id int(11) | PRIMARY, ezorder_is_archived, ezorder_is_tmp |
| ezorder_item | description varchar(255), id auto_increment, is_vat_inc int(11), order_id int(11), price float, type varchar(30), vat_value float | PRIMARY, ezorder_item_order_id, ezorder_item_type |
| ezorder_nr_incr | id auto_increment | PRIMARY |
| ezorder_status | id auto_increment, is_active int(11), name varchar(255), status_id int(11) | PRIMARY, ezorder_status_active, ezorder_status_name, ezorder_status_sid |
| ezorder_status_history | id auto_increment, modified int(11), modifier_id int(11), order_id int(11), status_id int(11) | PRIMARY, ezorder_status_history_mod, ezorder_status_history_oid, ezorder_status_history_sid |
| ezpackage | id auto_increment, install_date int(11), name varchar(100), version varchar(30) | PRIMARY |
| ezpaymentobject | id auto_increment, order_id int(11), payment_string varchar(255), status int(11), workflowprocess_id int(11) | PRIMARY |
| ezpdf_export | footer_text varchar(255), show_footer int(11), created int(11), creator_id int(11), export_classes varchar(255), export_structure varchar(255), id auto_increment, intro_text longtext, modified int(11), modifier_id int(11), pdf_filename varchar(255), show_frontpage int(11), site_access varchar(255), source_node_id int(11), status int(11), sub_text longtext, title varchar(255), version int(11) | PRIMARY |
| ezpending_actions | id auto_increment, action varchar(64), created int(11), param longtext | PRIMARY, ezpending_actions_action, ezpending_actions_created |
| ezpolicy | function_name varchar(255), id auto_increment, module_name varchar(255), original_id int(11), role_id int(11) | PRIMARY, ezpolicy_original_id, ezpolicy_role_id |
| ezpolicy_limitation | id auto_increment, identifier varchar(255), policy_id int(11) | PRIMARY, policy_id |
| ezpolicy_limitation_value | id auto_increment, limitation_id int(11), value varchar(255) | PRIMARY, ezpolicy_limitation_value_val, ezpolicy_limit_value_limit_id |
| ezpreferences | id auto_increment, name varchar(100), user_id int(11), value longtext | PRIMARY, ezpreferences_name, ezpreferences_user_id_idx |
| ezprest_authcode | client_id varchar(200), code_challenge varchar(128), code_challenge_method varchar(10), expirytime bigint(20), id varchar(200), scope varchar(200), user_id int(11) | PRIMARY, authcode_client_id |
| ezprest_authorized_clients | created int(11), id auto_increment, rest_client_id int(11), user_id int(11) | PRIMARY, client_user |
| ezprest_clients | client_id varchar(200), client_secret varchar(200), created int(11), description longtext, endpoint_uri varchar(200), id auto_increment, name varchar(100), owner_id int(11), updated int(11), version int(1) | PRIMARY, client_id_unique |
| ezprest_token | client_id varchar(200), expirytime bigint(20), id varchar(200), refresh_token varchar(200), scope varchar(200), user_id int(11) | PRIMARY, token_client_id |
| ezproductcategory | id auto_increment, name varchar(255) | PRIMARY |
| ezproductcollection | created int(11), currency_code varchar(4), id auto_increment | PRIMARY |
| ezproductcollection_item | contentobject_id int(11), discount float, id auto_increment, is_vat_inc int(11), item_count int(11), name varchar(255), price float, productcollection_id int(11), vat_value float | PRIMARY, ezproductcollection_item_contentobject_id, ezproductcollection_item_productcollection_id |
| ezproductcollection_item_opt | id auto_increment, item_id int(11), name varchar(255), object_attribute_id int(11), option_item_id int(11), price float, value varchar(255) | PRIMARY, ezproductcollection_item_opt_item_id |
| ezpublishingqueueprocesses | created int(11), ezcontentobject_version_id int(11), finished int(11), pid int(8), started int(11), status int(2) | PRIMARY |
| ezrole | id auto_increment, is_new int(11), name varchar(255), value char(1), version int(11) | PRIMARY |
| ezrss_export | access_url varchar(255), opml_head longtext, podcast_head longtext, active int(11), created int(11), creator_id int(11), description longtext, id auto_increment, image_id int(11), main_node_only int(11), modified int(11), modifier_id int(11), node_id int(11), number_of_objects int(11), rss_version varchar(255), site_access varchar(255), status int(11), title varchar(255), url varchar(255) | PRIMARY |
| ezrss_export_item | category varchar(255), class_id int(11), description varchar(255), enclosure varchar(255), id auto_increment, rssexport_id int(11), source_node_id int(11), status int(11), subnodes int(11), title varchar(255) | PRIMARY, ezrss_export_rsseid |
| ezrss_export_opml_item | category varchar(255), created int(11), description varchar(255), html_url varchar(255), id auto_increment, is_breakpoint int(11), is_comment int(11), language varchar(50), outline_text varchar(255), outline_type varchar(50), parent_id int(11), priority int(11), rssexport_id int(11), source_node_id int(11), status int(11), subnodes int(11), target_export_id int(11), title varchar(255), url varchar(255), xml_url varchar(255) | PRIMARY, ezrss_export_opml_rsseid |
| ezrss_import | active int(11), class_description varchar(255), class_id int(11), class_title varchar(255), class_url varchar(255), created int(11), creator_id int(11), destination_node_id int(11), id auto_increment, import_description longtext, modified int(11), modifier_id int(11), name varchar(255), object_owner_id int(11), status int(11), url longtext | PRIMARY |
| ezscheduled_script | command varchar(255), id auto_increment, last_report_timestamp int(11), name varchar(50), process_id int(11), progress int(3), user_id int(11) | PRIMARY, ezscheduled_script_timestamp |
| ezsearch_object_word_link | contentclass_attribute_id int(11), contentclass_id int(11), contentobject_id int(11), frequency float, id auto_increment, identifier varchar(255), integer_value int(11), next_word_id int(11), placement int(11), prev_word_id int(11), published int(11), section_id int(11), word_id int(11) | PRIMARY, ezsearch_object_word_link_frequency, ezsearch_object_word_link_identifier, ezsearch_object_word_link_integer_value, ezsearch_object_word_link_object, ezsearch_object_word_link_word |
| ezsearch_search_phrase | id auto_increment, phrase varchar(250), phrase_count int(11), result_count int(11) | PRIMARY, ezsearch_search_phrase_count, ezsearch_search_phrase_phrase |
| ezsearch_word | id auto_increment, object_count int(11), word varchar(150) | PRIMARY, ezsearch_word_obj_count, ezsearch_word_word_i |
| ezsection | id auto_increment, identifier varchar(255), locale varchar(255), name varchar(255), navigation_part_identifier varchar(100) | PRIMARY |
| ezsession | data longtext, expiration_time int(11), session_key varchar(32), user_hash varchar(32), user_id int(11) | PRIMARY, expiration_time, ezsession_user_id |
| ezsite_data | name varchar(60), value longtext | PRIMARY |
| ezsubtree_notification_rule | id auto_increment, node_id int(11), use_digest int(11), user_id int(11) | PRIMARY, ezsubtree_notification_rule_user_id |
| eztipafriend_counter | count int(11), node_id int(11), requested int(11) | PRIMARY |
| eztipafriend_request | created int(11), email_receiver varchar(100) | eztipafriend_request_created, eztipafriend_request_email_rec |
| eztrigger | connect_type char(1), function_name varchar(200), id auto_increment, module_name varchar(200), name varchar(255), workflow_id int(11) | PRIMARY, eztrigger_def_id, eztrigger_fetch |
| ezurl | created int(11), id auto_increment, is_valid int(11), last_checked int(11), modified int(11), original_url_md5 varchar(32), url longtext | PRIMARY, ezurl_url |
| ezurl_object_link | contentobject_attribute_id int(11), contentobject_attribute_version int(11), url_id int(11) | ezurl_ol_coa_id, ezurl_ol_coa_version, ezurl_ol_url_id |
| ezurlalias | destination_url longtext, forward_to_id int(11), id auto_increment, is_imported int(11), is_internal int(11), is_wildcard int(11), source_md5 varchar(32), source_url longtext | PRIMARY, ezurlalias_desturl, ezurlalias_forward_to_id, ezurlalias_imp_wcard_fwd, ezurlalias_source_md5, ezurlalias_source_url, ezurlalias_wcard_fwd |
| ezurlalias_ml | action longtext, action_type varchar(32), alias_redirects int(11), id int(11), is_alias int(11), is_original int(11), lang_mask bigint(20), link int(11), parent int(11), text longtext, text_md5 varchar(32) | PRIMARY, ezurlalias_ml_act_org, ezurlalias_ml_actt_org_al, ezurlalias_ml_id, ezurlalias_ml_par_act_id_lnk, ezurlalias_ml_par_lnk_txt, ezurlalias_ml_text, ezurlalias_ml_text_lang |
| ezurlalias_ml_incr | id auto_increment | PRIMARY |
| ezurlwildcard | destination_url longtext, id auto_increment, source_url longtext, type int(11) | PRIMARY |
| ezuser | contentobject_id int(11), email varchar(150), login varchar(150), password_hash varchar(255), password_hash_type int(11) | PRIMARY, ezuser_login |
| ezuser_accountkey | hash_key varchar(32), id auto_increment, time int(11), user_id int(11) | PRIMARY, hash_key |
| ezuser_discountrule | contentobject_id int(11), discountrule_id int(11), id auto_increment, name varchar(255) | PRIMARY |
| ezuser_role | contentobject_id int(11), id auto_increment, limit_identifier varchar(255), limit_value varchar(255), role_id int(11) | PRIMARY, ezuser_role_contentobject_id, ezuser_role_role_id |
| ezuser_setting | is_enabled int(11), max_login int(11), user_id int(11) | PRIMARY |
| ezuservisit | current_visit_timestamp int(11), failed_login_attempts int(11), last_visit_timestamp int(11), login_count int(11), user_id int(11) | PRIMARY, ezuservisit_co_visit_count |
| ezvatrule | country_code varchar(255), id auto_increment, vat_type int(11) | PRIMARY |
| ezvatrule_product_category | product_category_id int(11), vatrule_id int(11) | PRIMARY |
| ezvattype | id auto_increment, name varchar(255), percentage float | PRIMARY |
| ezview_counter | count int(11), node_id int(11) | PRIMARY |
| ezwaituntildatevalue | contentclass_attribute_id int(11), contentclass_id int(11), id auto_increment, workflow_event_id int(11), workflow_event_version int(11) | PRIMARY, ezwaituntildateevalue_wf_ev_id_wf_ver |
| ezwishlist | id auto_increment, productcollection_id int(11), user_id int(11) | PRIMARY |
| ezworkflow | created int(11), creator_id int(11), id auto_increment, is_enabled int(11), modified int(11), modifier_id int(11), name varchar(255), version int(11), workflow_type_string varchar(50) | PRIMARY |
| ezworkflow_assign | access_type int(11), as_tree int(11), id auto_increment, node_id int(11), workflow_id int(11) | PRIMARY |
| ezworkflow_event | data_int1 int(11), data_int2 int(11), data_int3 int(11), data_int4 int(11), data_text1 varchar(255), data_text2 varchar(255), data_text3 varchar(255), data_text4 varchar(255), data_text5 longtext, description varchar(50), id auto_increment, placement int(11), version int(11), workflow_id int(11), workflow_type_string varchar(50) | PRIMARY, wid_version_placement |
| ezworkflow_group | created int(11), creator_id int(11), id auto_increment, modified int(11), modifier_id int(11), name varchar(255) | PRIMARY |
| ezworkflow_group_link | group_id int(11), group_name varchar(255), workflow_id int(11), workflow_version int(11) | PRIMARY |
| ezworkflow_process | activation_date int(11), content_id int(11), content_version int(11), created int(11), event_id int(11), event_position int(11), event_state int(11), event_status int(11), id auto_increment, last_event_id int(11), last_event_position int(11), last_event_status int(11), memento_key varchar(32), modified int(11), node_id int(11), parameters longtext, process_key varchar(32), session_key varchar(32), status int(11), user_id int(11), workflow_id int(11) | PRIMARY, ezworkflow_process_process_key |
Added to the reference for Exponential 6.0.15.
Contributors
- Graham Brookins Updated
Comments
Add a comment