Table sola.cadastre.cadastre_object_target
Used to identify cadastre objects that are being changed or cancelled by a cadastre related transaction (i.e. Change Cadastre or Redefine Cadastre). These changes are considered pending/unofficial and do not affect the registered state of the cadastre object until the transaction is approved. Note that new cadastre objects are created in the cadastre_object table with a status of pending and they are not recorded in this table.
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
transaction_id varchar 40
transaction.id cadastre_object_target_transaction_id_fk98 C
Identifier for the transaction the cadastre object is being affected by.
cadastre_object_id varchar 40
cadastre_object.id cadastre_object_target_cadastre_object_id_fk97 C
Identifier for the cadastre object.
geom_polygon geometry 2147483647  √  null The new geometry of the cadastre object as a result of the cadastre transaction.
rowidentifier varchar 40 uuid_generate_v1() Identifies the all change records for the row in the cadastre_object_target_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
transaction_id + cadastre_object_id Primary key Asc/Asc cadastre_object_target_pkey
cadastre_object_id Performance Asc cadastre_object_target_cadastre_object_id_fk97_ind
geom_polygon Performance Asc cadastre_object_target_index_on_geom_polygon
rowidentifier Performance Asc cadastre_object_target_index_on_rowidentifier
transaction_id Performance Asc cadastre_object_target_transaction_id_fk98_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  legal_space_utility_network.change_user  spatial_unit_in_group.rowidentifier  cadastre_object_node_target.rowidentifier  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_value_area.change_action  spatial_unit.change_action  spatial_unit_group.change_time  spatial_unit_address.change_time  spatial_value_area.rowversion  spatial_value_area.change_user  spatial_unit.rowversion  legal_space_utility_network.rowidentifier  cadastre_object.rowversion  spatial_unit_in_group.change_user  level.rowidentifier  spatial_unit_address.rowversion  spatial_unit_address.rowidentifier  cadastre_object_node_target.change_action