oats_subject_properties

-1 rows


Description

A SUBJECT PROPERTY is the inclusion of a specific PROPERTY indicating it is the subject of an ALR APPLICATION or an ISSUE.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
subject_property_id int8 19 null
oats_documents.subject_property_id oats_od_sp_fk R
oats_property_interests.subject_property_id oats_prin_sbjp_fk R

System generated sequence number to uniquely identify a SUBJECT PROPERTY
property_id int8 19 null
oats_properties.property_id oats_sbjp_prty_fk R

System generated sequence number to uniquely identify a PROPERTY
alr_application_id int8 19 √ null
oats_alr_applications.alr_application_id oats_sbjp_appl_fk R

System generated sequence number to uniquely identify an ALR APPLICATION. This is also used as the ALR APPLICATION’S external reference number.
issue_id int8 19 √ null
oats_issues.issue_id oats_sbjp_issu_fk R

System generated sequence number to uniquely identify an ISSUE
alr_application_land_ind varchar 1 null

Indicates whether or not this is land under ALR APPLICATION or at ISSUE. No indicates the land is other land owned by the applicant within the local government which may be of interest.
purchase_date timestamp 29,6 √ null

Date the land was purchased by the land owner. Only the month and year are recorded, the day is truncated to 1
alr_area float8 17,17 √ null

Amount of area the PROPERTY that is in the ALR
farm_land_ind varchar 1 √ null

Indicates if the property is farm land.
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_subject_properties_pkey Primary key Asc subject_property_id

Check Constraints

Constraint Name Constraint
oats_sbjp_aali_chk (((alr_application_land_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))
oats_sbjp_chk ((((alr_application_id IS NOT NULL) AND (issue_id IS NULL)) OR ((alr_application_id IS NULL) AND (issue_id IS NOT NULL))))
oats_sp_isfi_000 (((farm_land_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation