oats_local_gov_services

-1 rows


Description

A LOCAL GOV SERVICE is the inclusion of a specific type of infrastructure service (as identified by LOCAL GOV SERVICE CODE) that can be provided by a local government asserting that service is provided to the SUBJECT PROPERTIES under the ALR APPLICATION.

Columns

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

System generated sequence number to uniquely identify a LOCAL GOV SERVICE
alr_application_id int8 19 null
oats_alr_applications.alr_application_id oats_lgsv_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.
local_gov_service_code varchar 10 null
oats_local_gov_service_codes.local_gov_service_code oats_lgsv_lgsc_fk R

User supplied value to uniquely identify a LOCAL GOV SERVICE CODE
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_local_gov_services_pkey Primary key Asc local_gov_service_id
oats_lgsv_appl_fk_i Performance Asc alr_application_id
oats_lgsv_lgsc_fk_i Performance Asc local_gov_service_code
oats_lgsv_uk Must be unique Asc/Asc alr_application_id + local_gov_service_code
oats_local_gov_services_alr_application_id_local_gov_servic_key Must be unique Asc/Asc alr_application_id + local_gov_service_code

Relationships

Close relationships within degrees of separation