tbl_value_classes

54 rows


Description

Specifies a value class describing e.g. a data column

Columns

Column Type Size Nulls Auto Children Parents Comments
value_class_id int4 10
tbl_analysis_values.value_class_id tbl_analysis_values_value_class_id_fkey R
tbl_value_classes.parent_id tbl_value_classes_parent_id_fkey R

Primary key (automatically incremented).
value_type_id int4 10
tbl_value_types.value_type_id tbl_value_classes_value_type_id_fkey R

Identifies the type of value associated with the class.
method_id int4 10
tbl_methods.method_id tbl_value_classes_method_id_fkey R

Links to the method associated with the value class.
parent_id int4 10 √
tbl_value_classes.value_class_id tbl_value_classes_parent_id_fkey R

References a parent value class for hierarchical structuring.
name varchar(80) 80

The name of the value class.
description text 2147483647

Provides details about the value class.
value_class_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_value_classes_pkey Primary key Asc value_class_id

Relationships

Close relationships within degrees of separation