Table sola.bulk_operation.spatial_unit_temporary
Used as a staging area when loading spatial objects with the bulk operations functionality. Data in this table is validated and any field values generated (e.g. name_firstpart) prior to transferring the data into the cadastre object table.
Tags: FLOSS SOLA Extension

 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 record.
transaction_id varchar 40
transaction.id spatial_unit_temporary_transaction_id_fk132 C
The identifier of the transation associated to the bulk operation.
type_code varchar 20 The type of object that will be uploaded.
cadastre_object_type_code varchar 20  √  null
cadastre_object_type.code spatial_unit_temporary_cadastre_object_type_code_fk133 R
The type of the cadastre object. Only applicable if the type_code is cadastre_object.
name_firstpart varchar 20  √  null The first part of the name for the cadastre object. Only applicable if the type_code is cadastre_object.
name_lastpart varchar 50  √  null The last or remaining part of the name for the cadastre object. Only applicable if the type_code is cadastre_object.
geom geometry 2147483647 The geometry for the spaital unit.
official_area numeric 29,2  √  null The official area for the cadastre object. Only applicable if the type_code is cadastre_object.
label varchar 100  √  null The label to use for the spatial unit. Only applicable if the type_code IS NOT cadastre_object.
rowidentifier varchar 40 uuid_generate_v1()
rowversion int4 10 0
change_action bpchar 1 'i'::bpchar
change_user varchar 50  √  null
change_time timestamp 29,6 now()

Analyzed at Tue May 31 09:57 NZST 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc spatial_unit_temporary_pkey
cadastre_object_type_code Performance Asc spatial_unit_temporary_cadastre_object_type_code_fk133_ind
geom Performance Asc spatial_unit_temporary_index_on_geom
rowidentifier Performance Asc spatial_unit_temporary_index_on_rowidentifier
transaction_id Performance Asc spatial_unit_temporary_transaction_id_fk132_ind

Close relationships: