Tables : act_hi_taskinst


Columns

20

Keys

1

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

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

Keys :

Name Primary Key Description
act_hi_taskinst_pkey true

Indexes

Name UNIQUE Type Description
act_idx_hi_task_inst_procinst Ascending

Columns Detail :

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

Name proc_def_id_
Table act_hi_taskinst
Type CHARACTER VARYING(64)
Domain

Name task_def_key_
Table act_hi_taskinst
Type CHARACTER VARYING(255)
Domain

Name proc_inst_id_
Table act_hi_taskinst
Type CHARACTER VARYING(64)
Domain

Name execution_id_
Table act_hi_taskinst
Type CHARACTER VARYING(64)
Domain

Name name_
Table act_hi_taskinst
Type CHARACTER VARYING(255)
Domain

Name parent_task_id_
Table act_hi_taskinst
Type CHARACTER VARYING(64)
Domain

Name description_
Table act_hi_taskinst
Type CHARACTER VARYING(4000)
Domain

Name owner_
Table act_hi_taskinst
Type CHARACTER VARYING(255)
Domain

Name assignee_
Table act_hi_taskinst
Type CHARACTER VARYING(255)
Domain

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

Name claim_time_
Table act_hi_taskinst
Type TIMESTAMP(6)
Domain

Name end_time_
Table act_hi_taskinst
Type TIMESTAMP(6)
Domain

Name duration_
Table act_hi_taskinst
Type BIGINT
Domain

Name delete_reason_
Table act_hi_taskinst
Type CHARACTER VARYING(4000)
Domain

Name priority_
Table act_hi_taskinst
Type INTEGER
Domain

Name due_date_
Table act_hi_taskinst
Type TIMESTAMP(6)
Domain

Name form_key_
Table act_hi_taskinst
Type CHARACTER VARYING(255)
Domain

Name category_
Table act_hi_taskinst
Type CHARACTER VARYING(255)
Domain

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

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description