Skip to content

ws_connec

advase edited this page May 31, 2023 · 12 revisions

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

Man tables:

Clone this wiki locally