Columns

Column Name Column Caption Primary Key Type
log_nr_ log_nr_ true INTEGER
is_processed_ is_processed_ SMALLINT
type_ type_ CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
execution_id_ execution_id_ CHARACTER VARYING(64)
task_id_ task_id_ CHARACTER VARYING(64)
time_stamp_ time_stamp_ TIMESTAMP(6)
user_id_ user_id_ CHARACTER VARYING(255)
data_ data_ BYTEA
lock_owner_ lock_owner_ CHARACTER VARYING(255)
lock_time_ lock_time_ TIMESTAMP(6)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
name_ name_ CHARACTER VARYING(255)
deployment_id_ deployment_id_ CHARACTER VARYING(64)
bytes_ bytes_ BYTEA
generated_ generated_ BOOLEAN
name_ name_ true CHARACTER VARYING(64)
value_ value_ CHARACTER VARYING(300)
rev_ rev_ INTEGER
id_ id_ true CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
execution_id_ execution_id_ CHARACTER VARYING(64)
act_id_ act_id_ CHARACTER VARYING(255)
task_id_ task_id_ CHARACTER VARYING(64)
call_proc_inst_id_ call_proc_inst_id_ CHARACTER VARYING(64)
act_name_ act_name_ CHARACTER VARYING(255)
act_type_ act_type_ CHARACTER VARYING(255)
assignee_ assignee_ CHARACTER VARYING(255)
start_time_ start_time_ TIMESTAMP(6)
end_time_ end_time_ TIMESTAMP(6)
duration_ duration_ BIGINT
tenant_id_ tenant_id_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
user_id_ user_id_ CHARACTER VARYING(255)
name_ name_ CHARACTER VARYING(255)
description_ description_ CHARACTER VARYING(4000)
type_ type_ CHARACTER VARYING(255)
task_id_ task_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
url_ url_ CHARACTER VARYING(4000)
content_id_ content_id_ CHARACTER VARYING(64)
time_ time_ TIMESTAMP(6)
id_ id_ true CHARACTER VARYING(64)
type_ type_ CHARACTER VARYING(255)
time_ time_ TIMESTAMP(6)
user_id_ user_id_ CHARACTER VARYING(255)
task_id_ task_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
action_ action_ CHARACTER VARYING(255)
message_ message_ CHARACTER VARYING(4000)
full_msg_ full_msg_ BYTEA
id_ id_ true CHARACTER VARYING(64)
type_ type_ CHARACTER VARYING(255)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
execution_id_ execution_id_ CHARACTER VARYING(64)
task_id_ task_id_ CHARACTER VARYING(64)
act_inst_id_ act_inst_id_ CHARACTER VARYING(64)
name_ name_ CHARACTER VARYING(255)
var_type_ var_type_ CHARACTER VARYING(64)
rev_ rev_ INTEGER
time_ time_ TIMESTAMP(6)
bytearray_id_ bytearray_id_ CHARACTER VARYING(64)
double_ double_ DOUBLE PRECISION
long_ long_ BIGINT
text_ text_ CHARACTER VARYING(4000)
text2_ text2_ CHARACTER VARYING(4000)
id_ id_ true CHARACTER VARYING(64)
group_id_ group_id_ CHARACTER VARYING(255)
type_ type_ CHARACTER VARYING(255)
user_id_ user_id_ CHARACTER VARYING(255)
task_id_ task_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
id_ id_ true CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
business_key_ business_key_ CHARACTER VARYING(255)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
start_time_ start_time_ TIMESTAMP(6)
end_time_ end_time_ TIMESTAMP(6)
duration_ duration_ BIGINT
start_user_id_ start_user_id_ CHARACTER VARYING(255)
start_act_id_ start_act_id_ CHARACTER VARYING(255)
end_act_id_ end_act_id_ CHARACTER VARYING(255)
super_process_instance_id_ super_process_instance_id_ CHARACTER VARYING(64)
delete_reason_ delete_reason_ CHARACTER VARYING(4000)
tenant_id_ tenant_id_ CHARACTER VARYING(255)
name_ name_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
task_def_key_ task_def_key_ CHARACTER VARYING(255)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
execution_id_ execution_id_ CHARACTER VARYING(64)
name_ name_ CHARACTER VARYING(255)
parent_task_id_ parent_task_id_ CHARACTER VARYING(64)
description_ description_ CHARACTER VARYING(4000)
owner_ owner_ CHARACTER VARYING(255)
assignee_ assignee_ CHARACTER VARYING(255)
start_time_ start_time_ TIMESTAMP(6)
claim_time_ claim_time_ TIMESTAMP(6)
end_time_ end_time_ TIMESTAMP(6)
duration_ duration_ BIGINT
delete_reason_ delete_reason_ CHARACTER VARYING(4000)
priority_ priority_ INTEGER
due_date_ due_date_ TIMESTAMP(6)
form_key_ form_key_ CHARACTER VARYING(255)
category_ category_ CHARACTER VARYING(255)
tenant_id_ tenant_id_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
execution_id_ execution_id_ CHARACTER VARYING(64)
task_id_ task_id_ CHARACTER VARYING(64)
name_ name_ CHARACTER VARYING(255)
var_type_ var_type_ CHARACTER VARYING(100)
rev_ rev_ INTEGER
bytearray_id_ bytearray_id_ CHARACTER VARYING(64)
double_ double_ DOUBLE PRECISION
long_ long_ BIGINT
text_ text_ CHARACTER VARYING(4000)
text2_ text2_ CHARACTER VARYING(4000)
create_time_ create_time_ TIMESTAMP(6)
last_updated_time_ last_updated_time_ TIMESTAMP(6)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
name_ name_ CHARACTER VARYING(255)
type_ type_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
user_id_ user_id_ CHARACTER VARYING(64)
type_ type_ CHARACTER VARYING(64)
key_ key_ CHARACTER VARYING(255)
value_ value_ CHARACTER VARYING(255)
password_ password_ BYTEA
parent_id_ parent_id_ CHARACTER VARYING(255)
user_id_ user_id_ true CHARACTER VARYING(64)
group_id_ group_id_ true CHARACTER VARYING(64)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
first_ first_ CHARACTER VARYING(255)
last_ last_ CHARACTER VARYING(255)
email_ email_ CHARACTER VARYING(255)
pwd_ pwd_ CHARACTER VARYING(255)
picture_id_ picture_id_ CHARACTER VARYING(64)
id_ id_ true CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
rev_ rev_ INTEGER
info_json_id_ info_json_id_ CHARACTER VARYING(64)
id_ id_ true CHARACTER VARYING(64)
name_ name_ CHARACTER VARYING(255)
category_ category_ CHARACTER VARYING(255)
tenant_id_ tenant_id_ CHARACTER VARYING(255)
deploy_time_ deploy_time_ TIMESTAMP(6)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
name_ name_ CHARACTER VARYING(255)
key_ key_ CHARACTER VARYING(255)
category_ category_ CHARACTER VARYING(255)
create_time_ create_time_ TIMESTAMP(6)
last_update_time_ last_update_time_ TIMESTAMP(6)
version_ version_ INTEGER
meta_info_ meta_info_ CHARACTER VARYING(4000)
deployment_id_ deployment_id_ CHARACTER VARYING(64)
editor_source_value_id_ editor_source_value_id_ CHARACTER VARYING(64)
editor_source_extra_value_id_ editor_source_extra_value_id_ CHARACTER VARYING(64)
tenant_id_ tenant_id_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
category_ category_ CHARACTER VARYING(255)
name_ name_ CHARACTER VARYING(255)
key_ key_ CHARACTER VARYING(255)
version_ version_ INTEGER
deployment_id_ deployment_id_ CHARACTER VARYING(64)
resource_name_ resource_name_ CHARACTER VARYING(4000)
dgrm_resource_name_ dgrm_resource_name_ CHARACTER VARYING(4000)
description_ description_ CHARACTER VARYING(4000)
has_start_form_key_ has_start_form_key_ BOOLEAN
has_graphical_notation_ has_graphical_notation_ BOOLEAN
suspension_state_ suspension_state_ INTEGER
tenant_id_ tenant_id_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
event_type_ event_type_ CHARACTER VARYING(255)
event_name_ event_name_ CHARACTER VARYING(255)
execution_id_ execution_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
activity_id_ activity_id_ CHARACTER VARYING(64)
configuration_ configuration_ CHARACTER VARYING(255)
created_ created_ TIMESTAMP(6)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
tenant_id_ tenant_id_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
business_key_ business_key_ CHARACTER VARYING(255)
parent_id_ parent_id_ CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
super_exec_ super_exec_ CHARACTER VARYING(64)
act_id_ act_id_ CHARACTER VARYING(255)
is_active_ is_active_ BOOLEAN
is_concurrent_ is_concurrent_ BOOLEAN
is_scope_ is_scope_ BOOLEAN
is_event_scope_ is_event_scope_ BOOLEAN
suspension_state_ suspension_state_ INTEGER
cached_ent_state_ cached_ent_state_ INTEGER
tenant_id_ tenant_id_ CHARACTER VARYING(255)
name_ name_ CHARACTER VARYING(255)
lock_time_ lock_time_ TIMESTAMP(6)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
group_id_ group_id_ CHARACTER VARYING(255)
type_ type_ CHARACTER VARYING(255)
user_id_ user_id_ CHARACTER VARYING(255)
task_id_ task_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
type_ type_ CHARACTER VARYING(255)
lock_exp_time_ lock_exp_time_ TIMESTAMP(6)
lock_owner_ lock_owner_ CHARACTER VARYING(255)
exclusive_ exclusive_ BOOLEAN
execution_id_ execution_id_ CHARACTER VARYING(64)
process_instance_id_ process_instance_id_ CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
retries_ retries_ INTEGER
exception_stack_id_ exception_stack_id_ CHARACTER VARYING(64)
exception_msg_ exception_msg_ CHARACTER VARYING(4000)
duedate_ duedate_ TIMESTAMP(6)
repeat_ repeat_ CHARACTER VARYING(255)
handler_type_ handler_type_ CHARACTER VARYING(255)
handler_cfg_ handler_cfg_ CHARACTER VARYING(4000)
tenant_id_ tenant_id_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
execution_id_ execution_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
proc_def_id_ proc_def_id_ CHARACTER VARYING(64)
name_ name_ CHARACTER VARYING(255)
parent_task_id_ parent_task_id_ CHARACTER VARYING(64)
description_ description_ CHARACTER VARYING(4000)
task_def_key_ task_def_key_ CHARACTER VARYING(255)
owner_ owner_ CHARACTER VARYING(255)
assignee_ assignee_ CHARACTER VARYING(255)
delegation_ delegation_ CHARACTER VARYING(64)
priority_ priority_ INTEGER
create_time_ create_time_ TIMESTAMP(6)
due_date_ due_date_ TIMESTAMP(6)
category_ category_ CHARACTER VARYING(255)
suspension_state_ suspension_state_ INTEGER
tenant_id_ tenant_id_ CHARACTER VARYING(255)
form_key_ form_key_ CHARACTER VARYING(255)
id_ id_ true CHARACTER VARYING(64)
rev_ rev_ INTEGER
type_ type_ CHARACTER VARYING(255)
name_ name_ CHARACTER VARYING(255)
execution_id_ execution_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
task_id_ task_id_ CHARACTER VARYING(64)
bytearray_id_ bytearray_id_ CHARACTER VARYING(64)
double_ double_ DOUBLE PRECISION
long_ long_ BIGINT
text_ text_ CHARACTER VARYING(4000)
text2_ text2_ CHARACTER VARYING(4000)
id id true BIGINT
version version BIGINT
permission_id permission_id BIGINT
authority_id authority_id BIGINT
allowed allowed BOOLEAN
applies applies INTEGER
context_id context_id BIGINT
id id true BIGINT
acl_change_set acl_change_set BIGINT
version version BIGINT
acl_id acl_id CHARACTER VARYING(36)
latest latest BOOLEAN
acl_version acl_version BIGINT
inherits inherits BOOLEAN
inherits_from inherits_from BIGINT
type type INTEGER
inherited_acl inherited_acl BIGINT
is_versioned is_versioned BOOLEAN
requires_version requires_version BOOLEAN
id id true BIGINT
version version BIGINT
class_context class_context CHARACTER VARYING(1024)
property_context property_context CHARACTER VARYING(1024)
kvp_context kvp_context CHARACTER VARYING(1024)
id id true BIGINT
commit_time_ms commit_time_ms BIGINT
id id true BIGINT
version version BIGINT
acl_id acl_id BIGINT
ace_id ace_id BIGINT
pos pos INTEGER
id id true BIGINT
post_id post_id BIGINT
post_date post_date TIMESTAMP(6)
activity_summary activity_summary CHARACTER VARYING(1024)
feed_user_id feed_user_id CHARACTER VARYING(255)
activity_type activity_type CHARACTER VARYING(255)
site_network site_network CHARACTER VARYING(255)
app_tool app_tool CHARACTER VARYING(36)
post_user_id post_user_id CHARACTER VARYING(255)
feed_date feed_date TIMESTAMP(6)
id id true BIGINT
feed_user_id feed_user_id CHARACTER VARYING(255)
site_network site_network CHARACTER VARYING(255)
app_tool app_tool CHARACTER VARYING(36)
last_modified last_modified TIMESTAMP(6)
sequence_id sequence_id true BIGINT
post_date post_date TIMESTAMP(6)
status status CHARACTER VARYING(10)
activity_data activity_data CHARACTER VARYING(1024)
post_user_id post_user_id CHARACTER VARYING(255)
job_task_node job_task_node INTEGER
site_network site_network CHARACTER VARYING(255)
app_tool app_tool CHARACTER VARYING(36)
activity_type activity_type CHARACTER VARYING(255)
last_modified last_modified TIMESTAMP(6)
id id true CHARACTER VARYING(64)
description description CHARACTER VARYING(1024)
fixes_from_schema fixes_from_schema INTEGER
fixes_to_schema fixes_to_schema INTEGER
applied_to_schema applied_to_schema INTEGER
target_schema target_schema INTEGER
applied_on_date applied_on_date TIMESTAMP(6)
applied_to_server applied_to_server CHARACTER VARYING(64)
was_executed was_executed BOOLEAN
succeeded succeeded BOOLEAN
report report CHARACTER VARYING(1024)
id id true BIGINT
version version INTEGER
app_name_id app_name_id BIGINT
audit_model_id audit_model_id BIGINT
disabled_paths_id disabled_paths_id BIGINT
id id true BIGINT
audit_app_id audit_app_id BIGINT
audit_time audit_time BIGINT
audit_user_id audit_user_id BIGINT
audit_values_id audit_values_id BIGINT
id id true BIGINT
content_data_id content_data_id BIGINT
content_crc content_crc BIGINT
id id true BIGINT
username username CHARACTER VARYING(100)
deleted deleted BOOLEAN
authorized authorized BOOLEAN
checksum checksum BYTEA
authaction authaction CHARACTER VARYING(10)
id id true BIGINT
version version BIGINT
authority authority CHARACTER VARYING(100)
crc crc BIGINT
id id true BIGINT
version version BIGINT
auth_id auth_id BIGINT
alias_id alias_id BIGINT
id id true BIGINT
version version BIGINT
parent_node_id parent_node_id BIGINT
type_qname_id type_qname_id BIGINT
child_node_name_crc child_node_name_crc BIGINT
child_node_name child_node_name CHARACTER VARYING(50)
child_node_id child_node_id BIGINT
qname_ns_id qname_ns_id BIGINT
qname_localname qname_localname CHARACTER VARYING(255)
qname_crc qname_crc BIGINT
is_primary is_primary BOOLEAN
assoc_index assoc_index INTEGER
id id true BIGINT
version version BIGINT
content_url_id content_url_id BIGINT
content_mimetype_id content_mimetype_id BIGINT
content_encoding_id content_encoding_id BIGINT
content_locale_id content_locale_id BIGINT
id id true BIGINT
content_url content_url CHARACTER VARYING(255)
content_url_short content_url_short CHARACTER VARYING(12)
content_url_crc content_url_crc BIGINT
content_size content_size BIGINT
orphan_time orphan_time BIGINT
id id true BIGINT
content_url_id content_url_id BIGINT
algorithm algorithm CHARACTER VARYING(10)
key_size key_size INTEGER
encrypted_key encrypted_key BYTEA
master_keystore_id master_keystore_id CHARACTER VARYING(20)
master_key_alias master_key_alias CHARACTER VARYING(15)
unencrypted_file_size unencrypted_file_size BIGINT
id id true BIGINT
version version BIGINT
encoding_str encoding_str CHARACTER VARYING(100)
id id true BIGINT
version version BIGINT
locale_str locale_str CHARACTER VARYING(20)
id id true BIGINT
version version BIGINT
shared_resource_id shared_resource_id BIGINT
excl_resource_id excl_resource_id BIGINT
lock_token lock_token CHARACTER VARYING(36)
start_time start_time BIGINT
expiry_time expiry_time BIGINT
id id true BIGINT
version version BIGINT
qname_ns_id qname_ns_id BIGINT
qname_localname qname_localname CHARACTER VARYING(255)
id id true BIGINT
version version BIGINT
mimetype_str mimetype_str CHARACTER VARYING(100)
id id true BIGINT
version version BIGINT
uri uri CHARACTER VARYING(100)
id id true BIGINT
uuid uuid CHARACTER VARYING(36)
transaction_id transaction_id BIGINT
type_qname_id type_qname_id BIGINT
locale_id locale_id BIGINT
acl_id acl_id BIGINT
audit_creator audit_creator CHARACTER VARYING(255)
audit_created audit_created CHARACTER VARYING(30)
audit_modifier audit_modifier CHARACTER VARYING(255)
audit_modified audit_modified CHARACTER VARYING(30)
audit_accessed audit_accessed CHARACTER VARYING(30)
version version BIGINT
store_id store_id BIGINT
node_id node_id true BIGINT
qname_id qname_id true BIGINT
id id true BIGINT
version version BIGINT
source_node_id source_node_id BIGINT
target_node_id target_node_id BIGINT
type_qname_id type_qname_id BIGINT
assoc_index assoc_index BIGINT
node_id node_id true BIGINT
qname_id qname_id true BIGINT
list_index list_index true INTEGER
locale_id locale_id true BIGINT
boolean_value boolean_value BOOLEAN
long_value long_value BIGINT
float_value float_value REAL
double_value double_value DOUBLE PRECISION
string_value string_value CHARACTER VARYING(1024)
serializable_value serializable_value BYTEA
actual_type_n actual_type_n INTEGER
persisted_type_n persisted_type_n INTEGER
id id true BIGINT
version version BIGINT
type_qname_id type_qname_id BIGINT
name name CHARACTER VARYING(100)
id id true BIGINT
java_class_name java_class_name CHARACTER VARYING(255)
java_class_name_short java_class_name_short CHARACTER VARYING(32)
java_class_name_crc java_class_name_crc BIGINT
date_value date_value true BIGINT
full_year full_year INTEGER
half_of_year half_of_year SMALLINT
quarter_of_year quarter_of_year SMALLINT
month_of_year month_of_year SMALLINT
week_of_year week_of_year SMALLINT
week_of_month week_of_month SMALLINT
day_of_year day_of_year INTEGER
day_of_month day_of_month SMALLINT
day_of_week day_of_week SMALLINT
id id true BIGINT
double_value double_value DOUBLE PRECISION
root_prop_id root_prop_id true BIGINT
prop_index prop_index true BIGINT
contained_in contained_in true BIGINT
key_prop_id key_prop_id BIGINT
value_prop_id value_prop_id BIGINT
id id true BIGINT
version version INTEGER
id id true BIGINT
serializable_value serializable_value BYTEA
id id true BIGINT
string_value string_value CHARACTER VARYING(1024)
string_end_lower string_end_lower CHARACTER VARYING(16)
string_crc string_crc BIGINT
id id true BIGINT
version version INTEGER
value1_prop_id value1_prop_id BIGINT
value2_prop_id value2_prop_id BIGINT
value3_prop_id value3_prop_id BIGINT
prop1_id prop1_id BIGINT
id id true BIGINT
actual_type_id actual_type_id BIGINT
persisted_type persisted_type SMALLINT
long_value long_value BIGINT
id id true BIGINT
local_name local_name CHARACTER VARYING(200)
version version BIGINT
ns_id ns_id BIGINT
id id true BIGINT
version version BIGINT
ip_address ip_address CHARACTER VARYING(39)
id id true BIGINT
identifier identifier CHARACTER VARYING(100)
root_node_id root_node_id BIGINT
version version BIGINT
protocol protocol CHARACTER VARYING(50)
user_node_id user_node_id true BIGINT
node_id node_id true BIGINT
tenant_domain tenant_domain true CHARACTER VARYING(75)
version version BIGINT
enabled enabled BOOLEAN
tenant_name tenant_name CHARACTER VARYING(75)
content_root content_root CHARACTER VARYING(255)
db_url db_url CHARACTER VARYING(255)
id id true BIGINT
version version BIGINT
server_id server_id BIGINT
change_txn_id change_txn_id CHARACTER VARYING(56)
commit_time_ms commit_time_ms BIGINT
id id true BIGINT
version version BIGINT
node_id node_id BIGINT
delta_size delta_size BIGINT

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description