Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| age_id | serial | 10 | √ | nextval('geol_age_age_id_seq'::regclass) |
|
|
PK. Unique identifier for the reported age. Generated by database |
|||
| ics_id | int4 | 10 | √ | null |
|
|
FK. ID for the formal ICS age. Links to the dic_ics_age table, a dictionary of International Commission on Stratigraphy age names. |
|||
| verbatim_age | varchar | 50 | √ | null |
|
|
Verbatim age as reported in publication, or by contributors. |
|||
| timestamp_created | timestamptz | 35,6 | now() |
|
|
|||||
| timestamp_modified | timestamptz | 35,6 | √ | now() |
|
|
||||
| age_notes | varchar | 4000 | √ | null |
|
|
Notes about how the age was determined. |
|||
| age_modifier | varchar | 10 | √ | null |
|
|
Upper, middle,lower - where not part of the official ICS name. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| geol_age_id | Primary key | Asc | age_id |
| verbatim_age_idx | Performance |
Relationships
Close relationships within degrees of separation
