A spatial model of the earth surface and subsurface, containing a network of earth model objects, such as rock and fluid bodies.
instance_s (PK, M: CHAR VARYING(19))
Surrogate key of the table.
identifier (M: CHAR VARYING(80))
earth_model.identifier
The label by which an earth model is identified.
instance_create_date (O: TIMESTAMP)
e_and_p_data.instance_create_date
This is the date that this instance was created. This date is defined by the source if imported, or is the date the instance is created if a new instance.
last_updated (O: TIMESTAMP)
e_and_p_data.last_updated
This is the date that this instance was last updated. This value should be updated when any part of this instance is altered (except for inverse relationships).
description (O: CHAR VARYING(2000))
e_and_p_data.description
A remark or comment about the instance.
instance_creator (O: CHAR VARYING(80))
e_and_p_data.instance_creator
This is the person, company or application that created this instance. This identifies the party responsible for loading this instance.
last_updated_by (O: CHAR VARYING(80))
e_and_p_data.last_updated_by
This records the person or application making the update to this instance.
source (O: CHAR VARYING(80))
e_and_p_data.source
The provider of this instance, which is usually a data provider for imported/purchased data. If this instance is provided by POSC, then this attribute must be "POSC".
status (O: CHAR VARYING(11))
earth_model.status
This is the status of this earth model. PROVISIONAL indicates that the earth model is under construction or is being evaluated but is not yet valid, CURRENT indicates that the earth model is valid, and DEPRICATED indicates that the earth model is no longer valid.
kind (FNK, O: CHAR VARYING(80))
earth_model.kind
This is the type of this earth model. This describes the primary purpose for which the earth model was created or is intended to be used.
Defines a foreign key to table r_earth_model.