POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A 1D grid defining a 1D index. Each grid specifies a) the axis points, b) whether the grid forms a loop or not, and c) the coordinates to be used to describe each grid node.
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- connected (M: CHAR(1))
- grid_1d.connected
This describes the behavior where the last point in the grid is connected to the first point of the grid. If TRUE then the last point of the grid is connected to the first point (i.e., the grid connects as a loop and the first point may be reached by going past the last point). If FALSE, the first and last points are unconnected and the first point may not be directly reached from the last point. This behavior does not impact the population of a subset of the grid (e.g., if a connected 30 point grid is populated from points 5 to 20, this does NOT mean that point 20 connects to point 5).
- identifier (M: CHAR VARYING(80))
- grid_or_mesh.identifier
The name or identifier of this grid.
- 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).
- entity_type_nm (M: CHAR VARYING(30))
- Column that contains the name of the entity that this row is an instance of in case a table represents multiple entities. Possible values are: grid_1d_equal, grid_1d_parametric, grid_1d_unequal.
- coordinate_value_sl (O: CHAR VARYING(16))
- grid_1d_unequal.coordinate_value
The axis coordinate values, indexed by point number.
- 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.
- missing_element_sl (O: CHAR VARYING(16))
- grid_structured.missing_element
This indicates the missing elements of the structured grid. Missing elements are excluded from the grid and cannot be assigned properties. The highest order of elements allowed in the grid must be used (i.e., cells in a 3D grid). For grids composed of other grids, the behavior is cumulative with the composed grid inheriting the behavior of the component grids. For example, in seismic, a 2D binset grid may have missing elements such that the grid is "L" shaped. If a 3D grid (cube) is formed using the 2D binset grid and a 1D vertical time grid then the "columns" of the cube should be considered missing.
- origin (O: FLOAT)
origin_u (FNK, O: CHAR VARYING(15))
origin_q (FNK, O: CHAR VARYING(80))
- grid_1d_equal.origin
The coordinate value of the first point of the axis.
origin_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
origin_q: Specifies the type of quantity. Defines a foreign key to table r_quantity_type.
- point_count (O: INTEGER)
- grid_1d_equal.point_count
The number of points of the axis.
grid_1d_parametric.point_count
The number of points of the axis.
- 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".
- step (O: FLOAT)
step_u (FNK, O: CHAR VARYING(15))
step_q (FNK, O: CHAR VARYING(80))
- grid_1d_equal.step
The increase in coordinate value between two successive axis points.
step_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
step_q: Specifies the type of quantity. Defines a foreign key to table r_quantity_type.
- property_kind_s (FSK, O: CHAR VARYING(19))
- grid_1d_equal.property_kind
This designates the property used for the origin and step.
Defines a foreign key to table property_kind.
Table is related to: geophysical_processing_grid, data_collection_content, derived_interest_makeup, document_specification_part, @graphical_element, grid_composition, grid_modification, object_activity_involvement, geophysical_geometry_set
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:35:41 2001
© Copyright 2001 POSC. All rights reserved.