Tables : alf_node_properties


Columns

12

Keys

1

Triggers

0

Comment:

Description:

Indexes

5

Contraints

0


Columns :

Name Caption Primary Key type
node_id node_id true BIGINT
qname_id qname_id true BIGINT
list_index list_index true INTEGER
locale_id locale_id true BIGINT
boolean_value boolean_value BOOLEAN
long_value long_value BIGINT
float_value float_value REAL
double_value double_value DOUBLE PRECISION
string_value string_value CHARACTER VARYING(1024)
serializable_value serializable_value BYTEA
actual_type_n actual_type_n INTEGER
persisted_type_n persisted_type_n INTEGER

Keys :

Name Primary Key Description
alf_node_properties_pkey true

Indexes

Name UNIQUE Type Description
idx_alf_nprop_b Ascending
idx_alf_nprop_l Ascending
idx_alf_nprop_s Ascending
idx_alf_nprop_d Ascending
idx_alf_nprop_f Ascending

Columns Detail :

Name node_id
Table alf_node_properties
Type BIGINT
Domain
Primary Key true
Not null true
Foreign key true

Name qname_id
Table alf_node_properties
Type BIGINT
Domain
Primary Key true
Not null true
Foreign key true

Name list_index
Table alf_node_properties
Type INTEGER
Domain
Primary Key true
Not null true

Name locale_id
Table alf_node_properties
Type BIGINT
Domain
Primary Key true
Not null true
Foreign key true

Name boolean_value
Table alf_node_properties
Type BOOLEAN
Domain

Name long_value
Table alf_node_properties
Type BIGINT
Domain

Name float_value
Table alf_node_properties
Type REAL
Domain

Name double_value
Table alf_node_properties
Type DOUBLE PRECISION
Domain

Name string_value
Table alf_node_properties
Type CHARACTER VARYING(1024)
Domain

Name serializable_value
Table alf_node_properties
Type BYTEA
Domain

Name actual_type_n
Table alf_node_properties
Type INTEGER
Domain
Not null true

Name persisted_type_n
Table alf_node_properties
Type INTEGER
Domain
Not null true

Project

Alfresco Data model

Company

Author

Version

Copyright

Comment

Description