-
Notifications
You must be signed in to change notification settings - Fork 11
ws_rpt_inp_node
Barbara Rzepka edited this page Oct 6, 2022
·
7 revisions
Column name | Data type | Description | Example |
---|---|---|---|
id | serial4 | Id | |
result_id | varchar(30) | Id of the result | |
node_id | varchar(16) | Id of node | |
elevation | numeric(12, 3) | Elevation of the node | |
elev | numeric(12, 3) | ||
node_type | varchar(30) | Type of 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 | smallint | Main state of element, defined on value_state | |
state_type | smallint | Substate of element, defined on value_state_type | |
annotation | varchar(254) | Descript | |
demand | float8 | Demand value assigned to node | |
the_geom | geometry(Point,SRID) | Point geometry of element | |
expl_id | integer | Id of an exploitation, defined on exploitation | |
pattern_id | varchar(16) | Id of pattern assigned to the node | |
addparam | text | Additional parameters | |
nodeparent | varchar(16) | Id of nodearc created during model exportation | |
arcposition | int2 | ||
dma_id | int4 | Id of a district metering area, defined on dma | |
presszone_id | text | Presszone id | |
dqa_id | integer | Id of a quality sector, defined on dqa | |
minsector_id | integer | Id of a minimum sector | |
age | int4 | Age of a node |