oats_soil_change_elements

-1 rows


Description

A SOIL CHANGE ELEMENT is the details of a specific soil change (remove soil, add fill) proposal or decision.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
soil_change_element_id int8 19 null

System generated sequence number to uniquely identify a SOIL CHANGE PARTICULAR
alr_appl_component_id int8 19 null
oats_alr_appl_components.alr_appl_component_id oats_scel_apcp_fk R

System generated sequence number to uniquely identify an ALR APPL COMPONENT
soil_change_code varchar 10 null
oats_soil_change_codes.soil_change_code oats_scel_sccd_fk R

User supplied value to uniquely identify a SOIL CHANGE CODE
volume float8 17,17 null

The volume in cubic meters of soil removed, or fill added
depth float8 17,17 null

The depth in meters to which fill will be placed or soil removed
material_desc varchar 4000 √ null

Description of the soil being removed, or the fill being placed
material_origin_desc varchar 4000 √ null

Description of the origin ofthe fill being placed
alternative_measures_desc varchar 4000 √ null

Description of any alternative measure that have been considored.
project_duration int2 5 √ null

The duration of the project.
project_area float8 17,17 √ null

The area effected by the project.
who_created varchar 32 null

WHO CREATED is the IDIR or Oracle userid of the person who created the record.
when_created timestamp 29,6 null

WHEN CREATED is the date/time that the record was created.
who_updated varchar 32 √ null

WHO UPDATED is the IDIR or Oracle userid of the person who last updated the record.
when_updated timestamp 29,6 √ null

WHEN UPDATED is the date/time that the record was last updated.
revision_count int8 19 0

REVISION COUNT is used by Hibernate to control optimistic locking

Indexes

Constraint Name Type Sort Column(s)
oats_soil_change_elements_pkey Primary key Asc soil_change_element_id

Relationships

Close relationships within degrees of separation