setoopifan.public contains 977 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
batch_job_execution	create_time	timestamp	29,6
batch_job_execution	end_time	timestamp	29,6	√		null
batch_job_execution	exit_code	varchar	100	√		null
batch_job_execution	exit_message	varchar	2500	√		null
batch_job_execution	job_execution_id	int8	19
batch_job_execution	job_instance_id	int8	19
batch_job_execution	last_updated	timestamp	29,6	√		null
batch_job_execution	start_time	timestamp	29,6	√		null
batch_job_execution	status	varchar	10	√		null
batch_job_execution	version	int8	19	√		null
batch_job_execution_context	job_execution_id	int8	19
batch_job_execution_context	serialized_context	text	2147483647	√		null
batch_job_execution_context	short_context	varchar	2500
batch_job_instance	job_instance_id	int8	19
batch_job_instance	job_key	varchar	32
batch_job_instance	job_name	varchar	100
batch_job_instance	version	int8	19	√		null
batch_job_params	date_val	timestamp	29,6	√		null
batch_job_params	double_val	float8	17,17	√		null
batch_job_params	job_instance_id	int8	19
batch_job_params	key_name	varchar	100
batch_job_params	long_val	int8	19	√		null
batch_job_params	string_val	varchar	250	√		null
batch_job_params	type_cd	varchar	6
batch_step_execution	commit_count	int8	19	√		null
batch_step_execution	end_time	timestamp	29,6	√		null
batch_step_execution	exit_code	varchar	100	√		null
batch_step_execution	exit_message	varchar	2500	√		null
batch_step_execution	filter_count	int8	19	√		null
batch_step_execution	job_execution_id	int8	19
batch_step_execution	last_updated	timestamp	29,6	√		null
batch_step_execution	process_skip_count	int8	19	√		null
batch_step_execution	read_count	int8	19	√		null
batch_step_execution	read_skip_count	int8	19	√		null
batch_step_execution	rollback_count	int8	19	√		null
batch_step_execution	start_time	timestamp	29,6
batch_step_execution	status	varchar	10	√		null
batch_step_execution	step_execution_id	int8	19
batch_step_execution	step_name	varchar	100
batch_step_execution	version	int8	19
batch_step_execution	write_count	int8	19	√		null
batch_step_execution	write_skip_count	int8	19	√		null
batch_step_execution_context	serialized_context	text	2147483647	√		null
batch_step_execution_context	short_context	varchar	2500
batch_step_execution_context	step_execution_id	int8	19
jivedw_acclaim	acclaim_id	int8	19
jivedw_acclaim	acclaim_type	varchar	20
jivedw_acclaim	creation_ts	timestamp	29,6	√		null
jivedw_acclaim	modification_ts	timestamp	29,6	√		null
jivedw_acclaim	object_id	int8	19
jivedw_acclaim	object_type	int4	10
jivedw_acclaim	score	numeric	131089			0
jivedw_acclaim	score_display	numeric	131089			0
jivedw_acclaim	visibility	int4	10			1
jivedw_acclaim_stage	acclaim_id	int8	19
jivedw_acclaim_stage	acclaim_type	varchar	20
jivedw_acclaim_stage	creation_ts	timestamp	29,6	√		null
jivedw_acclaim_stage	modification_ts	timestamp	29,6	√		null
jivedw_acclaim_stage	object_id	int8	19
jivedw_acclaim_stage	object_type	int4	10
jivedw_acclaim_stage	score	numeric	131089			0
jivedw_acclaim_stage	score_display	numeric	131089			0
jivedw_acclaim_stage	visibility	int4	10			1
jivedw_acclaimvote	acclaim_id	int8	19
jivedw_acclaimvote	creation_ts	timestamp	29,6	√		null
jivedw_acclaimvote	modification_ts	timestamp	29,6	√		null
jivedw_acclaimvote	vote_id	int8	19
jivedw_acclaimvote	vote_value	int4	10			0
jivedw_acclaimvote	voter_id	int8	19
jivedw_acclaimvote_stage	acclaim_id	int8	19
jivedw_acclaimvote_stage	creation_ts	timestamp	29,6	√		null
jivedw_acclaimvote_stage	modification_ts	timestamp	29,6	√		null
jivedw_acclaimvote_stage	vote_id	int8	19
jivedw_acclaimvote_stage	vote_value	int4	10			0
jivedw_acclaimvote_stage	voter_id	int8	19
jivedw_act_usr_day_summary	active	int8	19
jivedw_act_usr_day_summary	day_id	int8	19
jivedw_act_usr_month_summary	active	int8	19
jivedw_act_usr_month_summary	month_id	int8	19
jivedw_activity_agg_day	activity_count	int4	10
jivedw_activity_agg_day	activity_type	int4	10
jivedw_activity_agg_day	day_id	int4	10
jivedw_activity_agg_day	direct_dw_object_id	int8	19
jivedw_activity_agg_day	direct_object_type	int4	10
jivedw_activity_agg_day	dw_container_id	int8	19	√		null
jivedw_activity_agg_day	indirect_dw_object_id	int8	19	√		null
jivedw_activity_agg_day	indirect_object_type	int4	10	√		null
jivedw_activity_agg_day	user_id	int8	19
jivedw_activity_agg_month	activity_count	int4	10
jivedw_activity_agg_month	activity_type	int4	10
jivedw_activity_agg_month	direct_dw_object_id	int8	19
jivedw_activity_agg_month	direct_object_type	int4	10
jivedw_activity_agg_month	dw_container_id	int8	19	√		null
jivedw_activity_agg_month	indirect_dw_object_id	int8	19	√		null
jivedw_activity_agg_month	indirect_object_type	int4	10	√		null
jivedw_activity_agg_month	month_id	int4	10
jivedw_activity_agg_month	user_id	int8	19
jivedw_activity_agg_user_day	activity_count	int4	10
jivedw_activity_agg_user_day	activity_type	int4	10
jivedw_activity_agg_user_day	day_id	int4	10
jivedw_activity_agg_user_day	direct_dw_object_id	int8	19
jivedw_activity_agg_user_day	direct_object_type	int4	10
jivedw_activity_agg_user_day	dw_container_id	int8	19	√		null
jivedw_activity_agg_user_day	indirect_dw_object_id	int8	19	√		null
jivedw_activity_agg_user_day	indirect_object_type	int4	10	√		null
jivedw_activity_agg_user_month	activity_count	int4	10
jivedw_activity_agg_user_month	activity_type	int4	10
jivedw_activity_agg_user_month	direct_dw_object_id	int8	19
jivedw_activity_agg_user_month	direct_object_type	int4	10
jivedw_activity_agg_user_month	dw_container_id	int8	19	√		null
jivedw_activity_agg_user_month	indirect_dw_object_id	int8	19	√		null
jivedw_activity_agg_user_month	indirect_object_type	int4	10	√		null
jivedw_activity_agg_user_month	month_id	int4	10
jivedw_activity_agg_user_week	activity_count	int4	10
jivedw_activity_agg_user_week	activity_type	int4	10
jivedw_activity_agg_user_week	direct_dw_object_id	int8	19
jivedw_activity_agg_user_week	direct_object_type	int4	10
jivedw_activity_agg_user_week	dw_container_id	int8	19	√		null
jivedw_activity_agg_user_week	indirect_dw_object_id	int8	19	√		null
jivedw_activity_agg_user_week	indirect_object_type	int4	10	√		null
jivedw_activity_agg_user_week	week_id	int4	10
jivedw_activity_agg_week	activity_count	int4	10
jivedw_activity_agg_week	activity_type	int4	10
jivedw_activity_agg_week	direct_dw_object_id	int8	19
jivedw_activity_agg_week	direct_object_type	int4	10
jivedw_activity_agg_week	dw_container_id	int8	19	√		null
jivedw_activity_agg_week	indirect_dw_object_id	int8	19	√		null
jivedw_activity_agg_week	indirect_object_type	int4	10	√		null
jivedw_activity_agg_week	user_id	int8	19
jivedw_activity_agg_week	week_id	int4	10
jivedw_activity_fact	activity_ts	timestamp	29,6
jivedw_activity_fact	activity_type	int4	10
jivedw_activity_fact	day_id	int4	10
jivedw_activity_fact	direct_dw_object_id	int8	19
jivedw_activity_fact	direct_object_type	int4	10
jivedw_activity_fact	dw_container_id	int8	19	√		null
jivedw_activity_fact	indirect_dw_object_id	int8	19	√		null
jivedw_activity_fact	indirect_object_type	int4	10	√		null
jivedw_activity_fact	metadata	text	2147483647	√		null
jivedw_activity_fact	user_id	int8	19
jivedw_activity_meta	activity_name	varchar	100
jivedw_activity_meta	activity_type	int4	10
jivedw_activity_meta	description	varchar	2000
jivedw_activity_stage	activity_ts	timestamp	29,6
jivedw_activity_stage	activity_type	int4	10
jivedw_activity_stage	container_id	int8	19	√		null
jivedw_activity_stage	container_type	int4	10	√		null
jivedw_activity_stage	direct_object_id	int8	19
jivedw_activity_stage	direct_object_type	int4	10
jivedw_activity_stage	indirect_object_id	int8	19	√		null
jivedw_activity_stage	indirect_object_type	int4	10	√		null
jivedw_activity_stage	metadata	text	2147483647	√		null
jivedw_activity_stage	user_id	int8	19
jivedw_activity_summary	bookmark_count	int4	10
jivedw_activity_summary	container_id	int8	19
jivedw_activity_summary	container_type	int4	10
jivedw_activity_summary	content_id	int8	19
jivedw_activity_summary	content_type	int4	10
jivedw_activity_summary	create_count	int4	10
jivedw_activity_summary	day_ts	timestamp	29,6
jivedw_activity_summary	follow_count	int4	10
jivedw_activity_summary	like_count	int4	10
jivedw_activity_summary	mention_count	int4	10
jivedw_activity_summary	modify_count	int4	10
jivedw_activity_summary	rate_count	int4	10
jivedw_activity_summary	response_count	int4	10
jivedw_activity_summary	user_id	int8	19
jivedw_activity_summary	username	varchar	100
jivedw_activity_summary	view_count	int4	10
jivedw_adoption_glb_summary	active	int4	10
jivedw_adoption_glb_summary	contributor	int4	10
jivedw_adoption_glb_summary	day_ts	timestamp	29,6
jivedw_adoption_glb_summary	participant	int4	10
jivedw_adoption_glb_summary	user_id	int8	19
jivedw_adoption_glb_summary	username	varchar	100
jivedw_adoption_grp_summary	active	int4	10
jivedw_adoption_grp_summary	container_id	int8	19
jivedw_adoption_grp_summary	contributor	int4	10
jivedw_adoption_grp_summary	day_ts	timestamp	29,6
jivedw_adoption_grp_summary	participant	int4	10
jivedw_adoption_grp_summary	user_id	int8	19
jivedw_adoption_grp_summary	username	varchar	100
jivedw_adoption_spc_summary	active	int4	10
jivedw_adoption_spc_summary	container_id	int8	19
jivedw_adoption_spc_summary	contributor	int4	10
jivedw_adoption_spc_summary	day_ts	timestamp	29,6
jivedw_adoption_spc_summary	participant	int4	10
jivedw_adoption_spc_summary	user_id	int8	19
jivedw_adoption_spc_summary	username	varchar	100
jivedw_adoption_u_glb_summary	active	int8	19
jivedw_adoption_u_glb_summary	contributor	int8	19
jivedw_adoption_u_glb_summary	day_ts	timestamp	29,6
jivedw_adoption_u_glb_summary	participant	int8	19
jivedw_adoption_u_grp_summary	active	int8	19
jivedw_adoption_u_grp_summary	container_id	int8	19
jivedw_adoption_u_grp_summary	contributor	int8	19
jivedw_adoption_u_grp_summary	day_ts	timestamp	29,6
jivedw_adoption_u_grp_summary	participant	int8	19
jivedw_adoption_u_spc_summary	active	int8	19
jivedw_adoption_u_spc_summary	container_id	int8	19
jivedw_adoption_u_spc_summary	contributor	int8	19
jivedw_adoption_u_spc_summary	day_ts	timestamp	29,6
jivedw_adoption_u_spc_summary	participant	int8	19
jivedw_answer	container_id	int8	19
jivedw_answer	container_type	int8	19
jivedw_answer	correct_answer	int2	5
jivedw_answer	helpful_answer	int2	5
jivedw_answer	message_id	int8	19
jivedw_answer	thread_id	int8	19
jivedw_answer	user_id	int8	19	√		null
jivedw_answer_stage	container_id	int8	19
jivedw_answer_stage	container_type	int8	19
jivedw_answer_stage	correct_answer	int2	5
jivedw_answer_stage	helpful_answer	int2	5
jivedw_answer_stage	message_id	int8	19
jivedw_answer_stage	thread_id	int8	19
jivedw_answer_stage	user_id	int8	19	√		null
jivedw_avatar	avatar_id	int8	19
jivedw_avatar	mod_value	int4	10
jivedw_avatar	owner_id	int8	19	√		null
jivedw_avatar_stage	avatar_id	int8	19
jivedw_avatar_stage	mod_value	int4	10
jivedw_avatar_stage	owner_id	int8	19	√		null
jivedw_avatar_user	avatar_id	int8	19
jivedw_avatar_user	user_id	int8	19
jivedw_avatar_user_stage	avatar_id	int8	19
jivedw_avatar_user_stage	user_id	int8	19
jivedw_blog	blog_id	int8	19
jivedw_blog	container_id	int8	19			'-2'::integer
jivedw_blog	container_type	int4	10			17
jivedw_blog	creation_ts	timestamp	29,6
jivedw_blog	modification_ts	timestamp	29,6
jivedw_blog	name	varchar	255
jivedw_blog	status	int4	10
jivedw_blog_stage	blog_id	int8	19
jivedw_blog_stage	container_id	int8	19			'-2'::integer
jivedw_blog_stage	container_type	int4	10			17
jivedw_blog_stage	creation_ts	timestamp	29,6
jivedw_blog_stage	modification_ts	timestamp	29,6
jivedw_blog_stage	name	varchar	255
jivedw_blog_stage	status	int4	10
jivedw_blogpost	blog_id	int8	19
jivedw_blogpost	blogpost_id	int8	19
jivedw_blogpost	creation_ts	timestamp	29,6
jivedw_blogpost	modification_ts	timestamp	29,6
jivedw_blogpost	subject	varchar	255	√		null
jivedw_blogpost_stage	blog_id	int8	19
jivedw_blogpost_stage	blogpost_id	int8	19
jivedw_blogpost_stage	creation_ts	timestamp	29,6
jivedw_blogpost_stage	modification_ts	timestamp	29,6
jivedw_blogpost_stage	subject	varchar	255	√		null
jivedw_blogpost_stats_fact	activity_date	timestamp	29,6
jivedw_blogpost_stats_fact	bookmarks	int4	10
jivedw_blogpost_stats_fact	comments	int4	10
jivedw_blogpost_stats_fact	content_id	int8	19
jivedw_blogpost_stats_fact	likes	int4	10
jivedw_blogpost_stats_fact	shares	int4	10
jivedw_blogpost_stats_fact	unbookmarks	int4	10
jivedw_blogpost_stats_fact	uncomments	int4	10
jivedw_blogpost_stats_fact	unique_viewers	int4	10
jivedw_blogpost_stats_fact	unlikes	int4	10
jivedw_blogpost_stats_fact	viewers	text	2147483647	√		null
jivedw_blogpost_stats_fact	views	int4	10
jivedw_blogpost_stats_metadata	content_id	int8	19
jivedw_blogpost_stats_metadata	viewers	text	2147483647	√		null
jivedw_blogpost_stats_stage	activity_ts	timestamp	29,6
jivedw_blogpost_stats_stage	activity_type	int4	10
jivedw_blogpost_stats_stage	content_id	int8	19
jivedw_blogpost_stats_stage	date_id	timestamp	29,6
jivedw_blogpost_stats_stage	hour_id	int4	10
jivedw_blogpost_stats_stage	user_id	int8	19
jivedw_caching_stats	caching_duration	int8	19	√		null
jivedw_caching_stats	chart_key	varchar	100
jivedw_caching_stats	parameters	varchar	3500	√		null
jivedw_comment	comment_id	int8	19
jivedw_comment	creation_ts	timestamp	29,6
jivedw_comment	modification_ts	timestamp	29,6
jivedw_comment	object_id	int8	19
jivedw_comment	object_type	int4	10
jivedw_comment	parent_comment_id	int8	19	√		null
jivedw_comment	parent_object_id	int8	19	√		null
jivedw_comment	parent_object_type	int4	10	√		null
jivedw_comment	status	int4	10
jivedw_comment	user_id	int8	19	√		null
jivedw_comment_stage	comment_id	int8	19
jivedw_comment_stage	creation_ts	timestamp	29,6
jivedw_comment_stage	modification_ts	timestamp	29,6
jivedw_comment_stage	object_id	int8	19
jivedw_comment_stage	object_type	int4	10
jivedw_comment_stage	parent_comment_id	int8	19	√		null
jivedw_comment_stage	parent_object_id	int8	19	√		null
jivedw_comment_stage	parent_object_type	int4	10	√		null
jivedw_comment_stage	status	int4	10
jivedw_comment_stage	user_id	int8	19	√		null
jivedw_community	community_id	int8	19
jivedw_community	creation_ts	timestamp	29,6
jivedw_community	lft	int4	10
jivedw_community	modification_ts	timestamp	29,6
jivedw_community	name	varchar	255
jivedw_community	rgt	int4	10
jivedw_community_stage	community_id	int8	19
jivedw_community_stage	creation_ts	timestamp	29,6
jivedw_community_stage	lft	int4	10
jivedw_community_stage	modification_ts	timestamp	29,6
jivedw_community_stage	name	varchar	255
jivedw_community_stage	rgt	int4	10
jivedw_container	container_id	int8	19
jivedw_container	container_type	int4	10
jivedw_container	creation_ts	timestamp	29,6
jivedw_container	dw_container_id	int8	19
jivedw_container	modification_ts	timestamp	29,6
jivedw_container	name	varchar	255
jivedw_container_stage	container_id	int8	19
jivedw_container_stage	container_type	int4	10
jivedw_container_stage	creation_ts	timestamp	29,6
jivedw_container_stage	modification_ts	timestamp	29,6
jivedw_container_stage	name	varchar	255
jivedw_content	container_id	int8	19	√		null
jivedw_content	container_type	int8	19	√		null
jivedw_content	content_id	int8	19
jivedw_content	content_type	int8	19
jivedw_content	creation_ts	timestamp	29,6	√		null
jivedw_content	modification_ts	timestamp	29,6	√		null
jivedw_content	status	int4	10	√		null
jivedw_content	subject	varchar	255	√		null
jivedw_content	user_id	int8	19	√		null
jivedw_content_glb_summary	bookmark_count	int4	10
jivedw_content_glb_summary	content_id	int8	19
jivedw_content_glb_summary	content_type	int4	10
jivedw_content_glb_summary	day_ts	timestamp	29,6
jivedw_content_glb_summary	follow_count	int4	10
jivedw_content_glb_summary	like_count	int4	10
jivedw_content_glb_summary	mention_count	int4	10
jivedw_content_glb_summary	modify_count	int4	10
jivedw_content_glb_summary	rate_count	int4	10
jivedw_content_glb_summary	response_count	int4	10
jivedw_content_glb_summary	user_id	int8	19
jivedw_content_glb_summary	username	varchar	100
jivedw_content_glb_summary	view_count	int4	10
jivedw_content_grp_summary	bookmark_count	int4	10
jivedw_content_grp_summary	container_id	int8	19
jivedw_content_grp_summary	content_id	int8	19
jivedw_content_grp_summary	content_type	int4	10
jivedw_content_grp_summary	day_ts	timestamp	29,6
jivedw_content_grp_summary	follow_count	int4	10
jivedw_content_grp_summary	like_count	int4	10
jivedw_content_grp_summary	mention_count	int4	10
jivedw_content_grp_summary	modify_count	int4	10
jivedw_content_grp_summary	rate_count	int4	10
jivedw_content_grp_summary	response_count	int4	10
jivedw_content_grp_summary	user_id	int8	19
jivedw_content_grp_summary	username	varchar	100
jivedw_content_grp_summary	view_count	int4	10
jivedw_content_spc_summary	bookmark_count	int4	10
jivedw_content_spc_summary	container_id	int8	19
jivedw_content_spc_summary	content_id	int8	19
jivedw_content_spc_summary	content_type	int4	10
jivedw_content_spc_summary	day_ts	timestamp	29,6
jivedw_content_spc_summary	follow_count	int4	10
jivedw_content_spc_summary	like_count	int4	10
jivedw_content_spc_summary	mention_count	int4	10
jivedw_content_spc_summary	modify_count	int4	10
jivedw_content_spc_summary	rate_count	int4	10
jivedw_content_spc_summary	response_count	int4	10
jivedw_content_spc_summary	user_id	int8	19
jivedw_content_spc_summary	username	varchar	100
jivedw_content_spc_summary	view_count	int4	10
jivedw_content_stage	container_id	int8	19	√		null
jivedw_content_stage	container_type	int8	19	√		null
jivedw_content_stage	content_id	int8	19
jivedw_content_stage	content_type	int8	19
jivedw_content_stage	creation_ts	timestamp	29,6	√		null
jivedw_content_stage	modification_ts	timestamp	29,6	√		null
jivedw_content_stage	status	int4	10	√		null
jivedw_content_stage	subject	varchar	255	√		null
jivedw_content_stage	user_id	int8	19	√		null
jivedw_content_summary	blog_post_count	int8	19
jivedw_content_summary	container_id	int8	19
jivedw_content_summary	container_type	int4	10
jivedw_content_summary	day_ts	timestamp	29,6
jivedw_content_summary	document_count	int8	19
jivedw_content_summary	idea_count	int8	19
jivedw_content_summary	poll_count	int8	19
jivedw_content_summary	question_count	int8	19
jivedw_content_summary	question_helped_count	int8	19
jivedw_content_summary	question_resolved_count	int8	19
jivedw_content_summary	question_responded_count	int8	19
jivedw_content_summary	status_count	int8	19
jivedw_content_summary	thread_count	int8	19
jivedw_content_summary	user_id	int8	19
jivedw_content_summary	video_count	int8	19
jivedw_content_u_glb_summary	bookmark_count	int4	10
jivedw_content_u_glb_summary	content_id	int8	19
jivedw_content_u_glb_summary	content_type	int4	10
jivedw_content_u_glb_summary	day_ts	timestamp	29,6
jivedw_content_u_glb_summary	follow_count	int4	10
jivedw_content_u_glb_summary	like_count	int4	10
jivedw_content_u_glb_summary	mention_count	int4	10
jivedw_content_u_glb_summary	modify_count	int4	10
jivedw_content_u_glb_summary	rate_count	int4	10
jivedw_content_u_glb_summary	response_count	int4	10
jivedw_content_u_glb_summary	view_count	int4	10
jivedw_content_u_grp_summary	bookmark_count	int4	10
jivedw_content_u_grp_summary	container_id	int8	19
jivedw_content_u_grp_summary	content_id	int8	19
jivedw_content_u_grp_summary	content_type	int4	10
jivedw_content_u_grp_summary	day_ts	timestamp	29,6
jivedw_content_u_grp_summary	follow_count	int4	10
jivedw_content_u_grp_summary	like_count	int4	10
jivedw_content_u_grp_summary	mention_count	int4	10
jivedw_content_u_grp_summary	modify_count	int4	10
jivedw_content_u_grp_summary	rate_count	int4	10
jivedw_content_u_grp_summary	response_count	int4	10
jivedw_content_u_grp_summary	view_count	int4	10
jivedw_content_u_spc_summary	bookmark_count	int4	10
jivedw_content_u_spc_summary	container_id	int8	19
jivedw_content_u_spc_summary	content_id	int8	19
jivedw_content_u_spc_summary	content_type	int4	10
jivedw_content_u_spc_summary	day_ts	timestamp	29,6
jivedw_content_u_spc_summary	follow_count	int4	10
jivedw_content_u_spc_summary	like_count	int4	10
jivedw_content_u_spc_summary	mention_count	int4	10
jivedw_content_u_spc_summary	modify_count	int4	10
jivedw_content_u_spc_summary	rate_count	int4	10
jivedw_content_u_spc_summary	response_count	int4	10
jivedw_content_u_spc_summary	view_count	int4	10
jivedw_contentprop	content_id	int8	19
jivedw_contentprop	content_type	int8	19
jivedw_contentprop	modification_ts	timestamp	29,6	√		null
jivedw_contentprop	prop_name	varchar	255
jivedw_contentprop	prop_value	text	2147483647
jivedw_contentprop_stage	content_id	int8	19
jivedw_contentprop_stage	content_type	int8	19
jivedw_contentprop_stage	modification_ts	timestamp	29,6	√		null
jivedw_contentprop_stage	prop_name	varchar	255
jivedw_contentprop_stage	prop_value	text	2147483647
jivedw_daily_glb_summary	bookmark_count	int4	10
jivedw_daily_glb_summary	create_count	int4	10
jivedw_daily_glb_summary	day_ts	timestamp	29,6
jivedw_daily_glb_summary	follow_count	int4	10
jivedw_daily_glb_summary	like_count	int4	10
jivedw_daily_glb_summary	mention_count	int4	10
jivedw_daily_glb_summary	modify_count	int4	10
jivedw_daily_glb_summary	rate_count	int4	10
jivedw_daily_glb_summary	response_count	int4	10
jivedw_daily_glb_summary	user_id	int8	19
jivedw_daily_glb_summary	username	varchar	100
jivedw_daily_glb_summary	view_count	int4	10
jivedw_daily_grp_summary	bookmark_count	int4	10
jivedw_daily_grp_summary	container_id	int8	19
jivedw_daily_grp_summary	create_count	int4	10
jivedw_daily_grp_summary	day_ts	timestamp	29,6
jivedw_daily_grp_summary	follow_count	int4	10
jivedw_daily_grp_summary	like_count	int4	10
jivedw_daily_grp_summary	mention_count	int4	10
jivedw_daily_grp_summary	modify_count	int4	10
jivedw_daily_grp_summary	rate_count	int4	10
jivedw_daily_grp_summary	response_count	int4	10
jivedw_daily_grp_summary	user_id	int8	19
jivedw_daily_grp_summary	username	varchar	100
jivedw_daily_grp_summary	view_count	int4	10
jivedw_daily_spc_summary	bookmark_count	int4	10
jivedw_daily_spc_summary	container_id	int8	19
jivedw_daily_spc_summary	create_count	int4	10
jivedw_daily_spc_summary	day_ts	timestamp	29,6
jivedw_daily_spc_summary	follow_count	int4	10
jivedw_daily_spc_summary	like_count	int4	10
jivedw_daily_spc_summary	mention_count	int4	10
jivedw_daily_spc_summary	modify_count	int4	10
jivedw_daily_spc_summary	rate_count	int4	10
jivedw_daily_spc_summary	response_count	int4	10
jivedw_daily_spc_summary	user_id	int8	19
jivedw_daily_spc_summary	username	varchar	100
jivedw_daily_spc_summary	view_count	int4	10
jivedw_daily_u_glb_summary	bookmark_count	int4	10
jivedw_daily_u_glb_summary	create_count	int4	10
jivedw_daily_u_glb_summary	day_ts	timestamp	29,6
jivedw_daily_u_glb_summary	follow_count	int4	10
jivedw_daily_u_glb_summary	like_count	int4	10
jivedw_daily_u_glb_summary	mention_count	int4	10
jivedw_daily_u_glb_summary	modify_count	int4	10
jivedw_daily_u_glb_summary	rate_count	int4	10
jivedw_daily_u_glb_summary	response_count	int4	10
jivedw_daily_u_glb_summary	view_count	int4	10
jivedw_daily_u_grp_summary	bookmark_count	int4	10
jivedw_daily_u_grp_summary	container_id	int8	19
jivedw_daily_u_grp_summary	create_count	int4	10
jivedw_daily_u_grp_summary	day_ts	timestamp	29,6
jivedw_daily_u_grp_summary	follow_count	int4	10
jivedw_daily_u_grp_summary	like_count	int4	10
jivedw_daily_u_grp_summary	mention_count	int4	10
jivedw_daily_u_grp_summary	modify_count	int4	10
jivedw_daily_u_grp_summary	rate_count	int4	10
jivedw_daily_u_grp_summary	response_count	int4	10
jivedw_daily_u_grp_summary	view_count	int4	10
jivedw_daily_u_spc_summary	bookmark_count	int4	10
jivedw_daily_u_spc_summary	container_id	int8	19
jivedw_daily_u_spc_summary	create_count	int4	10
jivedw_daily_u_spc_summary	day_ts	timestamp	29,6
jivedw_daily_u_spc_summary	follow_count	int4	10
jivedw_daily_u_spc_summary	like_count	int4	10
jivedw_daily_u_spc_summary	mention_count	int4	10
jivedw_daily_u_spc_summary	modify_count	int4	10
jivedw_daily_u_spc_summary	rate_count	int4	10
jivedw_daily_u_spc_summary	response_count	int4	10
jivedw_daily_u_spc_summary	view_count	int4	10
jivedw_day	begin_ts	timestamp	29,6
jivedw_day	day_id	int8	19
jivedw_day	day_of_month	int4	10
jivedw_day	end_ts	timestamp	29,6
jivedw_day	iso_year	int4	10	√		null
jivedw_day	month_of_year	int4	10
jivedw_day	week_of_year	int4	10
jivedw_day	year	int4	10
jivedw_deleted_objects	deleted_ts	timestamp	29,6
jivedw_deleted_objects	id	int8	19
jivedw_deleted_objects	object_id	int8	19
jivedw_deleted_objects	object_type	int4	10
jivedw_deleted_objects_stage	deleted_ts	timestamp	29,6
jivedw_deleted_objects_stage	id	int8	19
jivedw_deleted_objects_stage	object_id	int8	19
jivedw_deleted_objects_stage	object_type	int4	10
jivedw_document	container_id	int8	19
jivedw_document	container_type	int4	10
jivedw_document	creation_ts	timestamp	29,6
jivedw_document	document_id	int8	19
jivedw_document	modification_ts	timestamp	29,6
jivedw_document	title	varchar	255
jivedw_document_stage	container_id	int8	19
jivedw_document_stage	container_type	int4	10
jivedw_document_stage	creation_ts	timestamp	29,6
jivedw_document_stage	document_id	int8	19
jivedw_document_stage	modification_ts	timestamp	29,6
jivedw_document_stage	title	varchar	255
jivedw_document_stats_fact	activity_date	timestamp	29,6
jivedw_document_stats_fact	bookmarks	int4	10
jivedw_document_stats_fact	comments	int4	10
jivedw_document_stats_fact	content_id	int8	19
jivedw_document_stats_fact	likes	int4	10
jivedw_document_stats_fact	shares	int4	10
jivedw_document_stats_fact	unbookmarks	int4	10
jivedw_document_stats_fact	uncomments	int4	10
jivedw_document_stats_fact	unique_viewers	int4	10
jivedw_document_stats_fact	unlikes	int4	10
jivedw_document_stats_fact	viewers	text	2147483647	√		null
jivedw_document_stats_fact	views	int4	10
jivedw_document_stats_metadata	content_id	int8	19
jivedw_document_stats_metadata	viewers	text	2147483647	√		null
jivedw_document_stats_stage	activity_ts	timestamp	29,6
jivedw_document_stats_stage	activity_type	int4	10
jivedw_document_stats_stage	content_id	int8	19
jivedw_document_stats_stage	date_id	timestamp	29,6
jivedw_document_stats_stage	hour_id	int4	10
jivedw_document_stats_stage	user_id	int8	19
jivedw_etl_job	end_ts	timestamp	29,6	√		null
jivedw_etl_job	error_msg	varchar	2000	√		null
jivedw_etl_job	etl_job_id	int8	19
jivedw_etl_job	start_ts	timestamp	29,6
jivedw_etl_job	state	int4	10
jivedw_etl_task	classname	varchar	255
jivedw_etl_task	etl_task_id	int8	19
jivedw_etl_task	lastprocmodificationdate	int8	19	√		null
jivedw_etl_task	name	varchar	255
jivedw_group	creation_ts	timestamp	29,6
jivedw_group	description	varchar	1000	√		null
jivedw_group	group_id	int8	19
jivedw_group	modification_ts	timestamp	29,6
jivedw_group	name	varchar	100
jivedw_group_stage	creation_ts	timestamp	29,6
jivedw_group_stage	description	varchar	1000	√		null
jivedw_group_stage	group_id	int8	19
jivedw_group_stage	modification_ts	timestamp	29,6
jivedw_group_stage	name	varchar	100
jivedw_groupuserhst	administrator	int4	10
jivedw_groupuserhst	creation_ts	timestamp	29,6
jivedw_groupuserhst	group_id	int8	19
jivedw_groupuserhst	group_user_id	int8	19
jivedw_groupuserhst	modification_ts	timestamp	29,6
jivedw_groupuserhst	retired_ts	timestamp	29,6	√		null
jivedw_groupuserhst	user_id	int8	19
jivedw_groupuserhst_stage	administrator	int4	10
jivedw_groupuserhst_stage	creation_ts	timestamp	29,6
jivedw_groupuserhst_stage	group_id	int8	19
jivedw_groupuserhst_stage	group_user_id	int8	19
jivedw_groupuserhst_stage	modification_ts	timestamp	29,6
jivedw_groupuserhst_stage	retired_ts	timestamp	29,6	√		null
jivedw_groupuserhst_stage	user_id	int8	19
jivedw_idea	author_id	int8	19	√		null
jivedw_idea	container_id	int8	19
jivedw_idea	container_type	int4	10
jivedw_idea	creation_ts	timestamp	29,6
jivedw_idea	idea_id	int8	19
jivedw_idea	idea_state	varchar	255	√		null
jivedw_idea	modification_ts	timestamp	29,6
jivedw_idea	status	int4	10
jivedw_idea	user_id	int8	19
jivedw_idea_stage	author_id	int8	19	√		null
jivedw_idea_stage	container_id	int8	19
jivedw_idea_stage	container_type	int4	10
jivedw_idea_stage	creation_ts	timestamp	29,6
jivedw_idea_stage	idea_id	int8	19
jivedw_idea_stage	idea_state	varchar	255	√		null
jivedw_idea_stage	modification_ts	timestamp	29,6
jivedw_idea_stage	status	int4	10
jivedw_idea_stage	user_id	int8	19
jivedw_impactstats_activation	activation_ts	timestamp	29,6
jivedw_impactstats_jobs	completed_time	timestamp	29,6
jivedw_impactstats_jobs	job_name	varchar	50
jivedw_interaction_summary	activity_count	int8	19
jivedw_interaction_summary	activity_type	int4	10
jivedw_interaction_summary	actor	int8	19
jivedw_interaction_summary	author	int8	19
jivedw_interaction_summary	day_id	int4	10
jivedw_interaction_summary	object_type	int8	19
jivedw_invite	creation_ts	timestamp	29,6
jivedw_invite	email	varchar	100	√		null
jivedw_invite	invitation_id	int8	19
jivedw_invite	inviter_id	int8	19	√		null
jivedw_invite	modification_ts	timestamp	29,6
jivedw_invite	object_id	int8	19
jivedw_invite	object_type	int4	10
jivedw_invite	sent_ts	timestamp	29,6	√		null
jivedw_invite	state	int4	10
jivedw_invite	user_id	int8	19	√		null
jivedw_invite_stage	creation_ts	timestamp	29,6
jivedw_invite_stage	email	varchar	100	√		null
jivedw_invite_stage	invitation_id	int8	19
jivedw_invite_stage	inviter_id	int8	19	√		null
jivedw_invite_stage	modification_ts	timestamp	29,6
jivedw_invite_stage	object_id	int8	19
jivedw_invite_stage	object_type	int4	10
jivedw_invite_stage	sent_ts	timestamp	29,6	√		null
jivedw_invite_stage	state	int4	10
jivedw_invite_stage	user_id	int8	19	√		null
jivedw_message	container_id	int8	19
jivedw_message	container_type	int4	10
jivedw_message	creation_ts	timestamp	29,6
jivedw_message	message_id	int8	19
jivedw_message	modification_ts	timestamp	29,6
jivedw_message	parent_message_id	int8	19	√		null
jivedw_message	subject	varchar	255	√		null
jivedw_message	thread_id	int8	19
jivedw_message_stage	container_id	int8	19
jivedw_message_stage	container_type	int4	10
jivedw_message_stage	creation_ts	timestamp	29,6
jivedw_message_stage	message_id	int8	19
jivedw_message_stage	modification_ts	timestamp	29,6
jivedw_message_stage	parent_message_id	int8	19	√		null
jivedw_message_stage	subject	varchar	255	√		null
jivedw_message_stage	thread_id	int8	19
jivedw_month	begin_ts	timestamp	29,6
jivedw_month	end_ts	timestamp	29,6
jivedw_month	month_id	int8	19
jivedw_month	month_of_year	int4	10
jivedw_month	year	int4	10
jivedw_moved_objects	destination_container_id	int8	19
jivedw_moved_objects	destination_container_type	int4	10
jivedw_moved_objects	id	int8	19
jivedw_moved_objects	moved_ts	timestamp	29,6
jivedw_moved_objects	object_id	int8	19
jivedw_moved_objects	object_type	int4	10
jivedw_moved_objects	source_container_id	int8	19
jivedw_moved_objects	source_container_type	int4	10
jivedw_moved_objects_stage	destination_container_id	int8	19
jivedw_moved_objects_stage	destination_container_type	int4	10
jivedw_moved_objects_stage	id	int8	19
jivedw_moved_objects_stage	moved_ts	timestamp	29,6
jivedw_moved_objects_stage	object_id	int8	19
jivedw_moved_objects_stage	object_type	int4	10
jivedw_moved_objects_stage	source_container_id	int8	19
jivedw_moved_objects_stage	source_container_type	int4	10
jivedw_obj_cnt	cnt	int4	10
jivedw_obj_cnt	id	int4	10
jivedw_obj_cnt	session_id	int8	19
jivedw_object	creation_ts	timestamp	29,6
jivedw_object	dw_object_id	int8	19
jivedw_object	modification_ts	timestamp	29,6
jivedw_object	name	varchar	255	√		null
jivedw_object	object_id	int8	19
jivedw_object	object_type	int4	10
jivedw_object_meta	object_name	varchar	100
jivedw_object_meta	object_type	int4	10
jivedw_object_status	object_id	int8	19
jivedw_object_status	object_type	int4	10
jivedw_object_status	status	int4	10
jivedw_object_status	status_ts	timestamp	29,6
jivedw_object_status_stage	object_id	int8	19
jivedw_object_status_stage	object_type	int4	10
jivedw_object_status_stage	status	int4	10
jivedw_object_status_stage	status_ts	timestamp	29,6
jivedw_object_user	object_id	int8	19
jivedw_object_user	object_type	int4	10
jivedw_object_user	user_id	int8	19
jivedw_object_user_stage	object_id	int8	19
jivedw_object_user_stage	object_type	int4	10
jivedw_object_user_stage	user_id	int8	19
jivedw_participant	content_id	int8	19
jivedw_participant	content_type	int8	19
jivedw_participant	meta_info	text	2147483647	√		null
jivedw_participant	modification_ts	timestamp	29,6
jivedw_participant	participant	text	2147483647	√		null
jivedw_participant	total_participant	int8	19
jivedw_places_summary	bookmark_count	int4	10
jivedw_places_summary	container_id	int8	19
jivedw_places_summary	container_type	int4	10
jivedw_places_summary	create_count	int4	10
jivedw_places_summary	day_ts	timestamp	29,6
jivedw_places_summary	follow_count	int4	10
jivedw_places_summary	like_count	int4	10
jivedw_places_summary	mention_count	int4	10
jivedw_places_summary	modify_count	int4	10
jivedw_places_summary	rate_count	int4	10
jivedw_places_summary	response_count	int4	10
jivedw_places_summary	user_id	int8	19
jivedw_places_summary	username	varchar	100
jivedw_places_summary	view_count	int4	10
jivedw_places_u_summary	bookmark_count	int4	10
jivedw_places_u_summary	container_id	int8	19
jivedw_places_u_summary	container_type	int4	10
jivedw_places_u_summary	create_count	int4	10
jivedw_places_u_summary	day_ts	timestamp	29,6
jivedw_places_u_summary	follow_count	int4	10
jivedw_places_u_summary	like_count	int4	10
jivedw_places_u_summary	mention_count	int4	10
jivedw_places_u_summary	modify_count	int4	10
jivedw_places_u_summary	rate_count	int4	10
jivedw_places_u_summary	response_count	int4	10
jivedw_places_u_summary	view_count	int4	10
jivedw_poll	creation_ts	timestamp	29,6
jivedw_poll	modification_ts	timestamp	29,6
jivedw_poll	name	varchar	255
jivedw_poll	object_id	int8	19
jivedw_poll	object_type	int4	10
jivedw_poll	poll_id	int8	19
jivedw_poll	status	int4	10
jivedw_poll	user_id	int8	19	√		null
jivedw_poll_stage	creation_ts	timestamp	29,6
jivedw_poll_stage	modification_ts	timestamp	29,6
jivedw_poll_stage	name	varchar	255
jivedw_poll_stage	object_id	int8	19
jivedw_poll_stage	object_type	int4	10
jivedw_poll_stage	poll_id	int8	19
jivedw_poll_stage	status	int4	10
jivedw_poll_stage	user_id	int8	19	√		null
jivedw_profilefield	field_id	int8	19
jivedw_profilefield	is_editable	int2	5
jivedw_profilefield	is_filterable	int2	5
jivedw_profilefield	is_required	int2	5
jivedw_profilefield	is_searchable	int2	5
jivedw_profilefield	is_visible_to_guests	int2	5
jivedw_profilefield	is_visible_to_users	int2	5
jivedw_profilefield	name	varchar	255
jivedw_profilefield	pseudo	int2	5			0
jivedw_profilefield_stage	field_id	int8	19
jivedw_profilefield_stage	is_editable	int2	5
jivedw_profilefield_stage	is_filterable	int2	5
jivedw_profilefield_stage	is_required	int2	5
jivedw_profilefield_stage	is_searchable	int2	5
jivedw_profilefield_stage	is_visible_to_guests	int2	5
jivedw_profilefield_stage	is_visible_to_users	int2	5
jivedw_profilefield_stage	name	varchar	255
jivedw_profilefield_stage	pseudo	int2	5			0
jivedw_project	creation_ts	timestamp	29,6
jivedw_project	due_date_null	int4	10
jivedw_project	due_ts	timestamp	29,6	√		null
jivedw_project	latest_status_id	int8	19	√		null
jivedw_project	modification_ts	timestamp	29,6
jivedw_project	parent_object_id	int8	19
jivedw_project	parent_object_type	int4	10
jivedw_project	project_id	int8	19
jivedw_project	start_ts	timestamp	29,6
jivedw_project	status	int4	10
jivedw_project	user_id	int8	19
jivedw_project_stage	creation_ts	timestamp	29,6
jivedw_project_stage	due_date_null	int4	10
jivedw_project_stage	due_ts	timestamp	29,6	√		null
jivedw_project_stage	latest_status_id	int8	19	√		null
jivedw_project_stage	modification_ts	timestamp	29,6
jivedw_project_stage	parent_object_id	int8	19
jivedw_project_stage	parent_object_type	int4	10
jivedw_project_stage	project_id	int8	19
jivedw_project_stage	start_ts	timestamp	29,6
jivedw_project_stage	status	int4	10
jivedw_project_stage	user_id	int8	19
jivedw_question	container_id	int8	19
jivedw_question	container_type	int8	19
jivedw_question	creation_ts	timestamp	29,6
jivedw_question	resolution_state	int4	10
jivedw_question	resolution_ts	timestamp	29,6	√		null
jivedw_question	thread_id	int8	19
jivedw_question	user_id	int8	19
jivedw_question_stage	container_id	int8	19
jivedw_question_stage	container_type	int8	19
jivedw_question_stage	creation_ts	timestamp	29,6
jivedw_question_stage	resolution_state	int4	10
jivedw_question_stage	resolution_ts	timestamp	29,6	√		null
jivedw_question_stage	thread_id	int8	19
jivedw_question_stage	user_id	int8	19
jivedw_question_summary	container_id	int8	19
jivedw_question_summary	container_type	int4	10
jivedw_question_summary	creation_ts	timestamp	29,6
jivedw_question_summary	helped_ts	timestamp	29,6	√		null
jivedw_question_summary	question_id	int8	19
jivedw_question_summary	resolved_ts	timestamp	29,6	√		null
jivedw_question_summary	responded_ts	timestamp	29,6	√		null
jivedw_question_summary	user_id	int8	19
jivedw_reachable_user	modification_ts	timestamp	29,6
jivedw_reachable_user	total	int8	19			0
jivedw_sgroup	creation_ts	timestamp	29,6
jivedw_sgroup	group_id	int8	19
jivedw_sgroup	group_type	int4	10
jivedw_sgroup	modification_ts	timestamp	29,6
jivedw_sgroup	name	varchar	255
jivedw_sgroup_stage	creation_ts	timestamp	29,6
jivedw_sgroup_stage	group_id	int8	19
jivedw_sgroup_stage	group_type	int4	10
jivedw_sgroup_stage	modification_ts	timestamp	29,6
jivedw_sgroup_stage	name	varchar	255
jivedw_statuslevelpnt	container_id	int8	19
jivedw_statuslevelpnt	container_type	int4	10
jivedw_statuslevelpnt	creation_ts	timestamp	29,6
jivedw_statuslevelpnt	object_id	int8	19
jivedw_statuslevelpnt	object_type	int4	10
jivedw_statuslevelpnt	point_id	int8	19
jivedw_statuslevelpnt	points	int8	19
jivedw_statuslevelpnt	user_id	int8	19
jivedw_statuslevelpnt_stage	container_id	int8	19
jivedw_statuslevelpnt_stage	container_type	int8	19
jivedw_statuslevelpnt_stage	creation_ts	timestamp	29,6
jivedw_statuslevelpnt_stage	object_id	int8	19
jivedw_statuslevelpnt_stage	object_type	int4	10
jivedw_statuslevelpnt_stage	point_id	int8	19
jivedw_statuslevelpnt_stage	points	int8	19
jivedw_statuslevelpnt_stage	user_id	int8	19
jivedw_summary_stats	chart_key	varchar	100
jivedw_summary_stats	last_summarized_date	varchar	10	√		null
jivedw_summary_stats	summation_duration	int8	19	√		null
jivedw_tag	creation_ts	timestamp	29,6
jivedw_tag	name	varchar	100
jivedw_tag	tag_id	int8	19
jivedw_tag_stage	creation_ts	timestamp	29,6
jivedw_tag_stage	name	varchar	100
jivedw_tag_stage	tag_id	int8	19
jivedw_temp_user	session_id	int8	19
jivedw_temp_user	user_id	int8	19
jivedw_thread	container_id	int8	19			'-2'::integer
jivedw_thread	container_type	int4	10			17
jivedw_thread	creation_ts	timestamp	29,6
jivedw_thread	modification_ts	timestamp	29,6
jivedw_thread	status	int4	10
jivedw_thread	thread_id	int8	19
jivedw_thread_stage	container_id	int8	19			'-2'::integer
jivedw_thread_stage	container_type	int4	10			17
jivedw_thread_stage	creation_ts	timestamp	29,6
jivedw_thread_stage	modification_ts	timestamp	29,6
jivedw_thread_stage	status	int4	10
jivedw_thread_stage	thread_id	int8	19
jivedw_user	creation_ts	timestamp	29,6
jivedw_user	email	varchar	100	√		null
jivedw_user	firstname	varchar	100	√		null
jivedw_user	initlogin_ts	timestamp	29,6	√		null
jivedw_user	last_logged_in	timestamp	29,6
jivedw_user	lastname	varchar	100	√		null
jivedw_user	modification_ts	timestamp	29,6
jivedw_user	name	varchar	100	√		null
jivedw_user	user_id	int8	19
jivedw_user	userenabled	int4	10
jivedw_user	username	varchar	100
jivedw_user_init_summary	day_ts	timestamp	29,6
jivedw_user_init_summary	state	int4	10
jivedw_user_init_summary	user_id	int8	19
jivedw_user_points_summary	container_id	int8	19
jivedw_user_points_summary	container_type	int4	10
jivedw_user_points_summary	day_ts	timestamp	29,6
jivedw_user_points_summary	points	int4	10
jivedw_user_points_summary	user_id	int8	19
jivedw_user_points_summary	username	varchar	100
jivedw_user_rel	creation_ts	timestamp	29,6
jivedw_user_rel	graph_id	int8	19
jivedw_user_rel	modification_ts	timestamp	29,6
jivedw_user_rel	related_user_id	int8	19
jivedw_user_rel	relationship_id	int8	19
jivedw_user_rel	relnship_type_id	int4	10
jivedw_user_rel	retirement_ts	timestamp	29,6	√		null
jivedw_user_rel	state	varchar	20			'pending_approval'::character varying
jivedw_user_rel	user_id	int8	19
jivedw_user_rel_stage	creation_ts	timestamp	29,6
jivedw_user_rel_stage	graph_id	int8	19
jivedw_user_rel_stage	modification_ts	timestamp	29,6
jivedw_user_rel_stage	related_user_id	int8	19
jivedw_user_rel_stage	relationship_id	int8	19
jivedw_user_rel_stage	relnship_type_id	int4	10
jivedw_user_rel_stage	retirement_ts	timestamp	29,6	√		null
jivedw_user_rel_stage	state	varchar	20			'pending_approval'::character varying
jivedw_user_rel_stage	user_id	int8	19
jivedw_user_stage	creation_ts	timestamp	29,6
jivedw_user_stage	email	varchar	100	√		null
jivedw_user_stage	firstname	varchar	100	√		null
jivedw_user_stage	last_logged_in	timestamp	29,6
jivedw_user_stage	lastname	varchar	100	√		null
jivedw_user_stage	modification_ts	timestamp	29,6
jivedw_user_stage	name	varchar	100	√		null
jivedw_user_stage	user_id	int8	19
jivedw_user_stage	userenabled	int4	10
jivedw_user_stage	username	varchar	100
jivedw_user_status	container_id	int8	19			'-1'::integer
jivedw_user_status	container_type	int4	10			'-1'::integer
jivedw_user_status	creation_ts	timestamp	29,6
jivedw_user_status	modification_ts	timestamp	29,6
jivedw_user_status	status	int4	10			2
jivedw_user_status	status_type	int4	10			0
jivedw_user_status	user_id	int8	19
jivedw_user_status	user_status_id	int8	19
jivedw_user_status_stage	container_id	int8	19			'-1'::integer
jivedw_user_status_stage	container_type	int4	10			'-1'::integer
jivedw_user_status_stage	creation_ts	timestamp	29,6
jivedw_user_status_stage	modification_ts	timestamp	29,6
jivedw_user_status_stage	status	int4	10			2
jivedw_user_status_stage	status_type	int4	10			0
jivedw_user_status_stage	user_id	int8	19
jivedw_user_status_stage	user_status_id	int8	19
jivedw_user_summary	day_ts	timestamp	29,6
jivedw_user_summary	state	int4	10
jivedw_user_summary	user_id	int8	19
jivedw_user_type	external	int4	10			0
jivedw_user_type	user_id	int8	19
jivedw_user_type	visible	int4	10			1
jivedw_user_type_stage	external	int4	10			0
jivedw_user_type_stage	user_id	int8	19
jivedw_user_type_stage	visible	int4	10			1
jivedw_userprofile	field_id	int8	19
jivedw_userprofile	primaryval	int2	5
jivedw_userprofile	user_id	int8	19
jivedw_userprofile	userprofile_id	int8	19
jivedw_userprofile	value	varchar	3500	√		null
jivedw_userprofile_clear_stage	user_id	int8	19
jivedw_userprofile_stage	field_id	int8	19
jivedw_userprofile_stage	primaryval	int2	5
jivedw_userprofile_stage	user_id	int8	19
jivedw_userprofile_stage	userprofile_id	int8	19
jivedw_userprofile_stage	value	varchar	3500	√		null
jivedw_users_glb_summary	day_ts	timestamp	29,6
jivedw_users_glb_summary	points	int4	10
jivedw_users_glb_summary	user_id	int8	19
jivedw_users_glb_summary	username	varchar	100
jivedw_users_grp_summary	container_id	int8	19
jivedw_users_grp_summary	day_ts	timestamp	29,6
jivedw_users_grp_summary	points	int4	10
jivedw_users_grp_summary	user_id	int8	19
jivedw_users_grp_summary	username	varchar	100
jivedw_users_spc_summary	container_id	int8	19
jivedw_users_spc_summary	day_ts	timestamp	29,6
jivedw_users_spc_summary	points	int4	10
jivedw_users_spc_summary	user_id	int8	19
jivedw_users_spc_summary	username	varchar	100
jivedw_version	name	varchar	50
jivedw_version	version	int4	10
jivedw_video	container_id	int8	19
jivedw_video	container_type	int4	10
jivedw_video	creation_ts	timestamp	29,6
jivedw_video	modification_ts	timestamp	29,6
jivedw_video	status	int4	10			0
jivedw_video	user_id	int8	19
jivedw_video	video_id	int8	19
jivedw_video_stage	container_id	int8	19
jivedw_video_stage	container_type	int4	10
jivedw_video_stage	creation_ts	timestamp	29,6
jivedw_video_stage	modification_ts	timestamp	29,6
jivedw_video_stage	status	int4	10			0
jivedw_video_stage	user_id	int8	19
jivedw_video_stage	video_id	int8	19
jivedw_week	begin_ts	timestamp	29,6
jivedw_week	end_ts	timestamp	29,6
jivedw_week	week_id	int8	19
jivedw_week	week_of_year	int4	10
jivedw_week	year	int4	10
tshtst	testfield	int4	10	√		null