Tables : act_ru_job


Columns

17

Keys

1

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

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

Keys :

Name Primary Key Description
act_ru_job_pkey true

Indexes

Name UNIQUE Type Description
act_idx_job_exception Ascending

Columns Detail :

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

Name rev_
Table act_ru_job
Type INTEGER
Domain

Name type_
Table act_ru_job
Type CHARACTER VARYING(255)
Domain
Not null true

Name lock_exp_time_
Table act_ru_job
Type TIMESTAMP(6)
Domain

Name lock_owner_
Table act_ru_job
Type CHARACTER VARYING(255)
Domain

Name exclusive_
Table act_ru_job
Type BOOLEAN
Domain

Name execution_id_
Table act_ru_job
Type CHARACTER VARYING(64)
Domain

Name process_instance_id_
Table act_ru_job
Type CHARACTER VARYING(64)
Domain

Name proc_def_id_
Table act_ru_job
Type CHARACTER VARYING(64)
Domain

Name retries_
Table act_ru_job
Type INTEGER
Domain

Name exception_stack_id_
Table act_ru_job
Type CHARACTER VARYING(64)
Domain
Foreign key true

Name exception_msg_
Table act_ru_job
Type CHARACTER VARYING(4000)
Domain

Name duedate_
Table act_ru_job
Type TIMESTAMP(6)
Domain

Name repeat_
Table act_ru_job
Type CHARACTER VARYING(255)
Domain

Name handler_type_
Table act_ru_job
Type CHARACTER VARYING(255)
Domain

Name handler_cfg_
Table act_ru_job
Type CHARACTER VARYING(4000)
Domain

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

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description