Table sola.cadastre.spatial_value_area
Identifies the area of a 2 dimensional spatial unit.
Implementation of the LADM LA_AreaValue class.
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
spatial_unit_id varchar 40
spatial_unit.id spatial_value_area_spatial_unit_id_fk87 C
Spatial unit identifier.
type_code varchar 20
area_type.code spatial_value_area_type_code_fk88 C
The type of the spatial value area. E.g. officialArea, calculatedArea, etc.
size numeric 29,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 spatial_value_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:57 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
spatial_unit_id + type_code Primary key Asc/Asc spatial_value_area_pkey
rowidentifier Performance Asc spatial_value_area_index_on_rowidentifier
spatial_unit_id Performance Asc spatial_value_area_spatial_unit_id_fk87_ind
type_code Performance Asc spatial_value_area_type_code_fk88_ind

Close relationships  within of separation:

Excluded from diagram's relationships: cadastre_object.rowidentifier  spatial_unit_group.change_action  level.change_time  cadastre_object_node_target.rowversion  spatial_unit_address.change_action  survey_point.rowidentifier  spatial_unit_address.change_user  survey_point.change_time  spatial_unit_group.rowversion  spatial_unit_in_group.change_action  level.change_user  legal_space_utility_network.change_user  spatial_unit_in_group.rowidentifier  cadastre_object_node_target.rowidentifier  cadastre_object_target.change_time  legal_space_utility_network.change_time  cadastre_object.change_user  spatial_unit.rowidentifier  legal_space_utility_network.rowversion  cadastre_object_node_target.change_time  spatial_unit_in_group.rowversion  survey_point.change_action  cadastre_object_node_target.change_user  cadastre_object.change_time  spatial_unit.change_user  spatial_unit_group.rowidentifier  survey_point.change_user  spatial_unit_in_group.change_time  spatial_unit.change_time  level.rowversion  level.change_action  cadastre_object.change_action  survey_point.rowversion  legal_space_utility_network.change_action  spatial_unit_group.change_user  spatial_unit.change_action  cadastre_object_target.change_user  spatial_unit_group.change_time  spatial_unit_address.change_time  cadastre_object_target.rowversion  cadastre_object_target.rowidentifier  spatial_unit.rowversion  legal_space_utility_network.rowidentifier  cadastre_object.rowversion  spatial_unit_in_group.change_user  cadastre_object_target.change_action  level.rowidentifier  spatial_unit_address.rowversion  spatial_unit_address.rowidentifier  cadastre_object_node_target.change_action