Table sola_cs.administrative.ba_unit_as_party
Associates BA Unit directly to Party. Implementation of the LADM LA_BAUnit to LA_Party relationship. Not used by SOLA.
Tags: LADM Reference Object, Not Used

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
ba_unit_id varchar 40
ba_unit.id ba_unit_as_party_ba_unit_id_fk71 C
Identifier for the BA Unit.
party_id varchar 40
party.id ba_unit_as_party_party_id_fk72 C
Identifier for the Party.
rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the ba_unit_as_party table

Analyzed at ?? ??? 16 22:00 ALMT 2015

Indexes:
Column(s) Type Sort Constraint Name
ba_unit_id + party_id Primary key Asc/Asc ba_unit_as_party_pkey
ba_unit_id Performance Asc ba_unit_as_party_ba_unit_id_fk71_ind
party_id Performance Asc ba_unit_as_party_party_id_fk72_ind

Close relationships  within of separation:

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