Tables : act_hi_actinst


Columns

14

Keys

1

Triggers

0

Comment:

Description:

Indexes

4

Contraints

0


Columns :

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

Keys :

Name Primary Key Description
act_hi_actinst_pkey true

Indexes

Name UNIQUE Type Description
act_idx_hi_act_inst_exec Ascending
act_idx_hi_act_inst_procinst Ascending
act_idx_hi_act_inst_end Ascending
act_idx_hi_act_inst_start Ascending

Columns Detail :

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

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

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

Name execution_id_
Table act_hi_actinst
Type CHARACTER VARYING(64)
Domain
Not null true

Name act_id_
Table act_hi_actinst
Type CHARACTER VARYING(255)
Domain
Not null true

Name task_id_
Table act_hi_actinst
Type CHARACTER VARYING(64)
Domain

Name call_proc_inst_id_
Table act_hi_actinst
Type CHARACTER VARYING(64)
Domain

Name act_name_
Table act_hi_actinst
Type CHARACTER VARYING(255)
Domain

Name act_type_
Table act_hi_actinst
Type CHARACTER VARYING(255)
Domain
Not null true

Name assignee_
Table act_hi_actinst
Type CHARACTER VARYING(255)
Domain

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

Name end_time_
Table act_hi_actinst
Type TIMESTAMP(6)
Domain

Name duration_
Table act_hi_actinst
Type BIGINT
Domain

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

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description