Tables : act_hi_detail


Columns

15

Keys

1

Triggers

0

Comment:

Description:

Indexes

5

Contraints

0


Columns :

Name Caption Primary Key type
id_ id_ true CHARACTER VARYING(64)
type_ type_ CHARACTER VARYING(255)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
execution_id_ execution_id_ CHARACTER VARYING(64)
task_id_ task_id_ CHARACTER VARYING(64)
act_inst_id_ act_inst_id_ CHARACTER VARYING(64)
name_ name_ CHARACTER VARYING(255)
var_type_ var_type_ CHARACTER VARYING(64)
rev_ rev_ INTEGER
time_ time_ TIMESTAMP(6)
bytearray_id_ bytearray_id_ CHARACTER VARYING(64)
double_ double_ DOUBLE PRECISION
long_ long_ BIGINT
text_ text_ CHARACTER VARYING(4000)
text2_ text2_ CHARACTER VARYING(4000)

Keys :

Name Primary Key Description
act_hi_detail_pkey true

Indexes

Name UNIQUE Type Description
act_idx_hi_detail_task_id Ascending
act_idx_hi_detail_name Ascending
act_idx_hi_detail_time Ascending
act_idx_hi_detail_act_inst Ascending
act_idx_hi_detail_proc_inst Ascending

Columns Detail :

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

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

Name proc_inst_id_
Table act_hi_detail
Type CHARACTER VARYING(64)
Domain

Name execution_id_
Table act_hi_detail
Type CHARACTER VARYING(64)
Domain

Name task_id_
Table act_hi_detail
Type CHARACTER VARYING(64)
Domain

Name act_inst_id_
Table act_hi_detail
Type CHARACTER VARYING(64)
Domain

Name name_
Table act_hi_detail
Type CHARACTER VARYING(255)
Domain
Not null true

Name var_type_
Table act_hi_detail
Type CHARACTER VARYING(64)
Domain

Name rev_
Table act_hi_detail
Type INTEGER
Domain

Name time_
Table act_hi_detail
Type TIMESTAMP(6)
Domain
Not null true

Name bytearray_id_
Table act_hi_detail
Type CHARACTER VARYING(64)
Domain

Name double_
Table act_hi_detail
Type DOUBLE PRECISION
Domain

Name long_
Table act_hi_detail
Type BIGINT
Domain

Name text_
Table act_hi_detail
Type CHARACTER VARYING(4000)
Domain

Name text2_
Table act_hi_detail
Type CHARACTER VARYING(4000)
Domain

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description