tbl_value_types

0 rows


Description

Specifies actual type of values belonging to a value class

Columns

Column Type Size Nulls Auto Children Parents Comments
value_type_id int4 10
tbl_value_classes.value_type_id tbl_value_classes_value_type_id_fkey R
tbl_value_type_items.value_type_id tbl_value_type_items_value_type_id_fkey R

Primary key (automatically incremented).
unit_id int4 10 √
tbl_units.unit_id tbl_value_types_unit_id_fkey R

Links to the associated unit of measurement.
data_type_id int4 10 √
tbl_data_types.data_type_id tbl_value_types_data_type_id_fkey R

SEAD data type the value type is associated to.
name text 2147483647

The name of the value type.
base_type text 2147483647

The fundamental data type (e.g., integer, text).
precision int4 10 √

Specifies the level of precision for numerical values.
description text 2147483647

Additional details about the value type.
value_type_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_value_types_pkey Primary key Asc value_type_id
tbl_value_types_name_key Must be unique Asc name

Relationships

Close relationships within degrees of separation