Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| strat_id | serial | 10 | √ | nextval('dic_lithostrat_strat_id_seq'::regclass) |
|
|
PK. Unique identifier. Autogenerated. |
||||
| strat_name | varchar | 100 | √ | null |
|
|
Short version of the stratigraphic name (without the rank) |
||||
| strat_name_long | varchar | 100 | √ | null |
|
|
Full strat name (i.e. with rank e.g. “Formation” included) |
||||
| rank | varchar | 10 | √ | null |
|
|
Macrostrat. text, the stratigraphic rank of the unit |
||||
| macrostrat_id | int4 | 10 | √ | null |
|
|
Macrostrat (only, not populated for SGP-added names). integer, unique identifier for known stratigraphic name(s). |
||||
| concept_id | int4 | 10 | √ | null |
|
|
Macrostrat. intger, unique identifier for the stratigraphic name concept, which groups variant strat_names for same entity |
||||
| bed | varchar | 100 | √ | null |
|
|
Macrostrat. string, the strat_name of the bed |
||||
| bed_id | int4 | 10 | √ | null |
|
|
Macrostrat. integer, the strat_name_id of the bed |
||||
| mbr | varchar | 100 | √ | null |
|
|
Macrostrat. string, the strat_name of the member |
||||
| mbr_id | int4 | 10 | √ | null |
|
|
Macrostrat. integer, the strat_name_id of the member |
||||
| fm | varchar | 100 | √ | null |
|
|
Macrostrat. string, the strat_name of the formation |
||||
| fm_id | int4 | 10 | √ | null |
|
|
Macrostrat. integer, the strat_name_id of the formation |
||||
| gp | varchar | 100 | √ | null |
|
|
Macrostrat. string, the strat_name of the group |
||||
| gp_id | int4 | 10 | √ | null |
|
|
Macrostrat. integer, the strat_name_id of the group |
||||
| sgp | varchar | 100 | √ | null |
|
|
Macrostrat. string, the strat_name of the supergroup |
||||
| sgp_id | int4 | 10 | √ | null |
|
|
Macrostrat. integer, the strat_name_id of the supergroup |
||||
| b_age | numeric | 12,6 | √ | null |
|
|
Macrostrat (only). number, continuous time age model estimated for initiation, in Myr before present |
||||
| t_age | numeric | 12,6 | √ | null |
|
|
Macrostrat (only). number, continuous time age model estimated for truncation, in Myr before present |
||||
| gsc_lexicon | varchar | 100 | √ | null |
|
|
Geological Survey Canada Weblex code |
||||
| t_units | int4 | 10 | √ | null |
|
|
Macrostrat |
||||
| timestamp_created | timestamptz | 35,6 | now() |
|
|
||||||
| timestamp_modified | timestamptz | 35,6 | √ | now() |
|
|
|||||
| bgs_code | varchar | 10 | √ | null |
|
|
British Geological Survey code. |
||||
| asud_stratno | int4 | 10 | √ | null |
|
|
Australian Stratigraphic Units Database stratno |
||||
| is_informal | bool | 1 | √ | null |
|
|
Whether or not the stratigraphic name is informal |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| strat_id | Primary key | Asc | strat_id |
| dic_lithostrat_lower_idx | Performance | ||
| dic_lithostrat_strat_name_idx | Performance | Asc | strat_name |
| dic_lithostrat_strat_name_long_idx | Performance | Asc | strat_name_long |
Relationships
Close relationships within degrees of separation
