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 |
| ||||||
|
sola.bulk_operation contains 14 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
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 | change_action | bpchar | 1 | 'i'::bpchar | |||
spatial_unit_temporary | change_time | timestamp | 29,6 | now() | |||
spatial_unit_temporary | change_user | varchar | 50 | √ | null | ||
spatial_unit_temporary | geom | geometry | 2147483647 | The geometry for the spaital unit. | |||
spatial_unit_temporary | id | varchar | 40 | Identifier for the record. | |||
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 | 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 | 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 | 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 | rowidentifier | varchar | 40 | uuid_generate_v1() | |||
spatial_unit_temporary | rowversion | int4 | 10 | 0 | |||
spatial_unit_temporary | transaction_id | varchar | 40 | The identifier of the transation associated to the bulk operation. | |||
spatial_unit_temporary | type_code | varchar | 20 | The type of object that will be uploaded. |