A period of geologic time, specified by the beginning and ending ages.

p_geol_age_rng_s (PK, M: CHAR VARYING(19))

Surrogate key of the table.


earlier_age (O: FLOAT)
earlier_age_u (FNK, O: CHAR VARYING(15))

pty_geologic_age_range.earlier_age
The age of the beginning of a geologic age period. This would correspond to the time most distant from present day.
earlier_age_u: Defines the unit of measure. Defines a foreign key to table r_uom.


later_age (O: FLOAT)
later_age_u (FNK, O: CHAR VARYING(15))

pty_geologic_age_range.later_age
The age of the end of a geologic age period. This corresponds to the age closer to the present day.
later_age_u: Defines the unit of measure. Defines a foreign key to table r_uom.


preferred_flag (O: CHAR(1))

property.preferred_flag
The flag is set to True if this instance of property is the preferred value in this data store of this type of property for the object which this property describes.


activity_s (FSK, O: CHAR VARYING(19))
activity_t (O: CHAR VARYING(16))

process_data.activity
Defines the activity which created this instance.
activity_s: Implements a foreign key to a row in one of the tables projected from entity activity depending on the value of the next column (See below).
activity_t: Defines the name of the referenced table. Possible values are defined in @activity.


feature_bnd_s (FSK, O: CHAR VARYING(19))
feature_bnd_t (O: CHAR VARYING(16))

pty_geologic_age_range.feature_boundary

feature_bnd_s: Implements a foreign key to a row in one of the tables projected from entity feature_boundary depending on the value of the next column (See below).
feature_bnd_t: Defines the name of the referenced table. Possible values are defined in @feature_boundary.


fossil_taxon (FNK, O: CHAR VARYING(40))

pty_geologic_age_range.fossil_taxon

Defines a foreign key to table fossil_taxon.


geologic_proc_s (FSK, O: CHAR VARYING(19))

pty_geologic_age_range.geologic_process

Defines a foreign key to table geologic_proc.


other_sptl_obj_s (FSK, O: CHAR VARYING(19))
other_sptl_obj_t (O: CHAR VARYING(16))

property.other_spatial_object

other_sptl_obj_s: Implements a foreign key to a row in one of the tables projected from entity other_spatial_object depending on the value of the next column (See below).
other_sptl_obj_t: Defines the name of the referenced table. Possible values are defined in @other_spatial_object.


pos_on_esrf_s (FSK, O: CHAR VARYING(19))
pos_on_esrf_t (O: CHAR VARYING(16))

pty_geologic_age_range.position_on_earth_surface

pos_on_esrf_s: Implements a foreign key to a row in one of the tables projected from entity position_on_earth_surface depending on the value of the next column (See below).
pos_on_esrf_t: Defines the name of the referenced table. Possible values are defined in @position_on_earth_surface.


rsvr_fl_sys_s (FSK, O: CHAR VARYING(19))

pty_geologic_age_range.reservoir_fluid_system

Defines a foreign key to table rsvr_fl_sys.


rock_fluid_ftr_s (FSK, O: CHAR VARYING(19))
rock_fluid_ftr_t (O: CHAR VARYING(16))

pty_geologic_age_range.rock_fluid_feature

rock_fluid_ftr_s: Implements a foreign key to a row in one of the tables projected from entity rock_fluid_feature depending on the value of the next column (See below).
rock_fluid_ftr_t: Defines the name of the referenced table. Possible values are: aquifer, pool, reservoir, reservoir_part (@rock_fluid_feature).


rock_material_s (FSK, O: CHAR VARYING(19))
rock_material_t (O: CHAR VARYING(16))

pty_geologic_age_range.rock_material

rock_material_s: Implements a foreign key to a row in one of the tables projected from entity rock_material depending on the value of the next column (See below).
rock_material_t: Defines the name of the referenced table. Possible values are defined in @rock_material.


temporal_period_s (FSK, O: CHAR VARYING(19))

pty_geologic_age_range.temporal_period

Defines a foreign key to table temporal_object.