Table sola.administrative.required_relationship_baunit
Identifies relationships between BA Units. Implementation of the LADM LA_RequiredRelationshipBAUnit class. Used by SOLA to represent a range of relationships such as linking a new BA Unit to the BA Unit it supersedes (a.k.a Prior Title) as well as geographic relationships such as all property within a village, or all villages within a region or island, etc.
Tags: LADM Reference Object, Change History

 Generated by
SchemaSpy
Legend: SourceForge.net
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
from_ba_unit_id varchar 40
ba_unit.id required_relationship_baunit_from_ba_unit_id_fk52 C
The originating BA Unit (a.k.a. parent BA Unit). Usually a parent BA Unit will have multiple child BA Units associted to it. E.g. Island/region is the parent BA Unit for a town
to_ba_unit_id varchar 40
ba_unit.id required_relationship_baunit_to_ba_unit_id_fk53 C
The target BA Unit (a.k.a. child BA Unit). For any given relationship type, the child BA Unit will usually only have one logical parent BA Unit. E.g. A new title is the child BA Unit of the original title that is being superseded.
relation_code varchar 20
ba_unit_rel_type.code required_relationship_baunit_relation_code_fk54 R
Code that identifies the type of relationship between the two BA Units.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the required_relationship_baunit_historic table
rowversion int4 10 0 Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar 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 The user id of the last person to modify the row.
change_time timestamp 29,6 now() The date and time the row was last modified.

Analyzed at Tue May 31 09:56 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
from_ba_unit_id + to_ba_unit_id Primary key Asc/Asc required_relationship_baunit_pkey
from_ba_unit_id Performance Asc required_relationship_baunit_from_ba_unit_id_fk52_ind
rowidentifier Performance Asc required_relationship_baunit_index_on_rowidentifier
relation_code Performance Asc required_relationship_baunit_relation_code_fk54_ind
to_ba_unit_id Performance Asc required_relationship_baunit_to_ba_unit_id_fk53_ind

Close relationships  within of separation:

Excluded from diagram's relationships: notation.rowidentifier  source_describes_ba_unit.rowidentifier  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.rowversion  ba_unit_target.change_time  party_for_rrr.rowversion  notation.change_time  notation.rowversion  rrr_share.rowidentifier  rrr.change_action  ba_unit.change_user  source_describes_ba_unit.rowversion  rrr_share.change_user  condition_for_rrr.change_time  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  condition_for_rrr.change_user  ba_unit.change_time  ba_unit_area.rowidentifier  source_describes_ba_unit.change_time  rrr.change_time  notation.change_user  ba_unit_target.rowversion  ba_unit.rowidentifier  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  ba_unit.change_action  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