Tables : alf_access_control_list


Columns

12

Keys

1

Triggers

0

Comment:

Description:

Indexes

3

Contraints

0


Columns :

Name Caption Primary Key type
id id true BIGINT
acl_change_set acl_change_set BIGINT
version version BIGINT
acl_id acl_id CHARACTER VARYING(36)
latest latest BOOLEAN
acl_version acl_version BIGINT
inherits inherits BOOLEAN
inherits_from inherits_from BIGINT
type type INTEGER
inherited_acl inherited_acl BIGINT
is_versioned is_versioned BOOLEAN
requires_version requires_version BOOLEAN

Keys :

Name Primary Key Description
alf_access_control_list_pkey true

Indexes

Name UNIQUE Type Description
idx_alf_acl_acs Ascending
idx_alf_acl_inh Ascending
acl_id true Ascending

Columns Detail :

Name id
Table alf_access_control_list
Type BIGINT
Domain
Primary Key true
Not null true

Name acl_change_set
Table alf_access_control_list
Type BIGINT
Domain
Foreign key true

Name version
Table alf_access_control_list
Type BIGINT
Domain
Not null true

Name acl_id
Table alf_access_control_list
Type CHARACTER VARYING(36)
Domain
Not null true

Name latest
Table alf_access_control_list
Type BOOLEAN
Domain
Not null true

Name acl_version
Table alf_access_control_list
Type BIGINT
Domain
Not null true

Name inherits
Table alf_access_control_list
Type BOOLEAN
Domain
Not null true

Name inherits_from
Table alf_access_control_list
Type BIGINT
Domain

Name type
Table alf_access_control_list
Type INTEGER
Domain
Not null true

Name inherited_acl
Table alf_access_control_list
Type BIGINT
Domain

Name is_versioned
Table alf_access_control_list
Type BOOLEAN
Domain
Not null true

Name requires_version
Table alf_access_control_list
Type BOOLEAN
Domain
Not null true

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description