Tables : act_ru_event_subscr
Columns11 |
Keys1 |
Triggers0 |
Comment:Description: |
|
Indexes2 |
Contraints0 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id_ | id_ | true | CHARACTER VARYING(64) |
| rev_ | rev_ | INTEGER | |
| event_type_ | event_type_ | CHARACTER VARYING(255) | |
| event_name_ | event_name_ | CHARACTER VARYING(255) | |
| execution_id_ | execution_id_ | CHARACTER VARYING(64) | |
| proc_inst_id_ | proc_inst_id_ | CHARACTER VARYING(64) | |
| activity_id_ | activity_id_ | CHARACTER VARYING(64) | |
| configuration_ | configuration_ | CHARACTER VARYING(255) | |
| created_ | created_ | TIMESTAMP(6) | |
| proc_def_id_ | proc_def_id_ | CHARACTER VARYING(64) | |
| tenant_id_ | tenant_id_ | CHARACTER VARYING(255) |
Keys :
| Name | Primary Key | Description |
|---|---|---|
| act_ru_event_subscr_pkey | true |
Indexes
| Name | UNIQUE | Type | Description |
|---|---|---|---|
| act_idx_event_subscr | Ascending | ||
| act_idx_event_subscr_config_ | Ascending |
Columns Detail :
| Name | id_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Primary Key | true |
| Not null | true |
| Name | rev_ |
| Table | act_ru_event_subscr |
| Type | INTEGER |
| Domain |
| Name | event_type_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(255) |
| Domain | |
| Not null | true |
| Name | event_name_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | execution_id_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
| Name | proc_inst_id_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(64) |
| Domain |
| Name | activity_id_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(64) |
| Domain |
| Name | configuration_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | created_ |
| Table | act_ru_event_subscr |
| Type | TIMESTAMP(6) |
| Domain | |
| Not null | true |
| Name | proc_def_id_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(64) |
| Domain |
| Name | tenant_id_ |
| Table | act_ru_event_subscr |
| Type | CHARACTER VARYING(255) |
| Domain | |
| Default Value | ''::character varying |
Project
Alfresco Data model