testdb.public contains 747 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
act_hi_actinst	act_id_	varchar	255
act_hi_decinst	act_id_	varchar	255	√		null
act_hi_ext_task_log	act_id_	varchar	255	√		null
act_hi_job_log	act_id_	varchar	255	√		null
act_ru_case_execution	act_id_	varchar	255	√		null
act_ru_execution	act_id_	varchar	255	√		null
act_ru_ext_task	act_id_	varchar	255	√		null
act_ru_jobdef	act_id_	varchar	255	√		null
act_hi_decinst	act_inst_id_	varchar	64	√		null
act_hi_detail	act_inst_id_	varchar	64	√		null
act_hi_ext_task_log	act_inst_id_	varchar	64	√		null
act_hi_taskinst	act_inst_id_	varchar	64	√		null
act_hi_varinst	act_inst_id_	varchar	64	√		null
act_ru_execution	act_inst_id_	varchar	64	√		null
act_ru_ext_task	act_inst_id_	varchar	64	√		null
act_hi_actinst	act_inst_state_	int4	10	√		null
act_hi_actinst	act_name_	varchar	255	√		null
act_hi_actinst	act_type_	varchar	255
act_hi_comment	action_	varchar	255	√		null
act_hi_incident	activity_id_	varchar	255	√		null
act_ru_event_subscr	activity_id_	varchar	255	√		null
act_ru_incident	activity_id_	varchar	255	√		null
act_hi_incident	annotation_	varchar	4000	√		null
act_hi_op_log	annotation_	varchar	4000	√		null
act_ru_incident	annotation_	varchar	4000	√		null
act_hi_actinst	assignee_	varchar	255	√		null
act_hi_taskinst	assignee_	varchar	255	√		null
act_ru_task	assignee_	varchar	255	√		null
act_ru_task_meter_log	assignee_hash_	int8	19	√		null
act_hi_identitylink	assigner_id_	varchar	64	√		null
act_id_user	attempts_	int4	10	√		null
act_hi_job_log	batch_id_	varchar	64	√		null
act_hi_op_log	batch_id_	varchar	64	√		null
act_ru_job	batch_id_	varchar	64	√		null
act_ru_variable	batch_id_	varchar	64	√		null
act_hi_batch	batch_job_def_id_	varchar	64	√		null
act_ru_batch	batch_job_def_id_	varchar	64	√		null
act_hi_caseinst	business_key_	varchar	255	√		null
act_hi_procinst	business_key_	varchar	255	√		null
act_ru_case_execution	business_key_	varchar	255	√		null
act_ru_execution	business_key_	varchar	255	√		null
act_hi_dec_in	bytearray_id_	varchar	64	√		null
act_hi_dec_out	bytearray_id_	varchar	64	√		null
act_hi_detail	bytearray_id_	varchar	64	√		null
act_hi_varinst	bytearray_id_	varchar	64	√		null
act_ru_variable	bytearray_id_	varchar	64	√		null
act_ge_bytearray	bytes_	bytea	2147483647	√		null
tms_rsrv_action	c_action_type	varchar	255
tms_rsrv_action	c_created	timestamp	29,6	√		null
tms_rsrv_location	c_created	timestamp	29,6	√		null
tms_rsrv_route	c_created	timestamp	29,6	√		null
tms_rsrv_route_details	c_created	timestamp	29,6	√		null
tms_rsrv_timer_config	c_created	timestamp	29,6	√		null
tms_rsrv_action	c_created_by	varchar	255	√		null
tms_rsrv_location	c_created_by	varchar	255	√		null
tms_rsrv_route	c_created_by	varchar	255	√		null
tms_rsrv_route_details	c_created_by	varchar	255	√		null
tms_rsrv_timer_config	c_created_by	varchar	255	√		null
tms_rsrv_timer_config	c_cron_expression	varchar	255	√		null
tms_rsrv_action	c_description	varchar	255
tms_rsrv_route	c_description	varchar	255	√		null
tms_rsrv_timer_config	c_description	varchar	255	√		null
tms_rsrv_action	c_enabled	bool	1	√		null
tms_rsrv_route	c_enabled	bool	1	√		null
tms_rsrv_action	c_flex_1	varchar	255	√		null
tms_rsrv_action	c_flex_2	varchar	255	√		null
tms_rsrv_action	c_flex_3	varchar	255	√		null
tms_rsrv_action	c_flex_4	varchar	255	√		null
tms_rsrv_action	c_flex_5	varchar	255	√		null
tms_rsrv_location	c_foreign_pid	varchar	255	√		null
tms_rsrv_timer_config_vars	c_key	varchar	255
tms_rsrv_action	c_location_group_name	varchar	255	√		null
tms_rsrv_location	c_location_group_name	varchar	255	√		null
tms_rsrv_location	c_location_id	varchar	255
tms_rsrv_action	c_location_key	varchar	255	√		null
tms_rsrv_location	c_marked_deletion	bool	1	√		null
tms_rsrv_action	c_name	varchar	255
tms_rsrv_route	c_name	varchar	255
tms_rsrv_timer_config	c_name	varchar	255	√		null
tms_rsrv_route_details	c_next_location	varchar	255	√		null
tms_rsrv_action	c_ol	int8	19	√		null
tms_rsrv_location	c_ol	int8	19	√		null
tms_rsrv_route	c_ol	int8	19	√		null
tms_rsrv_route_details	c_ol	int8	19	√		null
tms_rsrv_timer_config	c_ol	int8	19	√		null
tms_rsrv_action	c_pid	varchar	255
tms_rsrv_location	c_pid	varchar	255
tms_rsrv_route	c_pid	varchar	255
tms_rsrv_timer_config	c_pid	varchar	255
tms_rsrv_action	c_pk	int8	19
tms_rsrv_location	c_pk	int8	19
tms_rsrv_route	c_pk	int8	19
tms_rsrv_route_details	c_pk	int8	19
tms_rsrv_timer_config	c_pk	int8	19
tms_rsrv_route_details	c_pos	int4	10	√		null
tms_rsrv_action	c_program_name	varchar	255
tms_rsrv_action	c_route_id	int8	19
tms_rsrv_route_details	c_route_id	int8	19	√		null
tms_rsrv_route	c_source_loc_group_name	varchar	255	√		null
tms_rsrv_route	c_source_location	int8	19	√		null
tms_rsrv_route_details	c_source_location	varchar	255	√		null
tms_rsrv_route	c_target_loc_group_name	varchar	255	√		null
tms_rsrv_route	c_target_location	int8	19	√		null
tms_rsrv_timer_config_vars	c_tc_pk	int8	19
tms_rsrv_action	c_updated	timestamp	29,6	√		null
tms_rsrv_location	c_updated	timestamp	29,6	√		null
tms_rsrv_route	c_updated	timestamp	29,6	√		null
tms_rsrv_route_details	c_updated	timestamp	29,6	√		null
tms_rsrv_timer_config	c_updated	timestamp	29,6	√		null
tms_rsrv_action	c_updated_by	varchar	255	√		null
tms_rsrv_location	c_updated_by	varchar	255	√		null
tms_rsrv_route	c_updated_by	varchar	255	√		null
tms_rsrv_route_details	c_updated_by	varchar	255	√		null
tms_rsrv_timer_config	c_updated_by	varchar	255	√		null
tms_rsrv_timer_config_vars	c_value	varchar	255	√		null
act_ru_execution	cached_ent_state_	int4	10	√		null
act_hi_actinst	call_case_inst_id_	varchar	64	√		null
act_hi_caseactinst	call_case_inst_id_	varchar	64	√		null
act_hi_actinst	call_proc_inst_id_	varchar	64	√		null
act_hi_caseactinst	call_proc_inst_id_	varchar	64	√		null
act_hi_caseactinst	case_act_id_	varchar	255
act_hi_caseactinst	case_act_name_	varchar	255	√		null
act_hi_caseactinst	case_act_type_	varchar	255	√		null
act_hi_caseactinst	case_def_id_	varchar	64
act_hi_caseinst	case_def_id_	varchar	64
act_hi_decinst	case_def_id_	varchar	64	√		null
act_hi_detail	case_def_id_	varchar	64	√		null
act_hi_op_log	case_def_id_	varchar	64	√		null
act_hi_taskinst	case_def_id_	varchar	64	√		null
act_hi_varinst	case_def_id_	varchar	64	√		null
act_ru_case_execution	case_def_id_	varchar	64	√		null
act_ru_task	case_def_id_	varchar	64	√		null
act_hi_decinst	case_def_key_	varchar	255	√		null
act_hi_detail	case_def_key_	varchar	255	√		null
act_hi_taskinst	case_def_key_	varchar	255	√		null
act_hi_varinst	case_def_key_	varchar	255	√		null
act_ru_case_sentry_part	case_exec_id_	varchar	64	√		null
act_hi_detail	case_execution_id_	varchar	64	√		null
act_hi_op_log	case_execution_id_	varchar	64	√		null
act_hi_taskinst	case_execution_id_	varchar	64	√		null
act_hi_varinst	case_execution_id_	varchar	64	√		null
act_ru_task	case_execution_id_	varchar	64	√		null
act_ru_variable	case_execution_id_	varchar	64	√		null
act_hi_caseactinst	case_inst_id_	varchar	64
act_hi_caseinst	case_inst_id_	varchar	64
act_hi_decinst	case_inst_id_	varchar	64	√		null
act_hi_detail	case_inst_id_	varchar	64	√		null
act_hi_op_log	case_inst_id_	varchar	64	√		null
act_hi_procinst	case_inst_id_	varchar	64	√		null
act_hi_taskinst	case_inst_id_	varchar	64	√		null
act_hi_varinst	case_inst_id_	varchar	64	√		null
act_ru_case_execution	case_inst_id_	varchar	64	√		null
act_ru_case_sentry_part	case_inst_id_	varchar	64	√		null
act_ru_execution	case_inst_id_	varchar	64	√		null
act_ru_task	case_inst_id_	varchar	64	√		null
act_ru_variable	case_inst_id_	varchar	64	√		null
act_hi_op_log	category_	varchar	64	√		null
act_re_case_def	category_	varchar	255	√		null
act_re_decision_def	category_	varchar	255	√		null
act_re_decision_req_def	category_	varchar	255	√		null
act_re_procdef	category_	varchar	255	√		null
act_hi_incident	cause_incident_id_	varchar	64	√		null
act_ru_incident	cause_incident_id_	varchar	64	√		null
act_hi_dec_in	clause_id_	varchar	64	√		null
act_hi_dec_out	clause_id_	varchar	64	√		null
act_hi_dec_in	clause_name_	varchar	255	√		null
act_hi_dec_out	clause_name_	varchar	255	√		null
act_hi_caseinst	close_time_	timestamp	29,6	√		null
act_hi_decinst	collect_value_	float8	17,17	√		null
act_hi_incident	configuration_	varchar	255	√		null
act_ru_batch	configuration_	varchar	255	√		null
act_ru_event_subscr	configuration_	varchar	255	√		null
act_ru_incident	configuration_	varchar	255	√		null
act_hi_attachment	content_id_	varchar	64	√		null
act_ge_bytearray	create_time_	timestamp	29,6	√		null
act_hi_attachment	create_time_	timestamp	29,6	√		null
act_hi_caseactinst	create_time_	timestamp	29,6
act_hi_caseinst	create_time_	timestamp	29,6
act_hi_dec_in	create_time_	timestamp	29,6	√		null
act_hi_dec_out	create_time_	timestamp	29,6	√		null
act_hi_incident	create_time_	timestamp	29,6
act_hi_varinst	create_time_	timestamp	29,6	√		null
act_ru_ext_task	create_time_	timestamp	29,6	√		null
act_ru_job	create_time_	timestamp	29,6	√		null
act_ru_task	create_time_	timestamp	29,6	√		null
act_hi_batch	create_user_id_	varchar	255	√		null
act_hi_caseinst	create_user_id_	varchar	255	√		null
act_ru_batch	create_user_id_	varchar	255	√		null
act_ru_event_subscr	created_	timestamp	29,6
act_ru_case_execution	current_state_	int4	10	√		null
act_hi_decinst	dec_def_id_	varchar	64
act_hi_decinst	dec_def_key_	varchar	255
act_hi_decinst	dec_def_name_	varchar	255	√		null
act_hi_dec_in	dec_inst_id_	varchar	64
act_hi_dec_out	dec_inst_id_	varchar	64
act_hi_decinst	dec_req_id_	varchar	64	√		null
act_re_decision_def	dec_req_id_	varchar	64	√		null
act_hi_decinst	dec_req_key_	varchar	255	√		null
act_re_decision_def	dec_req_key_	varchar	255	√		null
act_ru_task	delegation_	varchar	64	√		null
act_hi_procinst	delete_reason_	varchar	4000	√		null
act_hi_taskinst	delete_reason_	varchar	4000	√		null
act_re_deployment	deploy_time_	timestamp	29,6	√		null
act_ge_bytearray	deployment_id_	varchar	64	√		null
act_hi_job_log	deployment_id_	varchar	64	√		null
act_hi_op_log	deployment_id_	varchar	64	√		null
act_re_camformdef	deployment_id_	varchar	64	√		null
act_re_case_def	deployment_id_	varchar	64	√		null
act_re_decision_def	deployment_id_	varchar	64	√		null
act_re_decision_req_def	deployment_id_	varchar	64	√		null
act_re_procdef	deployment_id_	varchar	64	√		null
act_ru_job	deployment_id_	varchar	64	√		null
act_ru_jobdef	deployment_id_	varchar	64	√		null
act_hi_attachment	description_	varchar	4000	√		null
act_hi_taskinst	description_	varchar	4000	√		null
act_ru_task	description_	varchar	4000	√		null
act_re_case_def	dgrm_resource_name_	varchar	4000	√		null
act_re_decision_def	dgrm_resource_name_	varchar	4000	√		null
act_re_decision_req_def	dgrm_resource_name_	varchar	4000	√		null
act_re_procdef	dgrm_resource_name_	varchar	4000	√		null
act_hi_dec_in	double_	float8	17,17	√		null
act_hi_dec_out	double_	float8	17,17	√		null
act_hi_detail	double_	float8	17,17	√		null
act_hi_varinst	double_	float8	17,17	√		null
act_ru_variable	double_	float8	17,17	√		null
act_hi_taskinst	due_date_	timestamp	29,6	√		null
act_ru_task	due_date_	timestamp	29,6	√		null
act_ru_job	duedate_	timestamp	29,6	√		null
act_hi_actinst	duration_	int8	19	√		null
act_hi_caseactinst	duration_	int8	19	√		null
act_hi_caseinst	duration_	int8	19	√		null
act_hi_procinst	duration_	int8	19	√		null
act_hi_taskinst	duration_	int8	19	√		null
act_id_user	email_	varchar	255	√		null
act_hi_procinst	end_act_id_	varchar	255	√		null
act_hi_actinst	end_time_	timestamp	29,6	√		null
act_hi_batch	end_time_	timestamp	29,6	√		null
act_hi_caseactinst	end_time_	timestamp	29,6	√		null
act_hi_incident	end_time_	timestamp	29,6	√		null
act_hi_procinst	end_time_	timestamp	29,6	√		null
act_hi_taskinst	end_time_	timestamp	29,6	√		null
act_hi_op_log	entity_type_	varchar	30	√		null
act_hi_ext_task_log	error_details_id_	varchar	64	√		null
act_ru_ext_task	error_details_id_	varchar	64	√		null
act_hi_ext_task_log	error_msg_	varchar	4000	√		null
act_ru_ext_task	error_msg_	varchar	4000	√		null
act_hi_decinst	eval_time_	timestamp	29,6
act_ru_event_subscr	event_name_	varchar	255	√		null
act_ru_event_subscr	event_type_	varchar	255
act_ru_job	exception_msg_	varchar	4000	√		null
act_ru_job	exception_stack_id_	varchar	64	√		null
act_ru_job	exclusive_	bool	1	√		null
act_hi_batch	exec_start_time_	timestamp	29,6	√		null
act_ru_batch	exec_start_time_	timestamp	29,6	√		null
act_hi_actinst	execution_id_	varchar	64
act_hi_detail	execution_id_	varchar	64	√		null
act_hi_ext_task_log	execution_id_	varchar	64	√		null
act_hi_incident	execution_id_	varchar	64	√		null
act_hi_job_log	execution_id_	varchar	64	√		null
act_hi_op_log	execution_id_	varchar	64	√		null
act_hi_taskinst	execution_id_	varchar	64	√		null
act_hi_varinst	execution_id_	varchar	64	√		null
act_ru_event_subscr	execution_id_	varchar	64	√		null
act_ru_ext_task	execution_id_	varchar	64	√		null
act_ru_incident	execution_id_	varchar	64	√		null
act_ru_job	execution_id_	varchar	64	√		null
act_ru_task	execution_id_	varchar	64	√		null
act_ru_variable	execution_id_	varchar	64	√		null
act_hi_ext_task_log	ext_task_id_	varchar	64
act_hi_op_log	external_task_id_	varchar	64	√		null
act_hi_job_log	failed_act_id_	varchar	255	√		null
act_ru_job	failed_act_id_	varchar	255	√		null
act_hi_incident	failed_activity_id_	varchar	255	√		null
act_ru_incident	failed_activity_id_	varchar	255	√		null
act_id_user	first_	varchar	255	√		null
act_hi_taskinst	follow_up_date_	timestamp	29,6	√		null
act_ru_task	follow_up_date_	timestamp	29,6	√		null
act_hi_comment	full_msg_	bytea	2147483647	√		null
act_ge_bytearray	generated_	bool	1	√		null
act_hi_identitylink	group_id_	varchar	255	√		null
act_id_membership	group_id_	varchar	64
act_id_tenant_member	group_id_	varchar	64	√		null
act_ru_authorization	group_id_	varchar	255	√		null
act_ru_identitylink	group_id_	varchar	255	√		null
act_ru_job	handler_cfg_	varchar	4000	√		null
act_ru_job	handler_type_	varchar	255	√		null
act_re_procdef	has_start_form_key_	bool	1	√		null
act_hi_incident	history_configuration_	varchar	255	√		null
act_re_case_def	history_ttl_	int4	10	√		null
act_re_decision_def	history_ttl_	int4	10	√		null
act_re_procdef	history_ttl_	int4	10	√		null
act_hi_job_log	hostname_	varchar	255	√		null
act_ge_bytearray	id_	varchar	64
act_ge_schema_log	id_	varchar	64
act_hi_actinst	id_	varchar	64
act_hi_attachment	id_	varchar	64
act_hi_batch	id_	varchar	64
act_hi_caseactinst	id_	varchar	64
act_hi_caseinst	id_	varchar	64
act_hi_comment	id_	varchar	64
act_hi_dec_in	id_	varchar	64
act_hi_dec_out	id_	varchar	64
act_hi_decinst	id_	varchar	64
act_hi_detail	id_	varchar	64
act_hi_ext_task_log	id_	varchar	64
act_hi_identitylink	id_	varchar	64
act_hi_incident	id_	varchar	64
act_hi_job_log	id_	varchar	64
act_hi_op_log	id_	varchar	64
act_hi_procinst	id_	varchar	64
act_hi_taskinst	id_	varchar	64
act_hi_varinst	id_	varchar	64
act_id_group	id_	varchar	64
act_id_info	id_	varchar	64
act_id_tenant	id_	varchar	64
act_id_tenant_member	id_	varchar	64
act_id_user	id_	varchar	64
act_re_camformdef	id_	varchar	64
act_re_case_def	id_	varchar	64
act_re_decision_def	id_	varchar	64
act_re_decision_req_def	id_	varchar	64
act_re_deployment	id_	varchar	64
act_re_procdef	id_	varchar	64
act_ru_authorization	id_	varchar	64
act_ru_batch	id_	varchar	64
act_ru_case_execution	id_	varchar	64
act_ru_case_sentry_part	id_	varchar	64
act_ru_event_subscr	id_	varchar	64
act_ru_execution	id_	varchar	64
act_ru_ext_task	id_	varchar	64
act_ru_filter	id_	varchar	64
act_ru_identitylink	id_	varchar	64
act_ru_incident	id_	varchar	64
act_ru_job	id_	varchar	64
act_ru_jobdef	id_	varchar	64
act_ru_meter_log	id_	varchar	64
act_ru_task	id_	varchar	64
act_ru_task_meter_log	id_	varchar	64
act_ru_variable	id_	varchar	64
act_hi_incident	incident_msg_	varchar	4000	√		null
act_ru_incident	incident_msg_	varchar	4000	√		null
act_hi_incident	incident_state_	int4	10	√		null
act_ru_incident	incident_timestamp_	timestamp	29,6
act_hi_incident	incident_type_	varchar	255
act_ru_incident	incident_type_	varchar	255
act_hi_detail	initial_	bool	1	√		null
act_hi_batch	invocations_per_job_	int4	10	√		null
act_ru_batch	invocations_per_job_	int4	10	√		null
act_ru_execution	is_active_	bool	1	√		null
act_ru_execution	is_concurrent_	bool	1	√		null
act_ru_variable	is_concurrent_local_	bool	1	√		null
act_ru_execution	is_event_scope_	bool	1	√		null
act_ru_execution	is_scope_	bool	1	√		null
act_ru_jobdef	job_configuration_	varchar	255	√		null
act_hi_job_log	job_def_configuration_	varchar	255	√		null
act_hi_incident	job_def_id_	varchar	64	√		null
act_hi_job_log	job_def_id_	varchar	64	√		null
act_hi_op_log	job_def_id_	varchar	64	√		null
act_ru_incident	job_def_id_	varchar	64	√		null
act_ru_job	job_def_id_	varchar	64	√		null
act_hi_job_log	job_def_type_	varchar	255	√		null
act_hi_job_log	job_duedate_	timestamp	29,6	√		null
act_hi_job_log	job_exception_msg_	varchar	4000	√		null
act_hi_job_log	job_exception_stack_id_	varchar	64	√		null
act_hi_job_log	job_id_	varchar	64
act_hi_op_log	job_id_	varchar	64	√		null
act_hi_job_log	job_priority_	int8	19			0
act_ru_jobdef	job_priority_	int8	19	√		null
act_hi_job_log	job_retries_	int4	10	√		null
act_hi_job_log	job_state_	int4	10	√		null
act_ru_jobdef	job_type_	varchar	255
act_ru_batch	jobs_created_	int4	10	√		null
act_hi_batch	jobs_per_seed_	int4	10	√		null
act_ru_batch	jobs_per_seed_	int4	10	√		null
act_id_info	key_	varchar	255	√		null
act_re_camformdef	key_	varchar	255
act_re_case_def	key_	varchar	255
act_re_decision_def	key_	varchar	255
act_re_decision_req_def	key_	varchar	255
act_re_procdef	key_	varchar	255
act_id_user	last_	varchar	255	√		null
act_ru_ext_task	last_failure_log_id_	varchar	64	√		null
act_ru_job	last_failure_log_id_	varchar	64	√		null
act_ru_task	last_updated_	timestamp	29,6	√		null
act_id_user	lock_exp_time_	timestamp	29,6	√		null
act_ru_ext_task	lock_exp_time_	timestamp	29,6	√		null
act_ru_job	lock_exp_time_	timestamp	29,6	√		null
act_ru_job	lock_owner_	varchar	255	√		null
act_hi_dec_in	long_	int8	19	√		null
act_hi_dec_out	long_	int8	19	√		null
act_hi_detail	long_	int8	19	√		null
act_hi_varinst	long_	int8	19	√		null
act_ru_variable	long_	int8	19	√		null
act_hi_comment	message_	varchar	4000	√		null
act_ru_meter_log	milliseconds_	int8	19	√		0
act_hi_batch	monitor_job_def_id_	varchar	64	√		null
act_ru_batch	monitor_job_def_id_	varchar	64	√		null
act_ge_bytearray	name_	varchar	255	√		null
act_ge_property	name_	varchar	64
act_hi_attachment	name_	varchar	255	√		null
act_hi_detail	name_	varchar	255
act_hi_taskinst	name_	varchar	255	√		null
act_hi_varinst	name_	varchar	255
act_id_group	name_	varchar	255	√		null
act_id_tenant	name_	varchar	255	√		null
act_re_case_def	name_	varchar	255	√		null
act_re_decision_def	name_	varchar	255	√		null
act_re_decision_req_def	name_	varchar	255	√		null
act_re_deployment	name_	varchar	255	√		null
act_re_procdef	name_	varchar	255	√		null
act_ru_filter	name_	varchar	255
act_ru_meter_log	name_	varchar	64
act_ru_task	name_	varchar	255	√		null
act_ru_variable	name_	varchar	255
act_hi_op_log	new_value_	varchar	4000	√		null
act_hi_detail	operation_id_	varchar	64	√		null
act_hi_op_log	operation_id_	varchar	64	√		null
act_hi_identitylink	operation_type_	varchar	64	√		null
act_hi_op_log	operation_type_	varchar	64	√		null
act_hi_op_log	org_value_	varchar	4000	√		null
act_hi_taskinst	owner_	varchar	255	√		null
act_ru_filter	owner_	varchar	255	√		null
act_ru_task	owner_	varchar	255	√		null
act_hi_actinst	parent_act_inst_id_	varchar	64	√		null
act_hi_caseactinst	parent_act_inst_id_	varchar	64	√		null
act_id_info	parent_id_	varchar	255	√		null
act_ru_case_execution	parent_id_	varchar	64	√		null
act_ru_execution	parent_id_	varchar	64	√		null
act_hi_taskinst	parent_task_id_	varchar	64	√		null
act_ru_task	parent_task_id_	varchar	64	√		null
act_id_info	password_	bytea	2147483647	√		null
act_ru_authorization	perms_	int4	10	√		null
act_id_user	picture_id_	varchar	64	√		null
act_ru_case_execution	prev_state_	int4	10	√		null
act_hi_ext_task_log	priority_	int8	19			0
act_hi_taskinst	priority_	int4	10	√		null
act_ru_ext_task	priority_	int8	19			0
act_ru_job	priority_	int8	19			0
act_ru_task	priority_	int4	10	√		null
act_hi_actinst	proc_def_id_	varchar	64
act_hi_decinst	proc_def_id_	varchar	64	√		null
act_hi_detail	proc_def_id_	varchar	64	√		null
act_hi_ext_task_log	proc_def_id_	varchar	64	√		null
act_hi_identitylink	proc_def_id_	varchar	64	√		null
act_hi_incident	proc_def_id_	varchar	64	√		null
act_hi_op_log	proc_def_id_	varchar	64	√		null
act_hi_procinst	proc_def_id_	varchar	64
act_hi_taskinst	proc_def_id_	varchar	64	√		null
act_hi_varinst	proc_def_id_	varchar	64	√		null
act_ru_execution	proc_def_id_	varchar	64	√		null
act_ru_ext_task	proc_def_id_	varchar	64	√		null
act_ru_identitylink	proc_def_id_	varchar	64	√		null
act_ru_incident	proc_def_id_	varchar	64	√		null
act_ru_jobdef	proc_def_id_	varchar	64	√		null
act_ru_task	proc_def_id_	varchar	64	√		null
act_ru_variable	proc_def_id_	varchar	64	√		null
act_hi_actinst	proc_def_key_	varchar	255	√		null
act_hi_decinst	proc_def_key_	varchar	255	√		null
act_hi_detail	proc_def_key_	varchar	255	√		null
act_hi_ext_task_log	proc_def_key_	varchar	255	√		null
act_hi_identitylink	proc_def_key_	varchar	255	√		null
act_hi_incident	proc_def_key_	varchar	255	√		null
act_hi_op_log	proc_def_key_	varchar	255	√		null
act_hi_procinst	proc_def_key_	varchar	255	√		null
act_hi_taskinst	proc_def_key_	varchar	255	√		null
act_hi_varinst	proc_def_key_	varchar	255	√		null
act_ru_ext_task	proc_def_key_	varchar	255	√		null
act_ru_jobdef	proc_def_key_	varchar	255	√		null
act_hi_actinst	proc_inst_id_	varchar	64
act_hi_attachment	proc_inst_id_	varchar	64	√		null
act_hi_comment	proc_inst_id_	varchar	64	√		null
act_hi_decinst	proc_inst_id_	varchar	64	√		null
act_hi_detail	proc_inst_id_	varchar	64	√		null
act_hi_ext_task_log	proc_inst_id_	varchar	64	√		null
act_hi_incident	proc_inst_id_	varchar	64	√		null
act_hi_op_log	proc_inst_id_	varchar	64	√		null
act_hi_procinst	proc_inst_id_	varchar	64
act_hi_taskinst	proc_inst_id_	varchar	64	√		null
act_hi_varinst	proc_inst_id_	varchar	64	√		null
act_ru_event_subscr	proc_inst_id_	varchar	64	√		null
act_ru_execution	proc_inst_id_	varchar	64	√		null
act_ru_ext_task	proc_inst_id_	varchar	64	√		null
act_ru_incident	proc_inst_id_	varchar	64	√		null
act_ru_task	proc_inst_id_	varchar	64	√		null
act_ru_variable	proc_inst_id_	varchar	64	√		null
act_hi_job_log	process_def_id_	varchar	64	√		null
act_ru_job	process_def_id_	varchar	64	√		null
act_hi_job_log	process_def_key_	varchar	255	√		null
act_ru_job	process_def_key_	varchar	255	√		null
act_hi_job_log	process_instance_id_	varchar	64	√		null
act_ru_job	process_instance_id_	varchar	64	√		null
act_ru_filter	properties_	text	2147483647	√		null
act_hi_op_log	property_	varchar	64	√		null
act_id_user	pwd_	varchar	255	√		null
act_ru_filter	query_	text	2147483647
act_ge_bytearray	removal_time_	timestamp	29,6	√		null
act_hi_actinst	removal_time_	timestamp	29,6	√		null
act_hi_attachment	removal_time_	timestamp	29,6	√		null
act_hi_batch	removal_time_	timestamp	29,6	√		null
act_hi_comment	removal_time_	timestamp	29,6	√		null
act_hi_dec_in	removal_time_	timestamp	29,6	√		null
act_hi_dec_out	removal_time_	timestamp	29,6	√		null
act_hi_decinst	removal_time_	timestamp	29,6	√		null
act_hi_detail	removal_time_	timestamp	29,6	√		null
act_hi_ext_task_log	removal_time_	timestamp	29,6	√		null
act_hi_identitylink	removal_time_	timestamp	29,6	√		null
act_hi_incident	removal_time_	timestamp	29,6	√		null
act_hi_job_log	removal_time_	timestamp	29,6	√		null
act_hi_op_log	removal_time_	timestamp	29,6	√		null
act_hi_procinst	removal_time_	timestamp	29,6	√		null
act_hi_taskinst	removal_time_	timestamp	29,6	√		null
act_hi_varinst	removal_time_	timestamp	29,6	√		null
act_ru_authorization	removal_time_	timestamp	29,6	√		null
act_ru_job	repeat_	varchar	255	√		null
act_ru_job	repeat_offset_	int8	19	√		0
act_ru_meter_log	reporter_	varchar	255	√		null
act_hi_caseactinst	required_	bool	1	√		null
act_ru_case_execution	required_	bool	1	√		null
act_ru_authorization	resource_id_	varchar	255	√		null
act_re_camformdef	resource_name_	varchar	4000	√		null
act_re_case_def	resource_name_	varchar	4000	√		null
act_re_decision_def	resource_name_	varchar	4000	√		null
act_re_decision_req_def	resource_name_	varchar	4000	√		null
act_re_procdef	resource_name_	varchar	4000	√		null
act_ru_authorization	resource_type_	int4	10
act_ru_filter	resource_type_	varchar	255
act_hi_procinst	restarted_proc_inst_id_	varchar	64	√		null
act_hi_ext_task_log	retries_	int4	10	√		null
act_ru_ext_task	retries_	int4	10	√		null
act_ru_job	retries_	int4	10	√		null
act_ge_bytearray	rev_	int4	10	√		null
act_ge_property	rev_	int4	10	√		null
act_hi_attachment	rev_	int4	10	√		null
act_hi_detail	rev_	int4	10	√		null
act_hi_varinst	rev_	int4	10	√		null
act_id_group	rev_	int4	10	√		null
act_id_info	rev_	int4	10	√		null
act_id_tenant	rev_	int4	10	√		null
act_id_user	rev_	int4	10	√		null
act_re_camformdef	rev_	int4	10	√		null
act_re_case_def	rev_	int4	10	√		null
act_re_decision_def	rev_	int4	10	√		null
act_re_decision_req_def	rev_	int4	10	√		null
act_re_procdef	rev_	int4	10	√		null
act_ru_authorization	rev_	int4	10
act_ru_batch	rev_	int4	10
act_ru_case_execution	rev_	int4	10	√		null
act_ru_case_sentry_part	rev_	int4	10	√		null
act_ru_event_subscr	rev_	int4	10	√		null
act_ru_execution	rev_	int4	10	√		null
act_ru_ext_task	rev_	int4	10
act_ru_filter	rev_	int4	10
act_ru_identitylink	rev_	int4	10	√		null
act_ru_incident	rev_	int4	10
act_ru_job	rev_	int4	10	√		null
act_ru_jobdef	rev_	int4	10	√		null
act_ru_task	rev_	int4	10	√		null
act_ru_variable	rev_	int4	10	√		null
act_hi_incident	root_cause_incident_id_	varchar	64	√		null
act_ru_incident	root_cause_incident_id_	varchar	64	√		null
act_hi_decinst	root_dec_inst_id_	varchar	64	√		null
act_ge_bytearray	root_proc_inst_id_	varchar	64	√		null
act_hi_actinst	root_proc_inst_id_	varchar	64	√		null
act_hi_attachment	root_proc_inst_id_	varchar	64	√		null
act_hi_comment	root_proc_inst_id_	varchar	64	√		null
act_hi_dec_in	root_proc_inst_id_	varchar	64	√		null
act_hi_dec_out	root_proc_inst_id_	varchar	64	√		null
act_hi_decinst	root_proc_inst_id_	varchar	64	√		null
act_hi_detail	root_proc_inst_id_	varchar	64	√		null
act_hi_ext_task_log	root_proc_inst_id_	varchar	64	√		null
act_hi_identitylink	root_proc_inst_id_	varchar	64	√		null
act_hi_incident	root_proc_inst_id_	varchar	64	√		null
act_hi_job_log	root_proc_inst_id_	varchar	64	√		null
act_hi_op_log	root_proc_inst_id_	varchar	64	√		null
act_hi_procinst	root_proc_inst_id_	varchar	64	√		null
act_hi_taskinst	root_proc_inst_id_	varchar	64	√		null
act_hi_varinst	root_proc_inst_id_	varchar	64	√		null
act_ru_authorization	root_proc_inst_id_	varchar	64	√		null
act_ru_execution	root_proc_inst_id_	varchar	64	√		null
act_ru_job	root_proc_inst_id_	varchar	64	√		null
act_hi_dec_out	rule_id_	varchar	64	√		null
act_hi_dec_out	rule_order_	int4	10	√		null
act_id_user	salt_	varchar	255	√		null
act_ru_case_sentry_part	satisfied_	bool	1	√		null
act_hi_batch	seed_job_def_id_	varchar	64	√		null
act_ru_batch	seed_job_def_id_	varchar	64	√		null
act_ru_case_sentry_part	sentry_id_	varchar	255	√		null
act_hi_actinst	sequence_counter_	int8	19	√		null
act_hi_detail	sequence_counter_	int8	19	√		null
act_hi_job_log	sequence_counter_	int8	19	√		null
act_ru_execution	sequence_counter_	int8	19	√		null
act_ru_job	sequence_counter_	int8	19	√		null
act_ru_variable	sequence_counter_	int8	19	√		null
act_re_deployment	source_	varchar	255	√		null
act_ru_case_sentry_part	source_	varchar	255	√		null
act_ru_case_sentry_part	source_case_exec_id_	varchar	64	√		null
act_ru_case_sentry_part	standard_event_	varchar	255	√		null
act_hi_procinst	start_act_id_	varchar	255	√		null
act_hi_actinst	start_time_	timestamp	29,6
act_hi_batch	start_time_	timestamp	29,6
act_hi_procinst	start_time_	timestamp	29,6
act_hi_taskinst	start_time_	timestamp	29,6
act_ru_batch	start_time_	timestamp	29,6	√		null
act_hi_procinst	start_user_id_	varchar	255	√		null
act_re_procdef	startable_	bool	1			true
act_hi_caseactinst	state_	int4	10	√		null
act_hi_caseinst	state_	int4	10	√		null
act_hi_ext_task_log	state_	int4	10	√		null
act_hi_procinst	state_	varchar	255	√		null
act_hi_varinst	state_	varchar	20	√		null
act_ru_case_execution	super_case_exec_	varchar	64	√		null
act_ru_execution	super_case_exec_	varchar	64	√		null
act_hi_caseinst	super_case_instance_id_	varchar	64	√		null
act_hi_procinst	super_case_instance_id_	varchar	64	√		null
act_ru_case_execution	super_exec_	varchar	64	√		null
act_ru_execution	super_exec_	varchar	64	√		null
act_hi_caseinst	super_process_instance_id_	varchar	64	√		null
act_hi_procinst	super_process_instance_id_	varchar	64	√		null
act_re_procdef	suspension_state_	int4	10	√		null
act_ru_batch	suspension_state_	int4	10	√		null
act_ru_execution	suspension_state_	int4	10	√		null
act_ru_ext_task	suspension_state_	int4	10	√		null
act_ru_job	suspension_state_	int4	10			1
act_ru_jobdef	suspension_state_	int4	10	√		null
act_ru_task	suspension_state_	int4	10	√		null
act_hi_taskinst	task_def_key_	varchar	255	√		null
act_ru_task	task_def_key_	varchar	255	√		null
act_hi_actinst	task_id_	varchar	64	√		null
act_hi_attachment	task_id_	varchar	64	√		null
act_hi_caseactinst	task_id_	varchar	64	√		null
act_hi_comment	task_id_	varchar	64	√		null
act_hi_detail	task_id_	varchar	64	√		null
act_hi_identitylink	task_id_	varchar	64	√		null
act_hi_op_log	task_id_	varchar	64	√		null
act_hi_varinst	task_id_	varchar	64	√		null
act_ru_identitylink	task_id_	varchar	64	√		null
act_ru_variable	task_id_	varchar	64	√		null
act_hi_taskinst	task_state_	varchar	64	√		null
act_ru_task	task_state_	varchar	64	√		null
act_ge_bytearray	tenant_id_	varchar	64	√		null
act_hi_actinst	tenant_id_	varchar	64	√		null
act_hi_attachment	tenant_id_	varchar	64	√		null
act_hi_batch	tenant_id_	varchar	64	√		null
act_hi_caseactinst	tenant_id_	varchar	64	√		null
act_hi_caseinst	tenant_id_	varchar	64	√		null
act_hi_comment	tenant_id_	varchar	64	√		null
act_hi_dec_in	tenant_id_	varchar	64	√		null
act_hi_dec_out	tenant_id_	varchar	64	√		null
act_hi_decinst	tenant_id_	varchar	64	√		null
act_hi_detail	tenant_id_	varchar	64	√		null
act_hi_ext_task_log	tenant_id_	varchar	64	√		null
act_hi_identitylink	tenant_id_	varchar	64	√		null
act_hi_incident	tenant_id_	varchar	64	√		null
act_hi_job_log	tenant_id_	varchar	64	√		null
act_hi_op_log	tenant_id_	varchar	64	√		null
act_hi_procinst	tenant_id_	varchar	64	√		null
act_hi_taskinst	tenant_id_	varchar	64	√		null
act_hi_varinst	tenant_id_	varchar	64	√		null
act_id_tenant_member	tenant_id_	varchar	64
act_re_camformdef	tenant_id_	varchar	64	√		null
act_re_case_def	tenant_id_	varchar	64	√		null
act_re_decision_def	tenant_id_	varchar	64	√		null
act_re_decision_req_def	tenant_id_	varchar	64	√		null
act_re_deployment	tenant_id_	varchar	64	√		null
act_re_procdef	tenant_id_	varchar	64	√		null
act_ru_batch	tenant_id_	varchar	64	√		null
act_ru_case_execution	tenant_id_	varchar	64	√		null
act_ru_case_sentry_part	tenant_id_	varchar	64	√		null
act_ru_event_subscr	tenant_id_	varchar	64	√		null
act_ru_execution	tenant_id_	varchar	64	√		null
act_ru_ext_task	tenant_id_	varchar	64	√		null
act_ru_identitylink	tenant_id_	varchar	64	√		null
act_ru_incident	tenant_id_	varchar	64	√		null
act_ru_job	tenant_id_	varchar	64	√		null
act_ru_jobdef	tenant_id_	varchar	64	√		null
act_ru_task	tenant_id_	varchar	64	√		null
act_ru_variable	tenant_id_	varchar	64	√		null
act_hi_dec_in	text2_	varchar	4000	√		null
act_hi_dec_out	text2_	varchar	4000	√		null
act_hi_detail	text2_	varchar	4000	√		null
act_hi_varinst	text2_	varchar	4000	√		null
act_ru_variable	text2_	varchar	4000	√		null
act_hi_dec_in	text_	varchar	4000	√		null
act_hi_dec_out	text_	varchar	4000	√		null
act_hi_detail	text_	varchar	4000	√		null
act_hi_varinst	text_	varchar	4000	√		null
act_ru_variable	text_	varchar	4000	√		null
act_hi_comment	time_	timestamp	29,6
act_hi_detail	time_	timestamp	29,6
act_ge_schema_log	timestamp_	timestamp	29,6	√		null
act_hi_ext_task_log	timestamp_	timestamp	29,6
act_hi_identitylink	timestamp_	timestamp	29,6
act_hi_job_log	timestamp_	timestamp	29,6
act_hi_op_log	timestamp_	timestamp	29,6
act_ru_meter_log	timestamp_	timestamp	29,6	√		null
act_ru_task_meter_log	timestamp_	timestamp	29,6	√		null
act_hi_ext_task_log	topic_name_	varchar	255	√		null
act_ru_ext_task	topic_name_	varchar	255	√		null
act_hi_batch	total_jobs_	int4	10	√		null
act_ru_batch	total_jobs_	int4	10	√		null
act_ge_bytearray	type_	int4	10	√		null
act_hi_attachment	type_	varchar	255	√		null
act_hi_batch	type_	varchar	255	√		null
act_hi_comment	type_	varchar	255	√		null
act_hi_detail	type_	varchar	255
act_hi_identitylink	type_	varchar	255	√		null
act_id_group	type_	varchar	255	√		null
act_id_info	type_	varchar	64	√		null
act_ru_authorization	type_	int4	10
act_ru_batch	type_	varchar	255	√		null
act_ru_case_sentry_part	type_	varchar	255	√		null
act_ru_identitylink	type_	varchar	255	√		null
act_ru_job	type_	varchar	255
act_ru_variable	type_	varchar	255
act_hi_attachment	url_	varchar	4000	√		null
act_hi_attachment	user_id_	varchar	255	√		null
act_hi_comment	user_id_	varchar	255	√		null
act_hi_decinst	user_id_	varchar	255	√		null
act_hi_identitylink	user_id_	varchar	255	√		null
act_hi_op_log	user_id_	varchar	255	√		null
act_id_info	user_id_	varchar	64	√		null
act_id_membership	user_id_	varchar	64
act_id_tenant_member	user_id_	varchar	64	√		null
act_ru_authorization	user_id_	varchar	255	√		null
act_ru_identitylink	user_id_	varchar	255	√		null
act_ge_property	value_	varchar	300	√		null
act_id_info	value_	varchar	255	√		null
act_ru_meter_log	value_	int8	19	√		null
act_hi_detail	var_inst_id_	varchar	64	√		null
act_hi_dec_out	var_name_	varchar	255	√		null
act_ru_variable	var_scope_	varchar	64	√		null
act_hi_dec_in	var_type_	varchar	100	√		null
act_hi_dec_out	var_type_	varchar	100	√		null
act_hi_detail	var_type_	varchar	64	√		null
act_hi_varinst	var_type_	varchar	100	√		null
act_ru_case_sentry_part	variable_event_	varchar	255	√		null
act_ru_case_sentry_part	variable_name_	varchar	255	√		null
act_ge_schema_log	version_	varchar	255	√		null
act_re_camformdef	version_	int4	10
act_re_case_def	version_	int4	10
act_re_decision_def	version_	int4	10
act_re_decision_req_def	version_	int4	10
act_re_procdef	version_	int4	10
act_re_decision_def	version_tag_	varchar	64	√		null
act_re_procdef	version_tag_	varchar	64	√		null
act_hi_ext_task_log	worker_id_	varchar	255	√		null
act_ru_ext_task	worker_id_	varchar	255	√		null