ws_connec - Giswater/giswater_dbmodel GitHub Wiki
Description:
Data of all connections features of inventory is stored on two main tables - connec and it's corresponing man table (listed below), which depends on feature's definition on cat_feature_connec. Fields of connec table are common for all types of connections. In man table the specific information, related with the most common characteristics of the equipment is stored. Inserting, updating and deleting data using views (parent view - ve_connec or child views defined on cat_feature) automatically performs data procedures on the correct tables and captures default values.
Connec fields:
| Column name | Data type | Description |
|---|---|---|
| connec_id | character varying(16) | Id (automatically assigned on insert) |
| code | character varying(30) | Element code from previous system |
| elevation | numeric(12,4) | Elevation at which the element is located |
| depth | numeric(12,4) | Depth of the element |
| connecat_id | character varying(30) | Id of connec catalog, defined on cat_connec |
| sector_id | integer | Id of a hydraulic sector, defined on sector |
| customer_code | character varying(30) | Code of the subscriber, that allows connection with subscriber management application |
| state | smallint | Main state of element, defined on value_state |
| state_type | smallint | Substate of element, defined on value_state_type |
| arc_id | character varying(16) | Id of arc with which element is related |
| connec_length | numeric(12,3) | Length of the connection |
| annotation | text | Description |
| observ | text | Description |
| comment | text | Description |
| dma_id | integer | Id of a district metering area, defined on dma |
| presszone_id | character varying(30) | Id of a pressure zone, defined on presszone |
| soilcat_id | character varying(30) | Soil on which the element is located, defined on cat_soil |
| function_type | character varying(50) | Function of the element, defined on man_type_function |
| category_type | character varying(50) | Function of the element, defined on man_type_category |
| fluid_type | character varying(50) | Function of the element, defined on man_type_fluid |
| location_type | character varying(50) | Function of the element, defined on man_type_location |
| workcat_id | character varying(255) | Work code related to construction of the element, defined on cat_work |
| workcat_id_end | character varying(255) | Work code related to disassemble of the element, defined on cat_work |
| buildercat_id | character varying(30) | Constructor of element, defined on cat_builder |
| builtdate | date | Data of construction |
| enddate | date | Data of disassemble |
| ownercat_id | character varying(30) | Owner of the element, defined on cat_owner |
| muni_id | integer | Municipality in which element is located, defined on ext_municipality |
| postcode | character varying(16) | Postcode of element's location |
| streetaxis_id | character varying(16) | Street in which element is located, defined on ext_streetaxis |
| postnumber | integer | Post number of the element's location, defined on ext_address |
| postcomplement | character varying(100) | Additional number of the element's location |
| streetaxis2_id | character varying(16) | Street in which element is located, defined on ext_streetaxis (used in to define location as from street to street |
| postnumber2 | integer | Post number of the element's location, situated on the second street, defined on ext_address |
| postcomplement2 | character varying(100) | Additional number of the element's location, situated on the second street |
| descript | text | Description |
| link | character varying(512) | Link |
| verified | character varying(20) | Level of data verification, defined on edit_typevalue (value_verified) |
| rotation | numeric(6,3) | Rotation of element's symbol |
| the_geom | geometry(Point,SRID) | Point geometry of element |
| undelete | boolean | If true, element can't be deleted |
| label_x | character varying(30) | Coordinate x of label location |
| label_y | character varying(30) | Coordinate y of label location |
| label_rotation | numeric(6,3) | Rotation of element's label |
| publish | boolean | If true, element is being published |
| inventory | boolean | If true, element is a part of company's inventory |
| expl_id | integer | Id of an exploitation, defined on exploitation |
| num_value | numeric(12,3) | Additional numeric field |
| feature_type | character varying(16) | Type of feature (automatically assigned on insert) |
| tstamp | timestamp without time zone | Date and time of data insert |
| pjoint_type | character varying(16) | Final feature type of element to which connec is related vía links |
| pjoint_id | character varying(16) | Final feature id of element to which connec is related vía links |
| lastupdate | timestamp without time zone | Date and time of last data update |
| lastupdate_user | character varying(50) | User that executed last update |
| insert_user | character varying(50) | User that inserted data |
| minsector_id | integer | Id of a minimum sector |
| dqa_id | integer | Id of a quality sector, defined on dqa |
| staticpressure | numeric(12,3) | Static pressure |
| district_id | integer | District in which element is located, defined on ext_district |
| adate | text | Amortitation date |
| adescript | text | Amortitation descript |
| accessibility | smallint | Accessibility of an element |
| asset_id | character varying(50) | Id of a financial asset |
| epa_type | text | Connec type related to EPA classification, defined on sys_feature_epa_type |
| om_state | text | Maintenance status of the section |
| conserv_state | text | State of conservation of the section |
| priority | text | |
| valve_location | text | Location of valve |
| valve_type | text | Type of valve |
| shutoff_valve | text | Establishes whether or not the service connection has a shut-off valve |
| access_type | text | Sets how the element can be accessed |
| placement_type | text | If the element is located in another element, this field can be used to set exactly where it is located |
| crmzone_id | integer | Id of crm zone |
| expl_id2 | integer | Id of a second exploitation, defined on exploitation |