POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
An indication of the prevailing sea state at one particular location on the sea surface. There are two main components to the sea state, swell and waves. The swell is defined as the long, often massive crestless waves which are a product of a far off cause (as a gale). A wave is associated with the smaller often crested variety which are a product of the local weather conditions.
- 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).
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- end_time (O: TIMESTAMP)
end_time_cd (O: CHAR(1))
end_time_yr (O: FLOAT)
end_time_yp (O: INTEGER)
end_time_dy (O: INTEGER)
end_time_hr (O: INTEGER)
end_time_mt (O: INTEGER)
end_time_st (O: FLOAT)
end_time_of (O: FLOAT)
- pty_transient_property.end_time
The date and time of day designated as the end of the valid or effective time interval over which the property applies.
- 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.
- 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".
- start_time (O: TIMESTAMP)
start_time_cd (O: CHAR(1))
start_time_yr (O: FLOAT)
start_time_yp (O: INTEGER)
start_time_dy (O: INTEGER)
start_time_hr (O: INTEGER)
start_time_mt (O: INTEGER)
start_time_st (O: FLOAT)
start_time_of (O: FLOAT)
- pty_transient_property.start_time
The date and time of day that designated the start of the valid or effective time interval over which the property applies.
- swell_azimuth (O: FLOAT)
swell_azimuth_u (FNK, O: CHAR VARYING(15))
- pty_sea_state.swell_azimuth
The direction from which the swell emanates - expressed as an azimuth.
swell_azimuth_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- swell_height (O: FLOAT)
swell_height_u (FNK, O: CHAR VARYING(15))
- pty_sea_state.swell_height
The height of the swell.
swell_height_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- swell_period (O: FLOAT)
swell_period_u (FNK, O: CHAR VARYING(15))
- pty_sea_state.swell_period
The time which expires between the passing of two swell tops.
swell_period_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- wave_azimuth (O: FLOAT)
wave_azimuth_u (FNK, O: CHAR VARYING(15))
- pty_sea_state.wave_azimuth
The direction from which the waves are coming - expressed as an azimuth.
wave_azimuth_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- wave_height (O: FLOAT)
wave_height_u (FNK, O: CHAR VARYING(15))
- pty_sea_state.wave_height
The height of the waves.
wave_height_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- wave_period (O: FLOAT)
wave_period_u (FNK, O: CHAR VARYING(15))
- pty_sea_state.wave_period
The time which expires between the passing of two wave tops.
wave_period_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- activity_s (FSK, O: CHAR VARYING(19))
- process_data.activity
Defines the activity which created this instance.
Defines a foreign key to table activity.
- platform_s (FSK, O: CHAR VARYING(19))
- pty_sea_state.platform
Defines a foreign key to table general_facility.
- potential_field_platform_s (FSK, O: CHAR VARYING(19))
- pty_sea_state.potential_field_platform
Defines a foreign key to table general_facility.
- r_north_axis_direction (FNK, O: CHAR VARYING(80))
- pty_sea_state.ref_north_axis_direction
The meaning of North, e.g., true or magnetic. This is the direction from which an angular offset was measured.
Defines a foreign key to table r_north_axis_direction.
- r_transient_period (FNK, O: CHAR VARYING(80))
- pty_transient_property.ref_transient_period
The type of period over which the property applies, such as day, month, quarter, cumulative, etc.
Defines a foreign key to table r_transient_period.
- 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.
- swell_compass_direction (FNK, O: CHAR VARYING(80))
- pty_sea_state.swell_compass_direction
The direction from which the swell emanates - expressed by the use of a compass point.
Defines a foreign key to table r_compass_point.
- wave_compass_direction (FNK, O: CHAR VARYING(80))
- pty_sea_state.wave_compass_direction
The direction from which the waves are coming - expressed by the use of a compass point.
Defines a foreign key to table r_compass_point.
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 18:42:41 2001
© Copyright 2001 POSC. All rights reserved.