Tables : act_ru_execution
Columns17 |
Keys1 |
Triggers0 |
Comment:Description: |
|
Indexes5 |
Contraints0 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id_ | id_ | true | CHARACTER VARYING(64) |
| rev_ | rev_ | INTEGER | |
| proc_inst_id_ | proc_inst_id_ | CHARACTER VARYING(64) | |
| business_key_ | business_key_ | CHARACTER VARYING(255) | |
| parent_id_ | parent_id_ | CHARACTER VARYING(64) | |
| proc_def_id_ | proc_def_id_ | CHARACTER VARYING(64) | |
| super_exec_ | super_exec_ | CHARACTER VARYING(64) | |
| act_id_ | act_id_ | CHARACTER VARYING(255) | |
| is_active_ | is_active_ | BOOLEAN | |
| is_concurrent_ | is_concurrent_ | BOOLEAN | |
| is_scope_ | is_scope_ | BOOLEAN | |
| is_event_scope_ | is_event_scope_ | BOOLEAN | |
| suspension_state_ | suspension_state_ | INTEGER | |
| cached_ent_state_ | cached_ent_state_ | INTEGER | |
| tenant_id_ | tenant_id_ | CHARACTER VARYING(255) | |
| name_ | name_ | CHARACTER VARYING(255) | |
| lock_time_ | lock_time_ | TIMESTAMP(6) |
Keys :
| Name | Primary Key | Description |
|---|---|---|
| act_ru_execution_pkey | true |
Indexes
| Name | UNIQUE | Type | Description |
|---|---|---|---|
| act_idx_exe_procdef | Ascending | ||
| act_idx_exe_super | Ascending | ||
| act_idx_exe_parent | Ascending | ||
| act_idx_exe_procinst | Ascending | ||
| act_idx_exec_buskey | Ascending |
Columns Detail :
| Name | id_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Primary Key | true |
| Not null | true |
| Name | rev_ |
| Table | act_ru_execution |
| Type | INTEGER |
| Domain |
| Name | proc_inst_id_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
| Name | business_key_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | parent_id_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
| Name | proc_def_id_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
| Name | super_exec_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
| Name | act_id_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | is_active_ |
| Table | act_ru_execution |
| Type | BOOLEAN |
| Domain |
| Name | is_concurrent_ |
| Table | act_ru_execution |
| Type | BOOLEAN |
| Domain |
| Name | is_scope_ |
| Table | act_ru_execution |
| Type | BOOLEAN |
| Domain |
| Name | is_event_scope_ |
| Table | act_ru_execution |
| Type | BOOLEAN |
| Domain |
| Name | suspension_state_ |
| Table | act_ru_execution |
| Type | INTEGER |
| Domain |
| Name | cached_ent_state_ |
| Table | act_ru_execution |
| Type | INTEGER |
| Domain |
| Name | tenant_id_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(255) |
| Domain | |
| Default Value | ''::character varying |
| Name | name_ |
| Table | act_ru_execution |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | lock_time_ |
| Table | act_ru_execution |
| Type | TIMESTAMP(6) |
| Domain |
Project
Alfresco Data model