Tables : act_hi_procinst


Columns

14

Keys

2

Triggers

0

Comment:

Description:

Indexes

2

Contraints

0


Columns :

Name Caption Primary Key type
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)

Keys :

Name Primary Key Description
act_hi_procinst_pkey true
act_hi_procinst_proc_inst_id__key

Indexes

Name UNIQUE Type Description
act_idx_hi_pro_i_buskey Ascending
act_idx_hi_pro_inst_end Ascending

Columns Detail :

Name id_
Table act_hi_procinst
Type CHARACTER VARYING(64)
Domain
Primary Key true
Not null true

Name proc_inst_id_
Table act_hi_procinst
Type CHARACTER VARYING(64)
Domain
Not null true
Unique true

Name business_key_
Table act_hi_procinst
Type CHARACTER VARYING(255)
Domain

Name proc_def_id_
Table act_hi_procinst
Type CHARACTER VARYING(64)
Domain
Not null true

Name start_time_
Table act_hi_procinst
Type TIMESTAMP(6)
Domain
Not null true

Name end_time_
Table act_hi_procinst
Type TIMESTAMP(6)
Domain

Name duration_
Table act_hi_procinst
Type BIGINT
Domain

Name start_user_id_
Table act_hi_procinst
Type CHARACTER VARYING(255)
Domain

Name start_act_id_
Table act_hi_procinst
Type CHARACTER VARYING(255)
Domain

Name end_act_id_
Table act_hi_procinst
Type CHARACTER VARYING(255)
Domain

Name super_process_instance_id_
Table act_hi_procinst
Type CHARACTER VARYING(64)
Domain

Name delete_reason_
Table act_hi_procinst
Type CHARACTER VARYING(4000)
Domain

Name tenant_id_
Table act_hi_procinst
Type CHARACTER VARYING(255)
Domain
Default Value ''::character varying

Name name_
Table act_hi_procinst
Type CHARACTER VARYING(255)
Domain

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description