Tables : alf_node


Columns

13

Keys

1

Triggers

0

Comment:

Description:

Indexes

8

Contraints

0


Columns :

Name Caption Primary Key type
id id true BIGINT
uuid uuid CHARACTER VARYING(36)
transaction_id transaction_id BIGINT
type_qname_id type_qname_id BIGINT
locale_id locale_id BIGINT
acl_id acl_id BIGINT
audit_creator audit_creator CHARACTER VARYING(255)
audit_created audit_created CHARACTER VARYING(30)
audit_modifier audit_modifier CHARACTER VARYING(255)
audit_modified audit_modified CHARACTER VARYING(30)
audit_accessed audit_accessed CHARACTER VARYING(30)
version version BIGINT
store_id store_id BIGINT

Keys :

Name Primary Key Description
alf_node_pkey true

Indexes

Name UNIQUE Type Description
idx_alf_node_mod Ascending
idx_alf_node_mor Ascending
idx_alf_node_crd Ascending
idx_alf_node_cor Ascending
idx_alf_node_mdq Ascending
store_id true Ascending
idx_alf_node_tqn Ascending
idx_alf_node_txn_type Ascending

Columns Detail :

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

Name uuid
Table alf_node
Type CHARACTER VARYING(36)
Domain
Not null true

Name transaction_id
Table alf_node
Type BIGINT
Domain
Not null true
Foreign key true

Name type_qname_id
Table alf_node
Type BIGINT
Domain
Not null true
Foreign key true

Name locale_id
Table alf_node
Type BIGINT
Domain
Not null true
Foreign key true

Name acl_id
Table alf_node
Type BIGINT
Domain
Foreign key true

Name audit_creator
Table alf_node
Type CHARACTER VARYING(255)
Domain

Name audit_created
Table alf_node
Type CHARACTER VARYING(30)
Domain

Name audit_modifier
Table alf_node
Type CHARACTER VARYING(255)
Domain

Name audit_modified
Table alf_node
Type CHARACTER VARYING(30)
Domain

Name audit_accessed
Table alf_node
Type CHARACTER VARYING(30)
Domain

Name version
Table alf_node
Type BIGINT
Domain
Not null true

Name store_id
Table alf_node
Type BIGINT
Domain
Not null true
Foreign key true

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description