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