master_kaltura contains 606 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
admin_kuser	created_at	datetime	0	√		null
admin_kuser	email	varchar	50	√		null
admin_kuser	full_name	varchar	40	√		null
admin_kuser	icon	tinyint	3	√		null
admin_kuser	id	int	10		√		admin_permission.admin_kuser_id Defined in XML
admin_kuser	partner_id	int	10	√		null		partner.id Defined in XML
admin_kuser	picture	varchar	48	√		null
admin_kuser	salt	varchar	32	√		null
admin_kuser	screen_name	varchar	20	√		null
admin_kuser	sha1_password	varchar	40	√		null
admin_kuser	updated_at	datetime	0	√		null
admin_permission	admin_kuser_id	int	10	√		null		admin_kuser.id Defined in XML
admin_permission	groups	varchar	512	√		null
admin_permission	id	int	10		√
alert	alert_type	int	10	√		null
alert	id	int	10		√
alert	kuser_id	int	10	√		null		kuser.id Defined in XML
alert	rule_type	int	10	√		null
alert	subject_id	int	10	√		null
batch_job	abort	tinyint	3	√		null
batch_job	check_again_timeout	int	10	√		null
batch_job	created_at	datetime	0	√		null
batch_job	data	varchar	4096	√		null
batch_job	description	varchar	1024	√		null
batch_job	entry_id	varchar	10	√
batch_job	execution_attempts	tinyint	3	√		null
batch_job	id	int	10		√		batch_job.parent_job_id Defined in XML
batch_job	job_sub_type	smallint	5	√		null
batch_job	job_type	smallint	5	√		null
batch_job	lock_version	int	10	√		null
batch_job	message	varchar	1024	√		null
batch_job	parent_job_id	int	10	√		null		batch_job.id Defined in XML
batch_job	partner_id	int	10	√		null		partner.id Defined in XML
batch_job	processor_expiration	datetime	0	√		null
batch_job	processor_location	varchar	64	√		null
batch_job	processor_name	varchar	64	√		null
batch_job	progress	tinyint	3	√		null
batch_job	status	int	10	√		null
batch_job	subp_id	int	10	√		null
batch_job	updated_at	datetime	0	√		null
batch_job	updates_count	smallint	5	√		null
bb_forum	created_at	datetime	0	√		null
bb_forum	description	text	65535	√		null
bb_forum	id	int	10		√
bb_forum	is_live	int	10	√		1
bb_forum	last_post	int	10	√		null
bb_forum	name	varchar	255	√		null
bb_forum	post_count	int	10	√		0
bb_forum	thread_count	int	10	√		0
bb_forum	updated_at	datetime	0	√		null
bb_post	content	text	65535	√		null
bb_post	created_at	datetime	0	√		null
bb_post	forum_id	int	10	√		null
bb_post	id	int	10		√		bb_post.parent_id Defined in XML
bb_post	kuser_id	int	10	√		null		kuser.id Defined in XML
bb_post	last_child	int	10	√		null
bb_post	node_id	varchar	64	√		null
bb_post	node_level	int	10	√		null
bb_post	num_childern	int	10	√		0
bb_post	parent_id	int	10	√		null		bb_post.id Defined in XML
bb_post	title	varchar	255	√		null
bb_post	updated_at	datetime	0	√		null
blocked_email	email	varchar	40
collect_stats	command	varchar	10	√		null
collect_stats	date	datetime	0	√		null
collect_stats	entry_id	varchar	10	√		null		entry.id Defined in XML
collect_stats	ip	int	10	√		null
collect_stats	partner_id	int	10	√		null		partner.id Defined in XML
collect_stats	uv_id	varchar	32	√		null
collect_stats	widget_id	varchar	32	√		null		widget.id Defined in XML
comment	base_date	date	0	√		null
comment	comment	varchar	256	√		null
comment	comment_type	int	10	√		null
comment	created_at	datetime	0	√		null
comment	id	int	10		√
comment	kuser_id	int	10	√		null		kuser.id Defined in XML
comment	reply_to	int	10	√		null
comment	subject_id	int	10	√		null
conversion	conversion_params	varchar	512	√		null
conversion	conversion_time	int	10	√		null
conversion	created_at	datetime	0	√		null
conversion	entry_id	varchar	10	√		null		entry.id Defined in XML
conversion	id	int	10		√
conversion	in_file_ext	varchar	16	√		null
conversion	in_file_name	varchar	128	√		null
conversion	in_file_size	int	10	√		null
conversion	out_file_name	varchar	128	√		null
conversion	out_file_name_2	varchar	128	√		null
conversion	out_file_size	int	10	√		null
conversion	out_file_size_2	int	10	√		null
conversion	source	int	10	√		null
conversion	status	int	10	√		null
conversion	total_process_time	int	10	√		null
conversion	updated_at	datetime	0	√		null
conversion_params	aspect_ratio	varchar	6	√		null
conversion_params	bitrate	int	10	√		null
conversion_params	created_at	datetime	0	√		null
conversion_params	custom_data	varchar	4096	√		null
conversion_params	enabled	tinyint	3	√		1
conversion_params	file_suffix	varchar	64	√		null
conversion_params	gop_size	int	10	√		null
conversion_params	height	int	10	√		null
conversion_params	id	int	10		√
conversion_params	name	varchar	128	√		null
conversion_params	partner_id	int	10	√		null		partner.id Defined in XML
conversion_params	profile_type	varchar	128	√		null
conversion_params	profile_type_index	int	10	√		null
conversion_params	qscale	int	10	√		null
conversion_params	updated_at	datetime	0	√		null
conversion_params	width	int	10	√		null
conversion_profile	aspect_ratio	varchar	6	√		null
conversion_profile	bypass_flv	tinyint	3	√		null
conversion_profile	commercial_transcoder	tinyint	3	√		null
conversion_profile	created_at	datetime	0	√		null
conversion_profile	enabled	tinyint	3	√		1
conversion_profile	height	int	10	√		null
conversion_profile	id	int	10		√
conversion_profile	name	varchar	128	√		null
conversion_profile	partner_id	int	10	√		0		partner.id Defined in XML
conversion_profile	profile_type	varchar	128	√		null
conversion_profile	profile_type_suffix	varchar	32	√		null
conversion_profile	updated_at	datetime	0	√		null
conversion_profile	use_with_bulk	tinyint	3	√		null
conversion_profile	width	int	10	√		null
email_campaign	campaign_mgr_kuser_id	int	10	√		null
email_campaign	click_count	int	10	√		null
email_campaign	created_at	datetime	0	√		null
email_campaign	criteria_id	smallint	5	√		null
email_campaign	criteria_params	varchar	1024	√		null
email_campaign	criteria_str	varchar	1024	√		null
email_campaign	id	int	10		√
email_campaign	open_count	int	10	√		null
email_campaign	send_count	int	10	√		null
email_campaign	status	int	10	√		null
email_campaign	template_path	varchar	256	√		null
email_campaign	updated_at	datetime	0	√		null
entry	admin_tags	text	65535	√		null
entry	anonymous	tinyint	3	√		null
entry	comments	int	10	√		0
entry	created_at	datetime	0	√		null
entry	credit	varchar	1024	√		null
entry	custom_data	text	65535	√		null
entry	data	varchar	48	√		null
entry	description	text	65535	√		null
entry	display_in_search	tinyint	3	√		1
entry	favorites	int	10	√		0
entry	group_id	varchar	64	√		null
entry	id	varchar	10				collect_stats.entry_id Defined in XML conversion.entry_id Defined in XML kshow.show_entry_id Defined in XML kvote.entry_id Defined in XML kwidget_log.entry_id Defined in XML moderation_flag.flagged_entry_id Defined in XML roughcut_entry.entry_id Defined in XML ui_conf.partner_id Defined in XML widget.entry_id Defined in XML
entry	indexed_custom_data_1	int	10	√		null
entry	int_id	int	10		√
entry	kshow_id	varchar	10	√		null		kshow.id Defined in XML
entry	kuser_id	int	10	√		null		kuser.id Defined in XML
entry	length_in_msecs	int	10	√		0
entry	license_type	smallint	5	√		null
entry	media_date	datetime	0	√		null
entry	media_type	smallint	5	√		null
entry	moderation_count	int	10	√		0
entry	moderation_status	int	10	√		2
entry	modified_at	datetime	0	√		null
entry	name	varchar	60	√		null
entry	partner_data	varchar	4096	√		null
entry	partner_id	int	10	√		0		partner.id Defined in XML
entry	permissions	int	10	√		null
entry	plays	int	10	√		0
entry	puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
entry	rank	int	10	√		0
entry	screen_name	varchar	20	√		null
entry	search_text	varchar	4096	√		null
entry	site_url	varchar	256	√		null
entry	source	smallint	5	√		null
entry	source_id	int	10	√		null
entry	source_link	varchar	1024	√		null
entry	status	int	10	√		null
entry	subp_id	int	10	√		0
entry	tags	text	65535	√		null
entry	thumbnail	varchar	48	√		null
entry	total_rank	int	10	√		0
entry	type	smallint	5	√		null
entry	updated_at	datetime	0	√		null
entry	views	int	10	√		0
entry	votes	int	10	√		0
facebook_invite	created_at	datetime	0	√		null
facebook_invite	id	int	10		√
facebook_invite	invited_puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
facebook_invite	puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
facebook_invite	status	smallint	5	√		null
facebook_invite	updated_at	datetime	0	√		null
favorite	id	int	10		√
favorite	kuser_id	int	10	√		null		kuser.id Defined in XML
favorite	privacy	int	10	√		null
favorite	subject_id	int	10	√		null
favorite	subject_type	int	10	√		null
flag	comment	varchar	2048	√		null
flag	created_at	datetime	0	√		null
flag	flag_type	int	10	√		null
flag	id	int	10		√
flag	kuser_id	int	10	√		null		kuser.id Defined in XML
flag	other	varchar	60	√		null
flag	subject_id	int	10	√		null
flag	subject_type	int	10	√		null
flickr_token	created_at	datetime	0	√		null
flickr_token	frob	varchar	64	√		null
flickr_token	is_valid	int	10	√		0
flickr_token	kalt_token	varchar	256
flickr_token	nsid	varchar	64	√		null
flickr_token	response	varchar	512	√		null
flickr_token	token	varchar	64	√		null
flickr_token	updated_at	datetime	0	√		null
keyword	entity_columns	varchar	30	√		null
keyword	entity_id	int	10	√		null
keyword	entity_type	int	10	√		null
keyword	word	varchar	30
kshow	comments	int	10	√		0
kshow	contrib_password	varchar	40	√		null
kshow	contrib_permissions	int	10	√		null
kshow	contributors	int	10	√		0
kshow	created_at	datetime	0	√		null
kshow	custom_data	text	65535	√		null
kshow	description	text	65535	√		null
kshow	display_in_search	tinyint	3	√		1
kshow	edit_password	varchar	40	√		null
kshow	edit_permissions	int	10	√		null
kshow	end_date	date	0	√		null
kshow	entries	int	10	√		0
kshow	episode_id	varchar	10	√		null
kshow	favorites	int	10	√		0
kshow	format_type	int	10	√		null
kshow	group_id	varchar	64	√		null
kshow	id	varchar	10				entry.kshow_id Defined in XML kshow_kuser.kshow_id Defined in XML kvote.kshow_id Defined in XML kwidget_log.kshow_id Defined in XML puser_role.kshow_id Defined in XML widget.kshow_id Defined in XML
kshow	indexed_custom_data_1	int	10	√		null
kshow	indexed_custom_data_2	int	10	√		null
kshow	indexed_custom_data_3	varchar	256	√		null
kshow	int_id	int	10		√
kshow	intro_id	varchar	10	√		null
kshow	language	int	10	√		null
kshow	length_in_msecs	int	10	√		0
kshow	license_type	int	10	√		null
kshow	media_type	int	10	√		null
kshow	name	varchar	60	√		null
kshow	number_of_updates	int	10	√		0
kshow	partner_data	varchar	4096	√		null
kshow	partner_id	int	10	√		0		partner.id Defined in XML
kshow	permissions	varchar	1024	√		null
kshow	plays	int	10	√		0
kshow	producer_id	int	10	√		null
kshow	rank	int	10	√		0
kshow	reoccurence	int	10	√		null
kshow	salt	varchar	32	√		null
kshow	search_text	varchar	4096	√		null
kshow	show_entry_id	varchar	10	√		null		entry.id Defined in XML
kshow	skin	text	65535	√		null
kshow	start_date	date	0	√		null
kshow	status	int	10	√		0
kshow	subdomain	varchar	30	√		null
kshow	subp_id	int	10	√		0
kshow	subscribers	int	10	√		0
kshow	tags	text	65535	√		null
kshow	thumbnail	varchar	48	√		null
kshow	type	int	10	√		null
kshow	updated_at	datetime	0	√		null
kshow	view_password	varchar	40	√		null
kshow	view_permissions	int	10	√		null
kshow	views	int	10	√		0
kshow	votes	int	10	√		0
kshow_kuser	alert_type	int	10	√		null
kshow_kuser	id	int	10		√
kshow_kuser	kshow_id	varchar	10	√		null		kshow.id Defined in XML
kshow_kuser	kuser_id	int	10	√		null		kuser.id Defined in XML
kshow_kuser	subscription_type	int	10	√		null
kuser	about_me	varchar	4096	√		null
kuser	admin_tags	text	65535	√		null
kuser	city	varchar	30	√		null
kuser	country	varchar	2	√		null
kuser	created_at	datetime	0	√		null
kuser	date_of_birth	date	0	√		null
kuser	display_in_search	tinyint	3	√		1
kuser	email	varchar	50	√		null
kuser	entries	int	10	√		0
kuser	fans	int	10	√		0
kuser	full_name	varchar	40	√		null
kuser	gender	tinyint	3	√		null
kuser	icon	tinyint	3	√		null
kuser	id	int	10		√		alert.kuser_id Defined in XML bb_post.kuser_id Defined in XML comment.kuser_id Defined in XML entry.kuser_id Defined in XML favorite.kuser_id Defined in XML flag.kuser_id Defined in XML kshow_kuser.kuser_id Defined in XML kvote.kuser_id Defined in XML moderation.kuser_id Defined in XML moderation_flag.flagged_kuser_id Defined in XML moderation_flag.kuser_id Defined in XML puser_kuser.kuser_id Defined in XML
kuser	im_list	varchar	256	√		null
kuser	indexed_partner_data_int	int	10	√		null
kuser	indexed_partner_data_string	varchar	64	√		null
kuser	mature_content	tinyint	3	√		null
kuser	mobile_num	varchar	16	√		null
kuser	network_college	varchar	30	√		null
kuser	network_highschool	varchar	30	√		null
kuser	network_other	varchar	30	√		null
kuser	partner_data	varchar	4096	√		null
kuser	partner_id	int	10	√		0		partner.id Defined in XML
kuser	picture	varchar	48	√		null
kuser	produced_kshows	int	10	√		0
kuser	puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
kuser	registration_cookie	varchar	256	√		null
kuser	registration_ip	int	10	√		null
kuser	salt	varchar	32	√		null
kuser	screen_name	varchar	20	√		null
kuser	search_text	varchar	4096	√		null
kuser	sha1_password	varchar	40	√		null
kuser	state	varchar	16	√		null
kuser	status	int	10	√		null
kuser	storage_size	int	10	√		0
kuser	tagline	varchar	256	√		null
kuser	tags	text	65535	√		null
kuser	updated_at	datetime	0	√		null
kuser	url_list	varchar	256	√		null
kuser	views	int	10	√		0
kuser	zip	varchar	10	√		null
kvote	created_at	datetime	0	√		null
kvote	entry_id	varchar	10	√		null		entry.id Defined in XML
kvote	id	int	10		√
kvote	kshow_id	varchar	10	√		null		kshow.id Defined in XML
kvote	kuser_id	int	10	√		null		kuser.id Defined in XML
kvote	rank	int	10	√		null
kwidget_log	created_at	datetime	0	√		null
kwidget_log	entry_id	varchar	10	√		null		entry.id Defined in XML
kwidget_log	id	int	10		√
kwidget_log	ip1	int	10	√		null
kwidget_log	ip1_count	int	10	√		0
kwidget_log	ip2	int	10	√		null
kwidget_log	ip2_count	int	10	√		0
kwidget_log	kshow_id	varchar	10	√		null		kshow.id Defined in XML
kwidget_log	partner_id	int	10	√		0		partner.id Defined in XML
kwidget_log	plays	int	10	√		0
kwidget_log	referer	varchar	1024	√		null
kwidget_log	root_widget_id	varchar	24	√		null
kwidget_log	source_widget_id	varchar	24	√		null
kwidget_log	subp_id	int	10	√		0
kwidget_log	ui_conf_id	int	10	√		null		ui_conf.id Defined in XML
kwidget_log	updated_at	datetime	0	√		null
kwidget_log	views	int	10	√		0
kwidget_log	widget_id	varchar	24	√		null		widget.id Defined in XML
mail_job	body_params	varchar	2048	√		null
mail_job	campaign_id	int	10	√		null
mail_job	created_at	datetime	0	√		null
mail_job	culture	tinyint	3	√		null
mail_job	execution_attempts	tinyint	3	√		null
mail_job	from_email	varchar	64	√		null
mail_job	from_name	varchar	64	√		null
mail_job	id	int	10		√
mail_job	lock_version	int	10	√		null
mail_job	mail_priority	smallint	5	√		null
mail_job	mail_type	smallint	5	√		null
mail_job	min_send_date	datetime	0	√		null
mail_job	partner_id	int	10	√		0		partner.id Defined in XML
mail_job	processor_expiration	datetime	0	√		null
mail_job	processor_location	varchar	64	√		null
mail_job	processor_name	varchar	64	√		null
mail_job	recipient_email	varchar	64	√		null
mail_job	recipient_id	int	10	√		null
mail_job	recipient_name	varchar	64	√		null
mail_job	status	tinyint	3	√		null
mail_job	subject_params	varchar	512	√		null
mail_job	template_path	varchar	512	√		null
mail_job	updated_at	datetime	0	√		null
moderation	comments	varchar	1024	√		null
moderation	created_at	datetime	0	√		null
moderation	group_id	varchar	64	√		null
moderation	id	int	10		√
moderation	kuser_id	int	10	√		null		kuser.id Defined in XML
moderation	object_id	varchar	10	√		null
moderation	object_type	smallint	5	√		null
moderation	partner_id	int	10	√		null		partner.id Defined in XML
moderation	puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
moderation	report_code	int	10	√		null
moderation	status	int	10	√		null
moderation	subp_id	int	10	√		null
moderation	updated_at	datetime	0	√		null
moderation_flag	comments	varchar	1024	√		null
moderation_flag	created_at	datetime	0	√		null
moderation_flag	flag_type	int	10	√		null
moderation_flag	flagged_entry_id	varchar	10	√		null		entry.id Defined in XML
moderation_flag	flagged_kuser_id	int	10	√		null		kuser.id Defined in XML
moderation_flag	id	int	10		√
moderation_flag	kuser_id	int	10	√		null		kuser.id Defined in XML
moderation_flag	object_type	smallint	5	√		null
moderation_flag	partner_id	int	10	√		null		partner.id Defined in XML
moderation_flag	status	int	10	√		null
moderation_flag	updated_at	datetime	0	√		null
notification	created_at	datetime	0	√		null
notification	execution_attempts	tinyint	3	√		null
notification	id	int	10		√
notification	lock_version	int	10	√		null
notification	notification_data	varchar	4096	√		null
notification	notification_result	varchar	256	√		null
notification	number_of_attempts	smallint	5	√		0
notification	object_id	varchar	10	√		null
notification	object_type	smallint	5	√		null
notification	partner_id	int	10	√		null		partner.id Defined in XML
notification	processor_expiration	datetime	0	√		null
notification	processor_location	varchar	64	√		null
notification	processor_name	varchar	64	√		null
notification	puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
notification	status	int	10	√		null
notification	type	smallint	5	√		null
notification	updated_at	datetime	0	√		null
partner	admin_email	varchar	50	√		null
partner	admin_name	varchar	50	√		null
partner	admin_secret	varchar	50	√		null
partner	adult_content	tinyint	3	√		0
partner	ANONYMOUS_KUSER_ID	int	10	√		null
partner	appear_in_search	int	10	√		2
partner	commercial_use	tinyint	3	√		0
partner	content_categories	varchar	1024	√		null
partner	create_user_on_demand	tinyint	3	√		1
partner	created_at	datetime	0	√		null
partner	custom_data	text	65535	√		null
partner	debug_level	int	10	√		0
partner	describe_yourself	varchar	64	√		null
partner	description	varchar	1024	√		null
partner	eighty_percent_warning	int	10	√		null
partner	id	int	10		√		admin_kuser.partner_id Defined in XML batch_job.partner_id Defined in XML collect_stats.partner_id Defined in XML conversion_params.partner_id Defined in XML conversion_profile.partner_id Defined in XML entry.partner_id Defined in XML kshow.partner_id Defined in XML kuser.partner_id Defined in XML kwidget_log.partner_id Defined in XML mail_job.partner_id Defined in XML moderation.partner_id Defined in XML moderation_flag.partner_id Defined in XML notification.partner_id Defined in XML partner_activity.partner_id Defined in XML partner_stats.partner_id Defined in XML partner_transactions.partner_id Defined in XML puser_kuser.partner_id Defined in XML puser_role.partner_id Defined in XML roughcut_entry.partner_id Defined in XML widget.partner_id Defined in XML
partner	invalid_login_count	int	10	√		null
partner	ks_max_expiry_in_seconds	int	10	√		null
partner	max_number_of_hits_per_day	int	10	√		-1
partner	moderate_content	tinyint	3	√		0
partner	notify	tinyint	3	√		0
partner	partner_alias	varchar	64	√		null
partner	partner_name	varchar	256	√		null
partner	partner_package	tinyint	3	√		1
partner	phone	varchar	64	√		null
partner	prefix	varchar	32	√		null
partner	secret	varchar	50	√		null
partner	service_config_id	varchar	64	√		null
partner	status	tinyint	3	√		1
partner	storage_usage	int	10	√		0
partner	type	tinyint	3	√		1
partner	updated_at	datetime	0	√		null
partner	url1	varchar	1024	√		null
partner	url2	varchar	1024	√		null
partner	usage_limit_warning	int	10	√		null
partner	usage_percent	int	10	√		0
partner_activity	activity	int	10	√		null
partner_activity	activity_date	date	0	√		null
partner_activity	amount	bigint	19	√		null
partner_activity	amount1	bigint	19	√		null
partner_activity	amount2	bigint	19	√		null
partner_activity	amount3	int	10	√		0
partner_activity	amount4	int	10	√		0
partner_activity	amount5	int	10	√		0
partner_activity	amount6	int	10	√		0
partner_activity	amount7	int	10	√		0
partner_activity	amount8	int	10	√		0
partner_activity	amount9	int	10	√		0
partner_activity	id	int	10		√
partner_activity	partner_id	int	10	√		null		partner.id Defined in XML
partner_activity	sub_activity	int	10	√		null
partner_stats	audios	int	10	√		null
partner_stats	created_at	datetime	0	√		null
partner_stats	custom_data	text	65535	√		null
partner_stats	entries	int	10	√		null
partner_stats	images	int	10	√		null
partner_stats	kshows_1	int	10	√		null
partner_stats	kshows_2	int	10	√		null
partner_stats	partner_id	int	10					partner.id Defined in XML
partner_stats	plays	int	10	√		null
partner_stats	rc_1	int	10	√		null
partner_stats	rc_2	int	10	√		null
partner_stats	updated_at	datetime	0	√		null
partner_stats	users_1	int	10	√		null
partner_stats	users_2	int	10	√		null
partner_stats	videos	int	10	√		null
partner_stats	views	int	10	√		null
partner_stats	widgets	int	10	√		null
partner_transactions	ack	varchar	20	√		null
partner_transactions	amount	float	12	√		null
partner_transactions	correlation_id	varchar	12	√		null
partner_transactions	created_at	datetime	0	√		null
partner_transactions	currency	varchar	6	√		null
partner_transactions	id	int	10		√
partner_transactions	partner_id	int	10	√		null		partner.id Defined in XML
partner_transactions	timestamp	datetime	0	√		null
partner_transactions	transaction_data	text	65535	√		null
partner_transactions	transaction_id	varchar	17	√		null
partnership	alt	varchar	256	√		null
partnership	created_at	datetime	0	√		null
partnership	href	varchar	1024	√		null
partnership	id	int	10		√
partnership	image_path	varchar	256	√		null
partnership	partnership_date	varchar	128	√		null
partnership	partnership_order	int	10	√		null
partnership	text	varchar	1024	√		null
partnership	updated_at	datetime	0	√		null
pr_news	alt	varchar	256	√		null
pr_news	created_at	datetime	0	√		null
pr_news	href	varchar	1024	√		null
pr_news	id	int	10		√
pr_news	image_path	varchar	256	√		null
pr_news	pr_order	int	10	√		null
pr_news	press_date	varchar	128	√		null
pr_news	text	varchar	1024	√		null
pr_news	updated_at	datetime	0	√		null
puser_kuser	context	varchar	1024	√
puser_kuser	created_at	datetime	0	√		null
puser_kuser	custom_data	varchar	1024	√		null
puser_kuser	id	int	10		√		entry.puser_id Defined in XML facebook_invite.invited_puser_id Defined in XML facebook_invite.puser_id Defined in XML kuser.puser_id Defined in XML moderation.puser_id Defined in XML notification.puser_id Defined in XML puser_kuser.puser_id Defined in XML puser_role.puser_id Defined in XML
puser_kuser	kuser_id	int	10	√		null		kuser.id Defined in XML
puser_kuser	partner_id	int	10	√		null		partner.id Defined in XML
puser_kuser	puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
puser_kuser	puser_name	varchar	64	√		null
puser_kuser	subp_id	int	10	√		0
puser_kuser	updated_at	datetime	0	√		null
puser_role	created_at	datetime	0	√		null
puser_role	id	int	10		√
puser_role	kshow_id	varchar	10	√		null		kshow.id Defined in XML
puser_role	partner_id	int	10	√		null		partner.id Defined in XML
puser_role	puser_id	varchar	64	√		null		puser_kuser.id Defined in XML
puser_role	role	int	10	√		null
puser_role	subp_id	int	10	√		0
puser_role	updated_at	datetime	0	√		null
roughcut_entry	created_at	datetime	0	√		null
roughcut_entry	entry_id	varchar	10	√		null		entry.id Defined in XML
roughcut_entry	id	int	10		√
roughcut_entry	op_type	smallint	5	√		null
roughcut_entry	partner_id	int	10	√		null		partner.id Defined in XML
roughcut_entry	roughcut_id	varchar	10	√		null
roughcut_entry	roughcut_kshow_id	varchar	10	√		null
roughcut_entry	roughcut_version	int	10	√		null
roughcut_entry	updated_at	datetime	0	√		null
tagword_count	tag	varchar	30
tagword_count	tag_count	int	10	√		null
tmp	anonymous	tinyint	3	√		null
tmp	comments	int	10	√		0
tmp	created_at	datetime	0	√		null
tmp	credit	varchar	1024	√		null
tmp	data	varchar	48	√		null
tmp	display_in_search	tinyint	3	√		1
tmp	favorites	int	10	√		0
tmp	id	int	10			0
tmp	kshow_id	int	10	√		null
tmp	kuser_id	int	10	√		null
tmp	length_in_msecs	int	10	√		0
tmp	license_type	smallint	5	√		null
tmp	media_type	smallint	5	√		null
tmp	name	varchar	60	√		null
tmp	partner_id	int	10	√		0
tmp	rank	int	10	√		0
tmp	source	smallint	5	√		null
tmp	source_id	int	10	√		null
tmp	source_link	varchar	1024	√		null
tmp	status	int	10	√		null
tmp	tags	text	65535	√		null
tmp	thumbnail	varchar	48	√		null
tmp	total_rank	int	10	√		0
tmp	type	smallint	5	√		null
tmp	updated_at	datetime	0	√		null
tmp	views	int	10	√		0
tmp	votes	int	10	√		0
ui_conf	conf_file_path	varchar	128	√		null
ui_conf	conf_vars	varchar	4096	√		null
ui_conf	created_at	datetime	0	√		null
ui_conf	creation_mode	tinyint	3	√		1
ui_conf	custom_data	text	65535	√		null
ui_conf	description	varchar	4096	√		null
ui_conf	display_in_search	tinyint	3	√		2
ui_conf	height	varchar	10	√		null
ui_conf	html_params	varchar	256	√		null
ui_conf	id	int	10		√		kwidget_log.ui_conf_id Defined in XML widget.ui_conf_id Defined in XML
ui_conf	name	varchar	128	√		null
ui_conf	obj_type	smallint	5	√		null
ui_conf	partner_id	int	10	√		null		entry.id Defined in XML
ui_conf	status	int	10	√		2
ui_conf	subp_id	int	10	√		0
ui_conf	swf_url	varchar	256	√		null
ui_conf	tags	text	65535	√		null
ui_conf	updated_at	datetime	0	√		null
ui_conf	use_cdn	tinyint	3	√		0
ui_conf	width	varchar	10	√		null
unique_visitors_cookie	date	date	0	√		null
unique_visitors_cookie	uv_id	varchar	32	√		null
unique_visitors_ip	date	date	0	√		null
unique_visitors_ip	ip	int	10	√		null
widget	created_at	datetime	0	√		null
widget	custom_data	varchar	1024	√		null
widget	entry_id	varchar	10	√		null		entry.id Defined in XML
widget	id	varchar	32				collect_stats.widget_id Defined in XML kwidget_log.widget_id Defined in XML
widget	int_id	int	10		√
widget	kshow_id	varchar	10	√		null		kshow.id Defined in XML
widget	partner_data	varchar	4096	√		null
widget	partner_id	int	10	√		null		partner.id Defined in XML
widget	root_widget_id	varchar	32	√		null
widget	security_policy	smallint	5	√		null
widget	security_type	smallint	5	√		null
widget	source_widget_id	varchar	32	√		null
widget	subp_id	int	10	√		null
widget	ui_conf_id	int	10	√		null		ui_conf.id Defined in XML
widget	updated_at	datetime	0	√		null
widget_log	created_at	datetime	0	√		null
widget_log	entry_id	varchar	10	√		null
widget_log	id	int	10		√
widget_log	ip1	int	10	√		null
widget_log	ip1_count	int	10	√		0
widget_log	ip2	int	10	√		null
widget_log	ip2_count	int	10	√		0
widget_log	kmedia_type	int	10	√		null
widget_log	kshow_id	varchar	10	√		null
widget_log	partner_id	int	10	√		0
widget_log	plays	int	10	√		0
widget_log	referer	varchar	1024	√		null
widget_log	subp_id	int	10	√		0
widget_log	updated_at	datetime	0	√		null
widget_log	views	int	10	√		0
widget_log	widget_type	varchar	32	√		null