SchemaSpy Analysis of sola.bulk_operation - ColumnsExtension to the LADM used by SOLA to implement Bulk Operation functionality such as loading of shapefiles and documents. Generated by
SchemaSpy
Generated by SchemaSpy on Tue May 31 09:57 NZST 2016
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

sola.bulk_operation contains 14 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
spatial_unit_temporary change_action bpchar 1 'i'::bpchar
spatial_unit_temporary rowversion int4 10 0
spatial_unit_temporary cadastre_object_type_code varchar 20  √  null The type of the cadastre object. Only applicable if the type_code is cadastre_object.
spatial_unit_temporary name_firstpart varchar 20  √  null The first part of the name for the cadastre object. Only applicable if the type_code is cadastre_object.
spatial_unit_temporary type_code varchar 20 The type of object that will be uploaded.
spatial_unit_temporary official_area numeric 29,2  √  null The official area for the cadastre object. Only applicable if the type_code is cadastre_object.
spatial_unit_temporary change_time timestamp 29,6 now()
spatial_unit_temporary id varchar 40 Identifier for the record.
spatial_unit_temporary rowidentifier varchar 40 uuid_generate_v1()
spatial_unit_temporary transaction_id varchar 40 The identifier of the transation associated to the bulk operation.
spatial_unit_temporary change_user varchar 50  √  null
spatial_unit_temporary 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.
spatial_unit_temporary label varchar 100  √  null The label to use for the spatial unit. Only applicable if the type_code IS NOT cadastre_object.
spatial_unit_temporary geom geometry 2147483647 The geometry for the spaital unit.