Table sola.administrative.ba_unit
A Basic Administrative Unit a.k.a. BA Unit or Property. Used to link the rights and restrictions over one or more parcels to the parties that hold those rights and restrictions. A right must be homogeneous over the entire BA Unit. Implementation of the LADM LA_BAUnit class.
Tags: LADM Reference Object, Change History

Generated by
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 40
application_property.ba_unit_id application_property_ba_unit_id_fk124 R
ba_unit_area.ba_unit_id ba_unit_area_ba_unit_id_fk77 C
ba_unit_as_party.ba_unit_id ba_unit_as_party_ba_unit_id_fk71 C
ba_unit_contains_spatial_unit.ba_unit_id ba_unit_contains_spatial_unit_ba_unit_id_fk68 C
ba_unit_target.ba_unit_id ba_unit_target_ba_unit_id_fk83 C
notation.ba_unit_id notation_ba_unit_id_fk75 C
required_relationship_baunit.from_ba_unit_id required_relationship_baunit_from_ba_unit_id_fk52 C
required_relationship_baunit.to_ba_unit_id required_relationship_baunit_to_ba_unit_id_fk53 C
rrr.ba_unit_id rrr_ba_unit_id_fk42 C
source_describes_ba_unit.ba_unit_id source_describes_ba_unit_ba_unit_id_fk50 C
LADM Definition: Identifier for the BA Unit.
type_code varchar 20 'basicPropertyUnit'::character varying
ba_unit_type.code ba_unit_type_code_fk38 R
LADM Definition: The type of BA Unit. E.g. basicPropertyUnit, administrativeUnit, etc.
name varchar 255  √  null LADM Definition: The name of the BA Unit. Usually a concatenation of the name_firstpart and name_lastpart formatted as required.
name_firstpart varchar 20 SOLA Extension: The first part of the name or reference assigned by the land administration agency to identify the property.
name_lastpart varchar 50 SOLA Extension: The remaining part of the name or reference assigned by the land administration agency to identify the property.
creation_date timestamp 29,6  √  null SOLA Extension: The datetime the BA Unit is formally recognised by the land administration agency (i.e. registered or issued).
expiration_date timestamp 29,6  √  null SOLA Extension: The datetime the BA Unit was superseded and became historic.
status_code varchar 20 'pending'::character varying
reg_status_type.code ba_unit_status_code_fk39 R
LADM Definition: The status of the BA unit.
transaction_id varchar 40  √  null ba_unit_transaction_id_fk40 C
SOLA Extension: Reference to the SOLA transaction that created the BA Unit.
rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the ba_unit_as_party table
rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar SOLA Extension: Indicates if the last data modification action that occurred to the row was insert (i), update (u) or delete (d).
change_user varchar 50  √  null SOLA Extension: The user id of the last person to modify the row.
change_time timestamp 29,6 now() SOLA Extension: The date and time the row was last modified.
classification_code varchar 20  √  null FROM SOLA State Land Extension: The security classification for this Ba Unit. Only users with the security classification (or a higher classification) will be able to view the record. If null, the record is considered unrestricted.
redact_code varchar 20  √  null FROM SOLA State Land Extension: The redact classification for this Ba Unit. Only users with the redact classification (or a higher classification) will be able to view the record with un-redacted fields. If null, the record is considered unrestricted and no redaction to the record will occur unless bulk redaction classifications have been set for fields of the record.

Analyzed at Tue May 31 09:56 NZST 2016

Column(s) Type Sort Constraint Name
id Primary key Asc ba_unit_pkey
rowidentifier Performance Asc ba_unit_index_on_rowidentifier
status_code Performance Asc ba_unit_status_code_fk39_ind
transaction_id Performance Asc ba_unit_transaction_id_fk40_ind
type_code Performance Asc ba_unit_type_code_fk38_ind

Close relationships  within of separation:

Excluded from diagram's relationships: notation.rowidentifier  source_describes_ba_unit.rowidentifier  required_relationship_baunit.change_action  source_describes_rrr.change_time  source_describes_ba_unit.change_action  source_describes_rrr.rowversion  mortgage_isbased_in_rrr.change_user  notifiable_party_for_baunit.change_time  condition_for_rrr.change_action  rrr.rowidentifier  ba_unit_contains_spatial_unit.rowversion  source_describes_rrr.change_user  mortgage_isbased_in_rrr.rowversion  rrr_share.change_time  source_describes_rrr.rowidentifier  party_for_rrr.rowidentifier  notation.change_action  rrr_share.change_action  mortgage_isbased_in_rrr.change_action  ba_unit_target.change_time  party_for_rrr.rowversion  notation.change_time  notation.rowversion  rrr_share.rowidentifier  rrr.change_action  source_describes_ba_unit.rowversion  required_relationship_baunit.rowversion  rrr_share.change_user  condition_for_rrr.change_time  required_relationship_baunit.rowidentifier  rrr_share.rowversion  condition_for_rrr.rowidentifier  party_for_rrr.change_user  source_describes_rrr.change_action  ba_unit_contains_spatial_unit.rowidentifier  party_for_rrr.change_time  notifiable_party_for_baunit.rowversion  condition_for_rrr.rowversion  ba_unit_contains_spatial_unit.change_user  ba_unit_contains_spatial_unit.change_time  ba_unit_target.change_user  required_relationship_baunit.change_time  condition_for_rrr.change_user  ba_unit_area.rowidentifier  source_describes_ba_unit.change_time  rrr.change_time  notation.change_user  ba_unit_target.rowversion  ba_unit_area.rowversion  rrr.rowversion  party_for_rrr.change_action  ba_unit_as_party.rowidentifier  ba_unit_target.rowidentifier  ba_unit_area.change_user  source_describes_ba_unit.change_user  mortgage_isbased_in_rrr.rowidentifier  ba_unit_area.change_action  rrr.change_user  required_relationship_baunit.change_user  notifiable_party_for_baunit.rowidentifier  ba_unit_area.change_time  ba_unit_target.change_action  ba_unit_contains_spatial_unit.change_action  notifiable_party_for_baunit.change_user  notifiable_party_for_baunit.change_action  mortgage_isbased_in_rrr.change_time