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 |
| ||||||
|
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 | 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 | 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 |