POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
Defines the chassis orientation at each node of a grid. The orientation is defined in the following terms: "chassis inclination", "chassis azimuth" and "chassis rotation" The "chassis inclination" is the inclination of the positive axis from downward vertical. The "chassis azimuth" is the azimuth of the "chassis inclination" with respect to "north". The "chassis rotation" is the horizontal rotation of the chassis reference direction marking clockwise from "north".
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- 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).
- r_north_axis_direction (FNK, M: CHAR VARYING(80))
- pty_chassis_orientation_array.ref_north_axis_direction
The meaning of North, e.g., true or magnetic.
Defines a foreign key to table r_north_axis_direction.
- azimuth (O: FLOAT)
azimuth_u (FNK, O: CHAR VARYING(15))
- pty_chassis_orientation_array.azimuth
The azimuth of the chassis inclination with respect to "north". This value asserts that all nodes of the grid have the same chassis azimuth.
azimuth_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- data_value_sl (O: CHAR VARYING(16))
- pty_chassis_orientation_array.data_value
The orientation of the chassis at each node of a grid. Described using one or more of the following values: "inclination", "azimuth" and "rotation".
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- inclination (O: FLOAT)
inclination_u (FNK, O: CHAR VARYING(15))
- pty_chassis_orientation_array.inclination
The inclination of the direction of initial ground motion relative to a downward vertical axis. This value asserts that the source facility for all source events have the same chassis inclination.
inclination_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- 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.
- 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.
- rotation (O: CHAR(1))
- pty_chassis_orientation_array.rotation
The horizontal rotation of the chassis "reference direction marking" clockwise from "north". This value asserts that all nodes of the grid have the same chassis rotation.
- 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".
- activity_s (FSK, O: CHAR VARYING(19))
- process_data.activity
Defines the activity which created this instance.
Defines a foreign key to table activity.
- receiver_definition_s (FSK, O: CHAR VARYING(19))
- pty_chassis_orientation_array.receiver_definition
May be a property of seismic geometry set. The grid used must match the grid specified by attribute receiver uid in the associated seismic geometry set (i.e., fixed facilities). If receiver uid is not defined in seismic geometry set then the grid must be the same as was defined by attribute field trace uid (i.e., moving facilities).
Defines a foreign key to table geophysical_geometry_set.
- represent_s (FSK, O: CHAR VARYING(19))
represent_t (O: CHAR VARYING(30))
- property.represent
This is the property that is the original for which this representation is an equivalent representation.
represent_s: Implements a foreign key to a row in one of the tables projected from entity property depending on the value of the next column (See below).
represent_t: Defines the name of the referenced table. Possible values are defined in @property.
- source_definition_s (FSK, O: CHAR VARYING(19))
- pty_chassis_orientation_array.source_definition
May be a property of seismic geometry set. The grid must be the same as was defined by attribute source event uid in the associated seismic geometry set.
Defines a foreign key to table geophysical_geometry_set.
Table is related to: data_collection_content, document_specification_part, @graphical_element, process_data_item, @property
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 17:27:45 2001
© Copyright 2001 POSC. All rights reserved.