oats_subdiv_design_parcels

-1 rows


Description

A SUBDIV DESIGN PARCEL is a parcel of land that is being proposed to be created as part of a SUBDIVISION DESIGN.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subdiv_design_parcel_id int8 19 null
oats_subdiv_parcel_intents.subdiv_design_parcel_id oats_sdpi_sddp_fk R

System generated sequence number to uniquely identify a SUBDIV DESIGN PARCEL
subdivision_design_id int8 19 null
oats_subdivision_designs.subdivision_design_id oats_sddp_subd_fk R

System generated sequence number to uniquely identify a SUBDIVISION DESIGN
parcel_area float8 17,17 null

The surface area of the parcel
fully_in_alr_ind varchar 1 null

Indicates whether or not the parcel is completely in the ALR or not
remainder_ind varchar 1 null

Indicates whether or not the parcel was created as a result of not explicitly being included in a survey plan and is referenced in the survey plan as the remainder of the original parcel
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_subdiv_design_parcels_pkey Primary key Asc subdiv_design_parcel_id
oats_sddp_subd_fk_i Performance Asc subdivision_design_id

Check Constraints

Constraint Name Constraint
avcon_1238100890_fully_000 ((fully_in_alr_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))
avcon_1238100890_remai_000 ((remainder_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[]))

Relationships

Close relationships within degrees of separation