cat_connec - Giswater/giswater_dbmodel GitHub Wiki
Description:
Catalog of connecs (point of the network connection to the building), which defines its basic characteristics.
Fields:
| Column name | Data type | Description | Example |
|---|---|---|---|
| id | character varying(30) | Id of connec definition | PVC25-PN16-DOM |
| connectype_id | character varying(18) | Arc type related to the catalog value, defined on cat_feature and cat_feature_connec | WJOIN |
| matcat_id | character varying(16) | Id of material defined on cat_mat_node | PVC |
| pnom | character varying(16) | Nominal pressure | 16 |
| dnom | character varying(16) | Nominal diameter | 25 |
| dint | numeric(12,5) | Interior diameter | |
| dext | numeric(12,5) | Exterior diameter | |
| descript | character varying(512) | Description | PVC connec |
| link | character varying(512) | Link | |
| 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 | |
| cost_ut | character varying(16) | Cost of unit, related with price defined on plan_price | N_WATER-CONNECT |
| cost_ml | character varying(16) | Cost of linear meter, related with price defined on plan_price | A_PVC25_PN10 |
| cost_m3 | character varying(16) | Cost of m3, related with price defined on plan_price | S_EXC |
| active | boolean | If true, catalog value is being used | TRUE |
| label | character varying(255) | Label visualized on QGIS |