cat_node - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of nodes, which defines its basic characteristics.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | integer | Id of node definition | AIR VALVE DN50 |
| nodetype_id | character varying(30) | Node type related to the catalog value, defined on cat_feature cat_feature and cat_feature_node | AIR_VALVE |
| matcat_id | character varying(30) | Id of material defined on cat_material | FD |
| pnom | integer | Nominal pressure | 16 |
| dnom | integer | Nominal diameter | 50 |
| dint | numeric(12,4) | Interior diameter | 102.00000 |
| dext | text | Exterior diameter | |
| shape | integer | Shape of node, defined on cat_node_shape (UD) | |
| descript | character varying(30) | Description | Air valve 50mm |
| link | character varying(30) | Link | c:\users\users\catalog.pdf |
| brand | character varying(30) | Brand defined on cat_brand | |
| model | character varying(30) | Model defined on cat_brand_model | |
| svg | character varying(50) | Svg visualized on QGIS | junction.svg |
| estimated_depth | text | Estimated depth used for budget calculation if depth data is missing (m) | 1.00 |
| cost_unit | character varying(30) | Measurement units | u |
| cost | character varying(30) | Price of the node, related with price defined on plan_price | N_AIRVAL_DN50 |
| active | boolean | If true, catalog value is being used | TRUE |
| label | character varying(255) | Label visualized on QGIS | |
| ischange | smallint | Defines if there is a possibility of a change of dn/pn/material. 0-false, 1-true, 2-maybe | 2 |
| acoeff | double precision | Coefficient for calculating the replacement value |