Tables : act_ru_identitylink
Columns8 |
Keys1 |
Triggers0 |
Comment:Description: |
|
Indexes5 |
Contraints0 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id_ | id_ | true | CHARACTER VARYING(64) |
| rev_ | rev_ | INTEGER | |
| group_id_ | group_id_ | CHARACTER VARYING(255) | |
| type_ | type_ | CHARACTER VARYING(255) | |
| user_id_ | user_id_ | CHARACTER VARYING(255) | |
| task_id_ | task_id_ | CHARACTER VARYING(64) | |
| proc_inst_id_ | proc_inst_id_ | CHARACTER VARYING(64) | |
| proc_def_id_ | proc_def_id_ | CHARACTER VARYING(64) |
Keys :
| Name | Primary Key | Description |
|---|---|---|
| act_ru_identitylink_pkey | true |
Indexes
| Name | UNIQUE | Type | Description |
|---|---|---|---|
| act_idx_idl_procinst | Ascending | ||
| act_idx_athrz_procedef | Ascending | ||
| act_idx_tskass_task | Ascending | ||
| act_idx_ident_lnk_group | Ascending | ||
| act_idx_ident_lnk_user | Ascending |
Columns Detail :
| Name | id_ |
| Table | act_ru_identitylink |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Primary Key | true |
| Not null | true |
| Name | rev_ |
| Table | act_ru_identitylink |
| Type | INTEGER |
| Domain |
| Name | group_id_ |
| Table | act_ru_identitylink |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | type_ |
| Table | act_ru_identitylink |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | user_id_ |
| Table | act_ru_identitylink |
| Type | CHARACTER VARYING(255) |
| Domain |
| Name | task_id_ |
| Table | act_ru_identitylink |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
| Name | proc_inst_id_ |
| Table | act_ru_identitylink |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
| Name | proc_def_id_ |
| Table | act_ru_identitylink |
| Type | CHARACTER VARYING(64) |
| Domain | |
| Foreign key | true |
Project
Alfresco Data model