Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
chroncontrolid | serial | 10 | √ | nextval('ndb.seq_chroncontrols_chroncontrolid'::regclass) |
|
|
An arbitrary Chronology Control identification number. |
|||||||||||
chronologyid | int4 | 10 | null |
|
|
Chronology to which the ChronControl belongs. Field links to the Chronolgies table. |
||||||||||||
chroncontroltypeid | int4 | 10 | √ | null |
|
|
The type of Chronology Control. Field links to the ChronControlTypes table. |
|||||||||||
depth | float8 | 17,17 | √ | null |
|
|
Depth of the Chronology Control in cm. |
|||||||||||
thickness | float8 | 17,17 | √ | null |
|
|
Thickness of the Chronology Control in cm. |
|||||||||||
age | float8 | 17,17 | √ | null |
|
|
Age of the Chronology Control. |
|||||||||||
agelimityounger | float8 | 17,17 | √ | null |
|
|
The younger age limit of a Chronology Control. This limit may be explicitly defined, for example the younger of the 2-sigma range limits of a calibrated radiocarbon date, or it may be more loosely defined, for example the younger limit on the range of dates for a biostratigraphic horizon. |
|||||||||||
agelimitolder | float8 | 17,17 | √ | null |
|
|
The older age limit of a Chronology Control. |
|||||||||||
notes | text | 2147483647 | √ | null |
|
|
Free form notes or comments about the Chronology Control. |
|||||||||||
recdatecreated | timestamp | 22 | timezone('UTC'::text, now()) |
|
|
|||||||||||||
recdatemodified | timestamp | 22 | null |
|
|
|||||||||||||
analysisunitid | int4 | 10 | √ | null |
|
|
||||||||||||
agetypeid | int4 | 10 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
chroncontrols_pkey | Primary key | Asc | chroncontrolid |
ccrchronage_idx | Performance | Asc | age |
ccroldage_idx | Performance | Asc | agelimitolder |
ccryoungage_idx | Performance | Asc | agelimityounger |