Table sola.administrative.ba_unit_area
Identifies the overall area of the BA Unit. This should be the sum of all parcel areas that are part of the BA Unit.
Tags: FLOSS SOLA Extension, 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
id varchar 40 Identifier for the BA Unit Area.
ba_unit_id varchar 40
ba_unit.id ba_unit_area_ba_unit_id_fk77 C
Identifier for the BA Unit this area value is associated to.
type_code varchar 20
area_type.code ba_unit_area_type_code_fk78 R
The type of area. E.g. officialArea, calculatedArea, etc.
size numeric 19,2 The value of the area. Must be in metres squared and can be converted for display if requried.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the ba_unit_area_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
id Primary key Asc ba_unit_area_pkey
ba_unit_id Performance Asc ba_unit_area_ba_unit_id_fk77_ind
rowidentifier Performance Asc ba_unit_area_index_on_rowidentifier
type_code Performance Asc ba_unit_area_type_code_fk78_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.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  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.change_time  source_describes_ba_unit.change_time  rrr.change_time  notation.change_user  ba_unit_target.rowversion  ba_unit.rowidentifier  rrr.rowversion  party_for_rrr.change_action  ba_unit_as_party.rowidentifier  ba_unit_target.rowidentifier  source_describes_ba_unit.change_user  mortgage_isbased_in_rrr.rowidentifier  rrr.change_user  ba_unit.change_action  required_relationship_baunit.change_user  notifiable_party_for_baunit.rowidentifier  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