Tables : act_hi_varinst


Columns

14

Keys

1

Triggers

0

Comment:

Description:

Indexes

3

Contraints

0


Columns :

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

Keys :

Name Primary Key Description
act_hi_varinst_pkey true

Indexes

Name UNIQUE Type Description
act_idx_hi_procvar_task_id Ascending
act_idx_hi_procvar_name_type Ascending
act_idx_hi_procvar_proc_inst Ascending

Columns Detail :

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

Name proc_inst_id_
Table act_hi_varinst
Type CHARACTER VARYING(64)
Domain

Name execution_id_
Table act_hi_varinst
Type CHARACTER VARYING(64)
Domain

Name task_id_
Table act_hi_varinst
Type CHARACTER VARYING(64)
Domain

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

Name var_type_
Table act_hi_varinst
Type CHARACTER VARYING(100)
Domain

Name rev_
Table act_hi_varinst
Type INTEGER
Domain

Name bytearray_id_
Table act_hi_varinst
Type CHARACTER VARYING(64)
Domain

Name double_
Table act_hi_varinst
Type DOUBLE PRECISION
Domain

Name long_
Table act_hi_varinst
Type BIGINT
Domain

Name text_
Table act_hi_varinst
Type CHARACTER VARYING(4000)
Domain

Name text2_
Table act_hi_varinst
Type CHARACTER VARYING(4000)
Domain

Name create_time_
Table act_hi_varinst
Type TIMESTAMP(6)
Domain

Name last_updated_time_
Table act_hi_varinst
Type TIMESTAMP(6)
Domain

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description