tbl_units

15 rows


Description

Table storing definitions of measurement units (e.g., mm for millimeters).

Columns

Column Type Size Nulls Auto Children Parents Comments
unit_id int4 10 √
tbl_dimensions.unit_id fk_dimensions_unit_id R
tbl_methods.unit_id fk_methods_unit_id R
tbl_value_types.unit_id tbl_value_types_unit_id_fkey R

Primary key (automatically incremented).
date_updated timestamptz 35,6 √
description text 2147483647 √

A detailed explanation or description of the measurement unit.
unit_abbrev varchar(15) 15 √

The abbreviation of the measurement unit (e.g., ‘mm’ for millimeters).
unit_name varchar(50) 50

The full name of the measurement unit (e.g., ‘millimeters’).

Indexes

Constraint Name Type Sort Column(s)
tbl_units_pkey Primary key Asc unit_id
tbl_units_unit_abbrev_key Must be unique Asc unit_abbrev
tbl_units_unit_abbrev_unique Must be unique Asc unit_abbrev
tbl_units_unit_name_key Must be unique Asc unit_name
tbl_units_unit_name_unique Must be unique Asc unit_name

Relationships

Close relationships within degrees of separation