tbl_data_types

17 rows


Description

Stores information about 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

Relationships

Close relationships within degrees of separation