Tables : alf_access_control_entry
Columns7 |
Keys1 |
Triggers0 |
Comment:Description: |
|
Indexes1 |
Contraints0 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id | id | true | BIGINT |
| version | version | BIGINT | |
| permission_id | permission_id | BIGINT | |
| authority_id | authority_id | BIGINT | |
| allowed | allowed | BOOLEAN | |
| applies | applies | INTEGER | |
| context_id | context_id | BIGINT |
Keys :
| Name | Primary Key | Description |
|---|---|---|
| alf_access_control_entry_pkey | true |
Indexes
| Name | UNIQUE | Type | Description |
|---|---|---|---|
| permission_id | true | Ascending |
Columns Detail :
| Name | id |
| Table | alf_access_control_entry |
| Type | BIGINT |
| Domain | |
| Primary Key | true |
| Not null | true |
| Name | version |
| Table | alf_access_control_entry |
| Type | BIGINT |
| Domain | |
| Not null | true |
| Name | permission_id |
| Table | alf_access_control_entry |
| Type | BIGINT |
| Domain | |
| Not null | true |
| Foreign key | true |
| Name | authority_id |
| Table | alf_access_control_entry |
| Type | BIGINT |
| Domain | |
| Not null | true |
| Foreign key | true |
| Name | allowed |
| Table | alf_access_control_entry |
| Type | BOOLEAN |
| Domain | |
| Not null | true |
| Name | applies |
| Table | alf_access_control_entry |
| Type | INTEGER |
| Domain | |
| Not null | true |
| Name | context_id |
| Table | alf_access_control_entry |
| Type | BIGINT |
| Domain | |
| Foreign key | true |
Project
Alfresco Data model