Tables : act_ru_variable


Columns

12

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
type_ type_ CHARACTER VARYING(255)
name_ name_ CHARACTER VARYING(255)
execution_id_ execution_id_ CHARACTER VARYING(64)
proc_inst_id_ proc_inst_id_ CHARACTER VARYING(64)
task_id_ task_id_ CHARACTER VARYING(64)
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_ru_variable_pkey true

Indexes

Name UNIQUE Type Description
act_idx_var_bytearray Ascending
act_idx_var_procinst Ascending
act_idx_var_exe Ascending
act_idx_variable_task_id Ascending

Columns Detail :

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

Name rev_
Table act_ru_variable
Type INTEGER
Domain

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

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

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

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

Name task_id_
Table act_ru_variable
Type CHARACTER VARYING(64)
Domain

Name bytearray_id_
Table act_ru_variable
Type CHARACTER VARYING(64)
Domain
Foreign key true

Name double_
Table act_ru_variable
Type DOUBLE PRECISION
Domain

Name long_
Table act_ru_variable
Type BIGINT
Domain

Name text_
Table act_ru_variable
Type CHARACTER VARYING(4000)
Domain

Name text2_
Table act_ru_variable
Type CHARACTER VARYING(4000)
Domain

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description