Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| relativechronid | serial | 10 | √ | nextval('ndb.seq_relativechronology_relativechronid'::regclass) |
|
|
An arbitrary Relative Chronology identification number. |
|||
| analysisunitid | int4 | 10 | null |
|
|
Analysis Unit identification number. Field links to the AnalysisUnits table. |
||||
| relativeageid | int4 | 10 | null |
|
|
Relative Age identification number. Field links to the RelativeAges lookup table. |
||||
| notes | text | 2147483647 | √ | null |
|
|
Free form notes or comments. |
|||
| recdatecreated | timestamp | 22 | timezone('UTC'::text, now()) |
|
|
|||||
| recdatemodified | timestamp | 22 | null |
|
|
|||||
| chroncontrolid | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| relativechronology_pkey | Primary key | Asc | relativechronid |
| ix_analysisunitid_relativechronology | Performance | Asc | analysisunitid |
| ix_relativeageid_relativechronology | Performance | Asc | relativeageid |