tbl_data_types

17 rows


Description

Specifies the types of quantification methods used in datasets, including definitions of each classification system.

Columns

Column Type Size Nulls Auto Children Parents Comments
data_type_id int4 10 √
tbl_datasets.data_type_id fk_datasets_data_type_id R
tbl_value_types.data_type_id tbl_value_types_data_type_id_fkey R

Primary key (automatically incremented).
data_type_group_id int4 10
tbl_data_type_groups.data_type_group_id fk_data_types_data_type_group_id R

Specifies the group to which this data type belongs.
data_type_name varchar(25) 25 √

The name of the data type, providing a descriptive label.
date_updated timestamptz 35,6 √
definition text 2147483647 √

A detailed explanation or description of the data type.

Indexes

Constraint Name Type Sort Column(s)
tbl_data_types_pkey Primary key Asc data_type_id
tbl_data_types_data_type_name_key Must be unique Asc data_type_name
tbl_data_types_data_type_name_unique Must be unique Asc data_type_name
tbl_data_types_norm_trgm Performance

Relationships

Close relationships within degrees of separation