c14_calprogram

195 rows


Description

The c14_calprogram table stores computer programmes – incl. their versions – that may be used for radiocarbon calibration.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
CALPROGID serial 10 √ nextval('"c14_calprogram_CALPROGID_seq"'::regclass)
c14_calprogram.PARENTID c14_calprogram_fk R
char_DataCore.CALPROGID <--CALPROGID_from_c14_calprogram_fkey R
CALPROGRAM text 2147483647 null
CALPROGVER text 2147483647 √ null
CALPROGREF text 2147483647 √ null
global_RefCore.REFDBID <--REFDBID_from_global_RefCore_fkey R
PARENTID int2 5 null
c14_calprogram.CALPROGID c14_calprogram_fk R
CALPRODATE varchar 10 √ null
CALPRONOTE text 2147483647 √ null
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)
c14_calprogram_pkey Primary key Asc CALPROGID
c14_calprogram_ukey Must be unique Asc/Asc CALPROGRAM + CALPROGVER

Relationships

Close relationships within degrees of separation