global_varunitID

194 rows


Description

The global_varunitID table stores variable units for those compilations whose values involve different units of measurement.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
V_UNITID serial 10 √ nextval('"global_varunitID_seq"'::regclass)
char_DataCore.CHARMEASID <--V_UNITID_for_CHARMEASID_from_global_varunitID_fkey R
char_DataCore.CHARSIZEID <--V_UNITID_for_CHARSIZEID_from_global_varunitID_fkey R
char_DataCore.WHATAMI <--V_UNITID_for_WHATAMI_from_global_varunitID_fkey R
global_varunitID.PARENTID global_varunitid_fk R
V_UNITABBR text 2147483647 null
V_UNITNAME text 2147483647 √ null
PARENTID int2 5 √ null
global_varunitID.V_UNITID global_varunitid_fk R
CREATED_AT timestamptz 35,6 timezone('UTC'::text, now())

Is record timestamp with timezone based on UTC
UPDATED_AT timestamptz 35,6 √ timezone('UTC'::text, now())

Is timestamp of record update with timezone based on UTC

Indexes

Constraint Name Type Sort Column(s)
global_varunitID_pkey Primary key Asc V_UNITID
global_varunitID_V_UNITABBR_ukey Must be unique Asc V_UNITABBR
global_varunitid_V_UNITNAME_ukey Must be unique Asc V_UNITNAME

Relationships

Close relationships within degrees of separation