ud_audit_psector_node_traceability - Giswater/giswater_dbmodel GitHub Wiki
Description:
Traceability table where information about nodes of executed or canceled psectors are stored. In the first rows you can find information from plan_psector_x_node and after that an exact copy of the node table.
Features on that table no longer exists on inventroy tables.
Node fields:
| Column name | Data type | Description |
|---|---|---|
| id | serial4 | Id (automatically assigned on insert) |
| psector_id | int4 | Id of psector |
| psector_state | int2 | State of psector |
| doable | bool | If true, feature value enters into calculation of psector budget |
| addparam | json | Additional parameters |
| audit_tstamp | timestamp | Date and time of audit data insert |
| audit_user | text | |
| action | varchar(16) | |
| node_id | varchar(16) | Id of node |
| code | varchar(30) | Internal code of a type |
| top_elev | numeric(12, 3) | Top elevation at which the element is located |
| ymax | numeric(12, 3) | Depth of the element |
| elev | numeric(12, 3) | Bottom elevation of the element |
| custom_top_elev | numeric(12, 3) | Personalized value of top elevation at which the element is located. Prevails in the calculation over value of top_elev |
| custom_ymax | numeric(12, 3) | Personalized value of depth of the element. Prevails in the calculation over value of ymax |
| custom_elev | numeric(12, 3) | Personalized value of bottom elevation of the element. Prevails in the calculation over value of elev |
| node_type | varchar(30) | Node type, defined on cat_feature_node |
| nodecat_id | varchar(30) | Id of node catalog, defined on cat_node |
| epa_type | varchar(16) | Node type related to EPA classification, defined on sys_feature_epa_type |
| sector_id | int4 | Id of a hydraulic sector, defined on sector |
| state | int2 | Main state of element, defined on value_state |
| state_type | int2 | Substate of element, defined on value_state_type |
| annotation | text | Description |
| observ | text | Description |
| "comment" | text | Description |
| dma_id | int4 | Id of a district management area, defined on dma |
| soilcat_id | varchar(16) | Soil on which the element is located, defined on cat_soil |
| function_type | varchar(50) | Function of the element, defined on man_type_function |
| category_type | varchar(50) | Function of the element, defined on man_type_category |
| fluid_type | varchar(50) | Function of the element, defined on man_type_fluid |
| location_type | varchar(50) | Function of the element, defined on man_type_location |
| workcat_id | varchar(255) | Work code related to construction of the element, defined on cat_work |
| workcat_id_end | varchar(255) | Work code related to disassemble of the element, defined on cat_work |
| buildercat_id | varchar(30) | Constructor of element, defined on cat_builder |
| builtdate | date | Data of construction |
| enddate | date | Data of disassemble |
| ownercat_id | varchar(30) | Owner of the element, defined on cat_owner |
| muni_id | int4 | Municipality in which element is located, defined on ext_municipality |
| postcode | varchar(16) | Postcode of element's location |
| streetaxis_id | varchar(16) | Street in which element is located, defined on ext_streetaxis |
| postnumber | int4 | Post number of the element's location, defined on ext_address |
| postcomplement | varchar(100) | Additional number of the element's location |
| streetaxis2_id | varchar(16) | Street in which element is located, defined on ext_streetaxis (used in to define location as from street to street |
| postnumber2 | int4 | Post number of the element's location, situated on the second street, defined on ext_address |
| postcomplement2 | varchar(100) | Additional number of the element's location, situated on the second street |
| descript | text | Description |
| rotation | numeric(6, 3) | Rotation of element's symbol |
| link | varchar(512) | Link |
| verified | varchar(20) | Level of data verification, define edit_typevalue (value_verified) |
| link | varchar(512) | Link |
| the_geom | the_geom public.geometry(point, SRID_VALUE) | Point geometry of element |
| undelete | bool | If true, element can't be deleted |
| label_x | varchar(30) | Coordinate x of label location |
| label_y | varchar(30) | Coordinate y of label location |
| label_rotation | numeric(6, 3) | Rotation of element's label |
| publish | bool | If true, element is being published |
| inventory | bool | If true, element is a part of company's inventory |
| xyz_date | date | Date of field data collection |
| uncertain | bool | If true, element has data with little reliability |
| unconnected | bool | If true, element is topologicaly connected with the network |
| expl_id | bool | Id of an exploitation, defined on exploitation |
| num_value | numeric(12, 3) | Additional numeric field |
| feature_type | varchar(16) | Type of feature (automatically assigned on insert) |
| tstamp | timestamp | Date and time of data insert |
| arc_id | varchar(16) | Id of arc with which element is related (In case of topologically disconected nodes) |
| lastupdate | timestamp | Date and time of last data update |
| lastupdate_user | varchar(50) | User that executed last update |
| insert_user | varchar(50) | User that inserted data |
| matcat_id | varchar(16) | Id of material, used in case when material is not specified on node catalog, defined on cat_mat_node |
| district_id | int4 | District in which element is located, defined on ext_district |
| workcat_id_plan | varchar(255) | |
| asset_id | varchar(50) | Id of a financial asset |
| drainzone_id | int4 | Id of drainzone |
| parent_id | varchar(16) | |
| expl_id2 | int4 | Id of a second exploitation, defined on exploitation |