fos_fosmat2ID

47 rows


Description

Is FosSahul lookup table for the type of dated material (= FOSMAT2)

Columns

Column Type Size Nulls Auto Default Children Parents Comments
FOSMAT2ID int2 5 null
fos_DataCore.FOSMAT2ID <--FOSMAT2ID_from_fos_fosmat2ID_fkey R
FOSMAT2 text 2147483647 null
FOSMAT2ABB 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)
FOS_fosmat2ID_pkey Primary key Asc FOSMAT2ID
fos_fosmat2id_FOSMAT2_ukey Must be unique Asc FOSMAT2
fos_fosmat2id_FOSMAT2ABB_ukey Must be unique Asc FOSMAT2ABB

Relationships