Table sola_cs.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 ?? ??? 16 22:01 ALMT 2015

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: legal_space_utility_network.rowidentifier  survey_point.change_time  survey_point.rowversion  cadastre_object.change_time  spatial_unit_address.change_action  spatial_unit_in_group.rowidentifier  spatial_unit.rowversion  survey_point.change_user  cadastre_object_node_target.change_time  survey_point.rowidentifier  cadastre_object_target.rowidentifier  legal_space_utility_network.change_action  cadastre_object_node_target.change_action  spatial_unit_group.rowversion  cadastre_object_target.rowversion  legal_space_utility_network.change_time  legal_space_utility_network.rowversion  cadastre_object_node_target.rowidentifier  spatial_unit_in_group.change_action  spatial_unit_group.change_user  cadastre_object_node_target.change_user  spatial_unit_address.change_time  cadastre_object_node_target.rowversion  spatial_unit_address.rowidentifier  cadastre_object_target.change_user  survey_point.change_action  spatial_unit.rowidentifier  cadastre_object_target.change_time  cadastre_object.rowversion  spatial_unit_address.rowversion  spatial_unit.change_user  spatial_unit.change_time  spatial_unit_address.change_user  spatial_unit_group.change_time  level.rowidentifier  spatial_unit_in_group.change_time  legal_space_utility_network.change_user  spatial_unit_group.rowidentifier  level.rowversion  spatial_unit_in_group.rowversion  cadastre_object_target.change_action  level.change_user  level.change_action  spatial_unit_in_group.change_user  spatial_unit_group.change_action  cadastre_object.rowidentifier  level.change_time  spatial_unit.change_action  cadastre_object.change_user  cadastre_object.change_action