sys_feature_cat - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of system feature's definition and it's relation with other system catalog's values.
Fields:
| Column name | Data type | Description | Example | Domain values |
|---|---|---|---|---|
| id | character varying(30) | System id of feature catalog, non-customizable | ELEMENT |
WS:[ELEMENT, EXPANSIONTANK, FILTER, FLEXUNION, FOUNTAIN, GREENTAP, HYDRANT, JUNCTION, MANHOLE, METER, NETELEMENT, NETSAMPLEPOINT, NETWJOIN, PIPE, PUMP, REDUCTION, REGISTER, SOURCE, TANK, TAP, VALVE, VARC, WATERWELL, WJOIN, WTP] UD:[CHAMBER, CONDUIT, CONNEC, ELEMENT, GULLY, JUNCTION, MANHOLE, NETELEMENT, NETGULLY, NETINIT, OUTFALL, SIPHON, STORAGE, VALVE, VARC, WACCEL, WJUMP, WWTP] |
| type | character varying(30) | System type of feature, non-customizable, defined on sys_feature_type | ELEMENT |
[ARC, CONNEC, GULLY, ELEMENT, NODE] |
| epa_default | character varying(16) | Default value of feature type used by the model, non-customizable | NONE |
WS:[JUNCTION, NONE, PIPE, PUMP, RESERVOIR, SHORTPIPE, TANK, VALVE] UD:[CONDUIT, JUNCTION, NONE, OUTFALL, SIPHON, STORAGE, STORAGE, VIRTUAL] |
| man_table | character varying(16) | Name of a man table, where model related data is being saved | man_junction |
WS:[man_expansiontank, man_filter, man_flexunion, man_fountain, man_greentap, man_hydrant, man_junction, man_manhole, man_meter, man_netelement, man_netsamplepoint, man_netwjoin, man_pipe, man_pump, man_reduction, man_register, man_source, man_tank, man_tap, man_valve, man_varc, man_waterwell, man_wjoin, man_wtp] UD:[man_chamber, man_conduit, man_junction, man_manhole, man_netelement, man_netgully, man_netinit, man_outfall, man_siphon, man_storage, man_valve, man_varc, man_waccel, man_wjump, man_wwtp] |