A point in geologic time, measured in thousands, millions, or billions of years.

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

Surrogate key of the table.


data_value (M: FLOAT)
data_value_u (FNK, M: CHAR VARYING(15))

pty_geologic_age.data_value
Time expressed in years, millions of years, or billions of years.
data_value_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.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.fossil_taxon

Defines a foreign key to table fossil_taxon.


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

pty_geologic_age.geologic_process

Defines a foreign key to table geologic_proc.


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

pty_geologic_age.mineral_type

Defines a foreign key to table mineral_type.


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.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.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.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.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_event_s (FSK, O: CHAR VARYING(19))

pty_geologic_age.temporal_event

Defines a foreign key to table temporal_object.