| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| strat_id | serial | 10 | √ | nextval('dic_lithostrat_strat_id_seq'::regclass) |
|
|
PK. Unique identifier. Generated by database |
|||
| strat_name | varchar | 100 | √ | null |
|
|
From Macrostrat: text, informal unit name |
|||
| strat_name_long | varchar | 100 | √ | null |
|
|
text, informal unit name |
|||
| rank | varchar | 10 | √ | null |
|
|
From Macrostrat: text, the stratigraphic rank of the unit |
|||
| macrostrat_id | int4 | 10 | √ | null |
|
|
From Macrostrat where it is known as ‘strat_name_id’: integer, unique identifier for known stratigraphic name (see /defs/strat_names) |
|||
| concept_id | int4 | 10 | √ | null |
|
|
From Macrostrat: intger, unique identifier for the stratigraphic name concept, which groups variant strat_names for same entity |
|||
| bed | varchar | 100 | √ | null |
|
|
From Macrostrat: string, the strat_name of the bed |
|||
| bed_id | int4 | 10 | √ | null |
|
|
From Macrostrat: integer, the strat_name_id of the bed |
|||
| mbr | varchar | 100 | √ | null |
|
|
From Macrostrat: text, lithostratigraphic member |
|||
| mbr_id | int4 | 10 | √ | null |
|
|
From Macrostrat: integer, the strat_name_id of the member |
dic_lithostrat
21 624 rows
Dictionary of lithostratigraphic names, populated from Macrostrat (in Nov 2015, up to lithostrat_id 80624), with subsequent additions in the same format. Columns were adopted directly from Macrostrat, and therefore some may not be directly relevent to SGP - for example concept_id. They are nevertheless retained in case they prove useful for cross-referencing. Table also includes identifiers from national stratigraphic databases i.e. BGS, GSC, and ASUD
