POSC Specifications: Epicentre Version 3.0 | Relational Implementation |
A set of adjacent grid elements, defined by two bounding elements, that are modified by another grid. This may be grid refinement (large cells replaced by small cells) or grid coarsening (small cells replaced by large cells).
- instance_s (PK, M: CHAR VARYING(19))
- Surrogate key of the table.
- element_kind (M: CHAR VARYING(12))
- grid_modification.element_kind
The kind of element being used to delimit the refined portion of the target grid.
- first_element (M: INTEGER)
- grid_modification.first_element
The element of the target grid that is the lower bound of the portion being modified. For (i,j,k) in a 3D grid of (nx,ny,nz), the element is (i + (j-1)*ny + (k-1)*ny*nz).
- 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).
- second_element (M: INTEGER)
- grid_modification.second_element
The element of the target grid that is the upper bound of the portion being modified. For (i,j,k) in a 3D grid of (nx,ny,nz), the element is (i + (j-1)*ny + (k-1)*ny*nz).
- source_grid_s (FSK, M: CHAR VARYING(19))
source_grid_t (M: CHAR VARYING(30))
- grid_modification.source_grid
Indicates the grid that is being used as the modification to the target grid. The source grid replaces the portion of the target grid designated by this modification.
source_grid_s: Implements a foreign key to a row in one of the tables projected from entity grid_structured depending on the value of the next column (See below).
source_grid_t: Defines the name of the referenced table. Possible values are: grid_1d, grid_defined_grid (@grid_structured).
- target_grid_s (FSK, M: CHAR VARYING(19))
target_grid_t (M: CHAR VARYING(30))
- grid_modification.target_grid
Indicates the grid for which this modification is created to modify.
target_grid_s: Implements a foreign key to a row in one of the tables projected from entity grid_structured depending on the value of the next column (See below).
target_grid_t: Defines the name of the referenced table. Possible values are: grid_1d, grid_defined_grid (@grid_structured).
- 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_coarsening_modification, grid_refinement_modification.
- coarse_element_sl (O: CHAR VARYING(16))
- grid_coarsening_modification.coarse_element
This is the description of the coarse (target) element for each fine (source) element. This designates the coarse element that each of the fine elements is consolidated into. More than one fine element should be assigned to each coarse element.
- description (O: CHAR VARYING(2000))
- e_and_p_data.description
A remark or comment about the instance.
- duration (O: FLOAT)
duration_u (FNK, O: CHAR VARYING(15))
- transient_association.duration
Defines the duration of the association expressed in any valid units of time.
duration_u: Defines the unit of measure. Defines a foreign key to table r_unit_of_measure.
- 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)
- transient_association.end_time
End time of the association.
- 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.
- is_current (O: CHAR(1))
- transient_association.is_current
When TRUE, this flag indicates that this instance is designated as a current instance. This flag can be used in place of time based attributes or can be used in conjunction with them; however, it should not conflict with them.
- 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.
- parent_element_sl (O: CHAR VARYING(16))
- grid_refinement_modification.parent_element
This is the description of the parent (target) cell for each child (source) cell, allowing each child cell to have many parents. No record is made of the child cells pointing to each parent cell. Note that each child may record only one parent.
- 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)
- transient_association.start_time
Start time of the association.
- caused_by_s (FSK, O: CHAR VARYING(19))
- transient_association.caused_by
Specifies the activity which establishes this association.
Defines a foreign key to table activity.
- r_transient_period (FNK, O: CHAR VARYING(80))
- transient_association.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.
- terminated_by_s (FSK, O: CHAR VARYING(19))
- transient_association.terminated_by
Specifies the activity which established the termination of a transient association between two objects.
Defines a foreign key to table activity.
Table is related to: data_collection_content, document_specification_part, @graphical_element
Primary Key Constraint on: INSTANCE_S
Generated on Tue Jul 10 16:36:18 2001
© Copyright 2001 POSC. All rights reserved.