Skip to content

cat_node

Edgar Fuste edited this page Nov 2, 2021 · 1 revision

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_mat_node 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
Clone this wiki locally