| SchemaSpy Analysis of qwat.qwat_vl | Generated by SchemaSpy |
| Generated by SchemaSpy on mar. mars 21 17:52 CET 2017 | |
| Database Type: PostgreSQL - 9.5.6 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| bedding | 1 | 11 | 9 | Bedding | |
| cistern | 2 | 11 | 5 | ||
| cover_type | 1 | 11 | 7 | Type of covers | |
| hydrant_material | 1 | 12 | 6 | ||
| hydrant_model_inf | 1 | 11 | 21 | ||
| hydrant_model_sup | 1 | 11 | 22 | ||
| hydrant_output | 1 | 11 | 10 | ||
| hydrant_provider | 1 | 11 | 12 | hydrant providers list. | |
| leak_cause | 1 | 11 | 9 | Causes of leak | |
| locationtype | 11 | 13 | Location type for water specific elements | ||
| object_reference | 3 | 11 | 7 | Reference for object measurements depicting where the measurement took place on the object, with respect to the sea-level | |
| overflow | 1 | 11 | 5 | ||
| part_type | 1 | 11 | 11 | table for installation parts. They are supposed to be on top of nodes and might be used to display a specific symbol. | |
| pipe_function | 1 | 14 | 14 | Function for pipe. Here is determined if pipe should be visible or not in the schematic view, but this can be overidden by the pipe attribute schema_force_visible. | |
| pipe_installmethod | 1 | 11 | 10 | Installation methods. | |
| pipe_material | 2 | 23 | 567 | List of materials for pipe. All the possible combinations material/diameter are listed in this table. _displayname_fr, _displayname_ro and _displayname_en are automatically generated by rules on insert and update. They are meant to be used in QGIS for the combo box of pipe.fk_material. Remark: The pipe industry maintains two different ways to refer to the dimension of a pipe: - Nominal Diameter (DN) which is commonly used for steel/iron pipes but also for GRP. - Exterior Diameter or Outer Diameter(OD) is taken into consideration when referring to the plastic pipes (PE, PVC). The DN is a number that represents the approximate interior diameter, in mm. The value represents only an approximation of the pipe diameter so that engineers use a nice round number; the actual value is usually off by a few mm. So, when referring simply to the diameter, it is assumed that for plastic pipes you're referring to the outer one, and for iron/steel and GRP ones to the approximate interior one - Nominal Diameter (DN). PE80 and PE100 are both types of polyethylene that are used for water pipes (PE32, PE40 and PE63 also exist). Pipes made from PE100 are mechanically stronger (and gives a greater pressure rating than PE80 for the same SDR). Materials that are used in the production of polyethylene pipes are classified by MRS. Minimum Required Strenght (MRS) is the value of durability that the material has against internal pressure under 20 degrees C for 50 years in MPa. Material | MRS (MPa) -------------------------- PE 100 | 10 -------------------------- PE 80 | 8 -------------------------- Standard dimension ratio (SDR) is a method of rating a pipe's durability against pressure. The standard dimension ratio describes the correlation between the pipe dimension and the thickness of the pipe wall. SDR = external diameter (mm) / wall thickness (mm). Pipes with a lower SDR can withstand higher pressure. Common nominations are SDR11 and SDR17. The GRP pipes materials values were taken from producer HOBAS standards. Added only GRP values for SN 10000. TODO rest if relevant | |
| pipe_protection | 1 | 11 | 14 | Pipe protection details. | |
| precision | 5 | 12 | 7 | pressure precision. | |
| precisionalti | 3 | 12 | 8 | precision of altitude | |
| pressurecontrol_type | 1 | 11 | 6 | ||
| protectionzone_type | 1 | 11 | 8 | type of protection zone. Specifc to Switzerland: Groundwater protection zones are the most incisive tool available for planning purposes. Zones of this kind are to be designated around all groundwater wells serving the public interest. In the groundwater protection zones surrounding drinking water installations (groundwater wells, artificial recharge facilities), significant restrictions are imposed on human activities. The regulations become less stringent as one moves from the centre to the periphery: 1. Wellhead protection zone S1 The zone S1 comprises the area immediately surrounding a groundwater well or artificial recharge facility (at least 10 m around the well and around the collection system). In this zone, only construction work and activities connected with drinking water supply are permitted. The aim is to prevent damage to the facilities or direct contamination of the water abstracted. The zone S1 should therefore be purchased and fenced in by the drinking water supplier. 2. Inner protection zone S2 The inner protection zone S2 is primarily designed to prevent contamination of drinking water with pathogenic microorganisms and to ensure that groundwater flows are not adversely affected or obstructed as they approach the well. In this zone, the spreading of liquid manure is therefore prohibited, as are the infiltration of wastewater and the construction of buildings and installations. 3. Outer protection zone S3 The outer protection zone is designed to ensure that, in the event of an accident, sufficient time and space are available to ward off any hazards to drinking water. Thus, facilities that pose a hazard to groundwater (e.g. petrol stations) are not allowed to be located in zone S3. Wastewater seepage and gravel extraction are likewise prohibited in this area. Source: http://www.bafu.admin.ch/grundwasser/07483/07485/10037/index.html?lang=en | |
| pump_operating | 1 | 12 | 5 | ||
| pump_type | 1 | 12 | 6 | ||
| remote_type | 1 | 11 | 10 | ||
| source_quality | 1 | 12 | 6 | ||
| source_type | 1 | 12 | 7 | ||
| status | 4 | 14 | 10 | Status table, with SIRE id. | |
| subscriber_type | 1 | 11 | 8 | type for subscriber. | |
| survey_type | 1 | 12 | 5 | Water type table, with SIRE code. | |
| tank_firestorage | 1 | 11 | 9 | ||
| value_list_base | 11 | 895 | Master tables for value lists. It will be inherited by value list tables. This table shall not be filled. Be warned that value list table shal have its own unique index on id since PG does not propagate indexes. Therefore unicity of id cannot be garanteed over all value lists. | ||
| valve_actuation | 1 | 12 | 7 | valve actuation/actionnement/ac?ionare | |
| valve_function | 1 | 12 | 15 | Functions for valves | |
| valve_maintenance | 12 | 6 | valve maintenance table. | ||
| valve_type | 1 | 11 | 15 | Types of valve | |
| visible | 21 | 13 | 3 | Table for editing in qgis tri state boolean (NULL/True/False) by using value relation. | |
| watertype | 2 | 12 | 6 | Water type table, with SIRE code. | |
| worker_type | 11 | 6 | type for worker. | ||
| 38 Tables | 450 | 1 790 | |||
| 0 Views | 0 |