Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| relativeageid | serial | 10 | √ | nextval('ndb.seq_relativeages_relativeageid'::regclass) |
|
|
An arbitrary Relative Age identification number. |
||||||||||
| relativeageunitid | int4 | 10 | null |
|
|
Relative Age Unit (e.g. «Marine isotope stage», «Land mammal age»). Field links to the RelativeAgeUnits lookup table. |
|||||||||||
| relativeagescaleid | int4 | 10 | null |
|
|
Relative Age Scale (e.g. «Geologic time scale», «Marine isotope stages»). Field links to the RelativeAgeScales lookup table. |
|||||||||||
| relativeage | varchar | 64 | null |
|
|
Relative Age (e.g. «Rancholabrean», a land mammal age; «MIS 11», marine isotope stage 11). |
|||||||||||
| c14ageyounger | float8 | 17,17 | √ | null |
|
|
Younger age of the Relative Age unit in 14C yr B.P. Applies only to Relative Age units within the radiocarbon time scale. |
||||||||||
| c14ageolder | float8 | 17,17 | √ | null |
|
|
Older age of the Relative Age unit in 14C yr B.P. Applies only to Relative Age units within the radiocarbon time scale. |
||||||||||
| calageyounger | float8 | 17,17 | √ | null |
|
|
Younger age of the Relative Age unit in calendar years. |
||||||||||
| calageolder | float8 | 17,17 | √ | null |
|
|
Older age of the Relative age unit in calendar years. |
||||||||||
| notes | text | 2147483647 | √ | null |
|
|
Free form notes or comments about Relative Age unit. |
||||||||||
| recdatecreated | timestamp | 22 | timezone('UTC'::text, now()) |
|
|
||||||||||||
| recdatemodified | timestamp | 22 | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| relativeages_pkey | Primary key | Asc | relativeageid |
| ix_relativeagescaleid_relativeages | Performance | Asc | relativeagescaleid |