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 |