oats_nonfarm_use_subtype_codes

-1 rows


Description

A NONFARM USE SUBTYPE CODE is a more specific non-agricultural use of land under the classification of a NONFARM USE TYPE CODE. For example: Under the NONFARM USE TYPE CODE: Industrial - Sawmill - Workshop Under the NONFARM USE TYPE CODE: Civic - Religious edifice - Playground

Columns

Column Type Size Nulls Auto Default Children Parents Comments
nonfarm_use_type_code varchar 10 null
oats_alr_appl_components.nonfarm_use_type_code oats_apcp_nfst_fk R
oats_nonfarm_use_type_codes.nonfarm_use_type_code oats_nfst_nftc_fk R

User supplied value to uniquely identify a NONFARM USE TYPE CODE
nonfarm_use_subtype_code varchar 10 null
oats_alr_appl_components.nonfarm_use_subtype_code oats_apcp_nfst_fk R

User supplied value to uniquely identify a NONFARM USE SUBTYPE CODE
description varchar 100 null

Description of the NONFARM USE SUBTYPE CODE
system_required_ind varchar 1 null

Indicates whether or not the code is required by the system. If yes, the users would be prevented from updating or deleting the code value.
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_nonfarm_use_subtype_codes_pkey Primary key Asc/Asc nonfarm_use_type_code + nonfarm_use_subtype_code
oats_nfst_nftc_fk_i Performance Asc nonfarm_use_type_code

Check Constraints

Constraint Name Constraint
avcon_1238100890_syste_015 (((system_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation