Tables : act_ru_task


Columns

19

Keys

1

Triggers

0

Comment:

Description:

Indexes

4

Contraints

0


Columns :

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

Keys :

Name Primary Key Description
act_ru_task_pkey true

Indexes

Name UNIQUE Type Description
act_idx_task_procdef Ascending
act_idx_task_procinst Ascending
act_idx_task_exec Ascending
act_idx_task_create Ascending

Columns Detail :

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

Name rev_
Table act_ru_task
Type INTEGER
Domain

Name execution_id_
Table act_ru_task
Type CHARACTER VARYING(64)
Domain
Foreign key true

Name proc_inst_id_
Table act_ru_task
Type CHARACTER VARYING(64)
Domain
Foreign key true

Name proc_def_id_
Table act_ru_task
Type CHARACTER VARYING(64)
Domain
Foreign key true

Name name_
Table act_ru_task
Type CHARACTER VARYING(255)
Domain

Name parent_task_id_
Table act_ru_task
Type CHARACTER VARYING(64)
Domain

Name description_
Table act_ru_task
Type CHARACTER VARYING(4000)
Domain

Name task_def_key_
Table act_ru_task
Type CHARACTER VARYING(255)
Domain

Name owner_
Table act_ru_task
Type CHARACTER VARYING(255)
Domain

Name assignee_
Table act_ru_task
Type CHARACTER VARYING(255)
Domain

Name delegation_
Table act_ru_task
Type CHARACTER VARYING(64)
Domain

Name priority_
Table act_ru_task
Type INTEGER
Domain

Name create_time_
Table act_ru_task
Type TIMESTAMP(6)
Domain

Name due_date_
Table act_ru_task
Type TIMESTAMP(6)
Domain

Name category_
Table act_ru_task
Type CHARACTER VARYING(255)
Domain

Name suspension_state_
Table act_ru_task
Type INTEGER
Domain

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

Name form_key_
Table act_ru_task
Type CHARACTER VARYING(255)
Domain

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description