SchemaSpy Analysis of testdb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Feb 15 22:10 UTC 2024
Legend:
Primary key columns
Columns with indexes
 

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