Tables : alf_child_assoc


Columns

12

Keys

1

Triggers

0

Comment:

Description:

Indexes

4

Contraints

0


Columns :

Name Caption Primary Key type
id id true BIGINT
version version BIGINT
parent_node_id parent_node_id BIGINT
type_qname_id type_qname_id BIGINT
child_node_name_crc child_node_name_crc BIGINT
child_node_name child_node_name CHARACTER VARYING(50)
child_node_id child_node_id BIGINT
qname_ns_id qname_ns_id BIGINT
qname_localname qname_localname CHARACTER VARYING(255)
qname_crc qname_crc BIGINT
is_primary is_primary BOOLEAN
assoc_index assoc_index INTEGER

Keys :

Name Primary Key Description
alf_child_assoc_pkey true

Indexes

Name UNIQUE Type Description
idx_alf_cass_pri Ascending
idx_alf_cass_qncrc Ascending
idx_alf_cass_pnode Ascending
parent_node_id true Ascending

Columns Detail :

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

Name version
Table alf_child_assoc
Type BIGINT
Domain
Not null true

Name parent_node_id
Table alf_child_assoc
Type BIGINT
Domain
Not null true
Foreign key true

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

Name child_node_name_crc
Table alf_child_assoc
Type BIGINT
Domain
Not null true

Name child_node_name
Table alf_child_assoc
Type CHARACTER VARYING(50)
Domain
Not null true

Name child_node_id
Table alf_child_assoc
Type BIGINT
Domain
Not null true
Foreign key true

Name qname_ns_id
Table alf_child_assoc
Type BIGINT
Domain
Not null true
Foreign key true

Name qname_localname
Table alf_child_assoc
Type CHARACTER VARYING(255)
Domain
Not null true

Name qname_crc
Table alf_child_assoc
Type BIGINT
Domain
Not null true

Name is_primary
Table alf_child_assoc
Type BOOLEAN
Domain

Name assoc_index
Table alf_child_assoc
Type INTEGER
Domain

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description