Table sola.cadastre.legal_space_utility_network
LADM Defintion: A utility network concerns legal space, which does not necessarily coincide with the physical space of a utility network. Implementation of the LADM LA_LegalSpaceUtilityNetwork class. Not used by SOLA.
Tags: LADM Reference Object, Change History, 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
id varchar 40
cadastre_object.id legal_space_utility_network_id_fk94 C
LADM Definition: Legal space utility network identifier.
ext_physical_network_id varchar 40  √  null LADM Definition: External identifier for a physical utility network.
status_code varchar 20  √  null
utility_network_status_type.code legal_space_utility_network_status_code_fk95 R
LADM Definition: Status code for the legal space utility network.
type_code varchar 20
utility_network_type.code legal_space_utility_network_type_code_fk96 R
LADM Definition: Type code for the legal space utility network.
geom geometry 2147483647  √  null LADM Definition: Not provided.
rowidentifier varchar 40 uuid_generate_v1() SOLA Extension: Identifies the all change records for the row in the legal_space_utility_network_historic table
rowversion int4 10 0 SOLA Extension: Sequential value indicating the number of times this row has been modified.
change_action bpchar 1 'i'::bpchar SOLA Extension: 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 SOLA Extension: The user id of the last person to modify the row.
change_time timestamp 29,6 now() SOLA Extension: 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
id Primary key Asc legal_space_utility_network_pkey
id Performance Asc legal_space_utility_network_id_fk94_ind
geom Performance Asc legal_space_utility_network_index_on_geom
rowidentifier Performance Asc legal_space_utility_network_index_on_rowidentifier
status_code Performance Asc legal_space_utility_network_status_code_fk95_ind
type_code Performance Asc legal_space_utility_network_type_code_fk96_ind

Close relationships  within of separation:

Excluded from diagram's relationships: cadastre_object.rowidentifier  spatial_unit_group.change_action  spatial_value_area.rowidentifier  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_value_area.change_time  spatial_unit_in_group.change_action  level.change_user  spatial_unit_in_group.rowidentifier  cadastre_object_node_target.rowidentifier  cadastre_object_target.change_time  cadastre_object.change_user  spatial_unit.rowidentifier  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  spatial_unit_group.change_user  spatial_value_area.change_action  spatial_unit.change_action  cadastre_object_target.change_user  spatial_unit_group.change_time  spatial_unit_address.change_time  cadastre_object_target.rowversion  spatial_value_area.rowversion  spatial_value_area.change_user  cadastre_object_target.rowidentifier  spatial_unit.rowversion  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