oats_subdivision_designs

-1 rows


Description

A SUBDIVISION DESIGN is a document prepared by a surveyor to illustrate how a parcel of land will be subdivided into smaller parcels. This would typically be an unregisterd survey. The ALC is only interested in these designs for the purpose of accounting for what subdivisions where actually created as a result of a decision from the Commission.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subdivision_design_id int8 19 null
oats_subdiv_design_parcels.subdivision_design_id oats_sddp_subd_fk R

System generated sequence number to uniquely identify a SUBDIVISION DESIGN
alr_appl_component_id int8 19 null
oats_alr_appl_components.alr_appl_component_id oats_subd_apcp_fk R

System generated sequence number to uniquely identify an ALR APPL COMPONENT
received_date timestamp 29,6 null

Date the SUBDIVISION DESIGN was received by the ALC
road_dedication_area float8 17,17 null

The total area that is dedicated to the creation of roads
survey_plan_nbr varchar 12 √ null

Reference domain for Survey Plan Nbr
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_subdivision_designs_pkey Primary key Asc subdivision_design_id
oats_subd_apcp_fk_i Performance Asc alr_appl_component_id

Relationships

Close relationships within degrees of separation