qwat.qwat_od contains 2508 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
chamber	depth	numeric	10,3	√		null
chamber	flow_meter	bool	1	√		null	is a flow_meter present?
chamber	id	int4	10
chamber	manometer	bool	1	√		null	is a manometer present?
chamber	networkseparation	bool	1	√		null
chamber	no_valves	int2	5	√		null
chamber	water_meter	bool	1	√		null	is a water_meter present?
consumptionzone	colorcode	int2	5	√		null
consumptionzone	id	serial	10		√	nextval('qwat_od.consumptionzone_id_seq'::regclass)
consumptionzone	name	varchar	50	√		null
consumptionzone	population	int4	10	√		0
cover	altitude	numeric	8,3	√		null
cover	circular	bool	1	√		true
cover	fk_cover_type	int4	10	√		null
cover	fk_distributor	int4	10	√		null
cover	fk_installation	int4	10	√		null
cover	fk_status	int4	10	√		null
cover	form_dimension	numeric	10,3	√		null	depending on the cover form, it represents either the diameter of circle or the length of a square side
cover	geometry	geometry	2147483647
cover	geometry_polygon	geometry	2147483647	√		null
cover	id	serial	10		√	nextval('qwat_od.cover_id_seq'::regclass)
cover	identification	varchar	50	√		null
cover	label_1_rotation	float8	17,17	√		null
cover	label_1_text	varchar	120	√		null
cover	label_1_visible	int2	5	√		1
cover	label_1_x	float8	17,17	√		null
cover	label_1_y	float8	17,17	√		null
cover	label_2_rotation	float8	17,17	√		null
cover	label_2_text	varchar	120	√		null
cover	label_2_visible	int2	5	√		1
cover	label_2_x	float8	17,17	√		null
cover	label_2_y	float8	17,17	√		null
cover	remark	text	2147483647	√		null
cover	year	int2	5	√		null
crossing	_pipe1_angle	float8	17,17	√		null
crossing	_pipe1_id	int4	10	√		null
crossing	_pipe2_angle	float8	17,17	√		null
crossing	_pipe2_id	int4	10	√		null
crossing	controled	bool	1			false
crossing	disabled	bool	1			false
crossing	geometry	geometry	2147483647
crossing	hide_pipe	int2	5			1
crossing	id	serial	10		√	nextval('qwat_od.crossing_id_seq'::regclass)
distributor	id	serial	10		√	nextval('qwat_od.distributor_id_seq'::regclass)
distributor	name	varchar	30	√		null
district	colorcode	int2	5	√		1
district	geometry	geometry	2147483647	√		null
district	id	serial	10		√	nextval('qwat_od.district_id_seq'::regclass)
district	label_1_rotation	float8	17,17	√		null
district	label_1_text	varchar	120	√		null
district	label_1_visible	int2	5	√		1
district	label_1_x	float8	17,17	√		null
district	label_1_y	float8	17,17	√		null
district	label_2_rotation	float8	17,17	√		null
district	label_2_text	varchar	120	√		null
district	label_2_visible	int2	5	√		1
district	label_2_x	float8	17,17	√		null
district	label_2_y	float8	17,17	√		null
district	land_registry	varchar	12	√		null
district	name	varchar	40
district	prefix	varchar	12	√		null
district	shortname	varchar	12	√		null
district	zip	varchar	12	√		null
folder	date_end	date	13	√		null
folder	date_start	date	13	√		null
folder	description	text	2147483647	√		null
folder	geometry_line	geometry	2147483647	√		null
folder	geometry_polygon	geometry	2147483647	√		null
folder	id	serial	10		√	nextval('qwat_od.folder_id_seq'::regclass)
folder	identification	varchar	50
hydrant	fk_material	int4	10
hydrant	fk_model_inf	int4	10
hydrant	fk_model_sup	int4	10
hydrant	fk_output	int4	10
hydrant	fk_provider	int4	10	√		null
hydrant	flow	numeric	8,2	√		null	debit dynamique pour une pression dynamique de 2 bars [l/min]
hydrant	id	int4	10
hydrant	marked	bool	1	√		false	does it have markings pointing to it
hydrant	observation_date	date	13	√		null
hydrant	observation_source	varchar	45	√		null
hydrant	pressure_dynamic	numeric	5,2	√		null	pression dynamique [bar]
hydrant	pressure_static	numeric	5,2	√		null	pression statique [bar]
hydrant	underground	bool	1	√		false
installation	eca	varchar	30	√		null
installation	fk_parent	int4	10	√		null
installation	fk_remote	int4	10	√		null
installation	fk_watertype	int4	10
installation	geometry_polygon	geometry	2147483647	√		null
installation	id	int4	10
installation	name	varchar	60	√		null
installation	open_water_surface	bool	1	√		false
installation	parcel	varchar	30	√		null
leak	_repaired	bool	1	√		null
leak	address	text	2147483647	√		null
leak	description	text	2147483647	√		null
leak	detection_date	date	13	√		null
leak	fk_cause	int4	10
leak	fk_pipe	int4	10	√		null
leak	geometry	geometry	2147483647	√		null
leak	id	serial	10		√	nextval('qwat_od.leak_id_seq'::regclass)
leak	label_1_rotation	float8	17,17	√		null
leak	label_1_text	varchar	120	√		null
leak	label_1_visible	int2	5	√		1
leak	label_1_x	float8	17,17	√		null
leak	label_1_y	float8	17,17	√		null
leak	label_2_rotation	float8	17,17	√		null
leak	label_2_text	varchar	120	√		null
leak	label_2_visible	int2	5	√		1
leak	label_2_x	float8	17,17	√		null
leak	label_2_y	float8	17,17	√		null
leak	pipe_replaced	bool	1	√		null
leak	repair	text	2147483647	√		null
leak	repair_date	date	13	√		null
leak	widespread_damage	bool	1
meter	fk_pipe	int4	10	√		null
meter	id	int4	10
meter	parcel	varchar	50	√		null
meter_reference	fk_meter	int4	10
meter_reference	geometry	geometry	2147483647	√		null
meter_reference	id	serial	10		√	nextval('qwat_od.meter_reference_id_seq'::regclass)
network_element	altitude	numeric	10,3	√		NULL::numeric
network_element	fk_distributor	int4	10
network_element	fk_folder	int4	10	√		null
network_element	fk_locationtype	_int4	10	√		null
network_element	fk_object_reference	int4	10	√		null
network_element	fk_precision	int4	10
network_element	fk_precisionalti	int4	10	√		null
network_element	fk_status	int4	10
network_element	id	int4	10
network_element	identification	varchar	50	√		null
network_element	label_1_rotation	float8	17,17	√		null
network_element	label_1_text	varchar	120	√		null
network_element	label_1_visible	int2	5	√		1
network_element	label_1_x	float8	17,17	√		null
network_element	label_1_y	float8	17,17	√		null
network_element	label_2_rotation	float8	17,17	√		null
network_element	label_2_text	varchar	120	√		null
network_element	label_2_visible	int2	5	√		1
network_element	label_2_x	float8	17,17	√		null
network_element	label_2_y	float8	17,17	√		null
network_element	orientation	float8	17,17	√		null	orientation field aims at overwrtiting qwat_od.node._pipe_orientation which is automatically calculated from the pipes. In the editable views, orientation will be COALESCE(netwrok_element.orientation, node._pipe_orientation). Update will be forwarded to network_element.
network_element	remark	text	2147483647	√		null
network_element	schema_force_visible	bool	1	√		null
network_element	year	int2	5	√		null
network_element	year_end	int2	5	√		null
node	_geometry_alt1_used	bool	1	√		null
node	_geometry_alt2_used	bool	1	√		null
node	_pipe_node_type	pipe_connection	2147483647	√		null
node	_pipe_orientation	float8	17,17	√		0
node	_pipe_schema_visible	bool	1	√		false
node	_printmaps	text	2147483647	√		null
node	fk_district	int4	10	√		null
node	fk_pressurezone	int4	10	√		null
node	fk_printmap	_int4	10	√		null
node	geometry	geometry	2147483647
node	geometry_alt1	geometry	2147483647	√		null
node	geometry_alt2	geometry	2147483647	√		null
node	id	serial	10		√	nextval('qwat_od.node_id_seq'::regclass)
node	update_geometry_alt1	bool	1	√		null
node	update_geometry_alt2	bool	1	√		null
part	fk_part_type	int4	10
part	fk_pipe	int4	10	√		null
part	id	int4	10
pipe	_diff_elevation	numeric	8,2	√		null
pipe	_geometry_alt1_used	bool	1	√		null
pipe	_geometry_alt2_used	bool	1	√		null
pipe	_length2d	numeric	8,2	√		null
pipe	_length3d	numeric	8,2	√		null
pipe	_printmaps	varchar	100	√		null
pipe	_valve_closed	bool	1	√		null
pipe	_valve_count	int2	5	√		null
pipe	fk_bedding	int4	10
pipe	fk_distributor	int4	10
pipe	fk_district	int4	10	√		null
pipe	fk_folder	int4	10	√		null
pipe	fk_function	int4	10
pipe	fk_installmethod	int4	10
pipe	fk_locationtype	_int4	10	√		null
pipe	fk_material	int4	10
pipe	fk_node_a	int4	10
pipe	fk_node_b	int4	10
pipe	fk_parent	int4	10	√		null
pipe	fk_precision	int4	10
pipe	fk_pressurezone	int4	10	√		null
pipe	fk_printmap	_int4	10	√		null
pipe	fk_protection	int4	10	√		null
pipe	fk_status	int4	10
pipe	fk_watertype	int4	10
pipe	geometry	geometry	2147483647
pipe	geometry_alt1	geometry	2147483647	√		null
pipe	geometry_alt2	geometry	2147483647	√		null
pipe	id	serial	10		√	nextval('qwat_od.pipe_id_seq'::regclass)
pipe	label_1_text	varchar	120	√		null
pipe	label_1_visible	int2	5	√		1
pipe	label_2_text	varchar	120	√		null
pipe	label_2_visible	int2	5	√		1
pipe	pressure_nominal	int2	5	√		16
pipe	remark	text	2147483647	√		null
pipe	schema_force_visible	bool	1	√		null
pipe	tunnel_or_bridge	bool	1	√		false
pipe	update_geometry_alt1	bool	1	√		null
pipe	update_geometry_alt2	bool	1	√		null
pipe	year	int2	5	√		null
pipe	year_end	int2	5	√		null
pipe	year_rehabilitation	int2	5	√		null
pressurecontrol	fk_pressurecontrol_type	int4	10
pressurecontrol	id	int4	10
pressurezone	_geometry_alt1_used	bool	1	√		null
pressurezone	_geometry_alt2_used	bool	1	√		null
pressurezone	colorcode	int2	5	√		null
pressurezone	fk_consumptionzone	int4	10	√		null
pressurezone	fk_distributor	int4	10
pressurezone	geometry	geometry	2147483647	√		null
pressurezone	geometry_alt1	geometry	2147483647	√		null
pressurezone	geometry_alt2	geometry	2147483647	√		null
pressurezone	id	serial	10		√	nextval('qwat_od.pressurezone_id_seq'::regclass)
pressurezone	label_1_rotation	float8	17,17	√		null
pressurezone	label_1_text	varchar	120	√		null
pressurezone	label_1_visible	int2	5	√		1
pressurezone	label_1_x	float8	17,17	√		null
pressurezone	label_1_y	float8	17,17	√		null
pressurezone	label_2_rotation	float8	17,17	√		null
pressurezone	label_2_text	varchar	120	√		null
pressurezone	label_2_visible	int2	5	√		1
pressurezone	label_2_x	float8	17,17	√		null
pressurezone	label_2_y	float8	17,17	√		null
pressurezone	name	varchar	50
pressurezone	population	int4	10	√		null
pressurezone	subscriber	int4	10	√		null
pressurezone	update_geometry_alt1	bool	1	√		null
pressurezone	update_geometry_alt2	bool	1	√		null
printmap	fk_district	int2	5	√		null
printmap	geometry	geometry	2147483647	√		null
printmap	id	serial	10		√	nextval('qwat_od.printmap_id_seq'::regclass)
printmap	label_1_rotation	float8	17,17	√		null
printmap	label_1_text	varchar	120	√		null
printmap	label_1_visible	int2	5	√		1
printmap	label_1_x	float8	17,17	√		null
printmap	label_1_y	float8	17,17	√		null
printmap	label_2_rotation	float8	17,17	√		null
printmap	label_2_text	varchar	120	√		null
printmap	label_2_visible	int2	5	√		1
printmap	label_2_x	float8	17,17	√		null
printmap	label_2_y	float8	17,17	√		null
printmap	name	varchar	20	√		null
printmap	remark	text	2147483647	√		null
printmap	version_date	date	13	√		null
printmap	x_max	float8	17,17	√		null
printmap	x_min	float8	17,17	√		null
printmap	y_max	float8	17,17	√		null
printmap	y_min	float8	17,17	√		null
protectionzone	agent	varchar	40	√		null
protectionzone	date	date	13	√		null
protectionzone	fk_type	int4	10	√		null
protectionzone	geometry	geometry	2147483647	√		null
protectionzone	id	serial	10		√	nextval('qwat_od.protectionzone_id_seq'::regclass)
protectionzone	name	varchar	40	√		null
protectionzone	validated	bool	1	√		true
pump	fk_pipe_in	int4	10	√		null
pump	fk_pipe_out	int4	10	√		null
pump	fk_pump_operating	int2	5	√		null
pump	fk_pump_type	int2	5	√		null
pump	id	int4	10
pump	manometric_height	numeric	10,2	√		null
pump	no_pumps	int2	5	√		null
pump	rejected_flow	numeric	10,2	√		null
remote	_geometry_alt1_used	bool	1	√		null
remote	_geometry_alt2_used	bool	1	√		null
remote	destination	varchar	150	√		null
remote	fk_distributor	int4	10	√		null
remote	fk_material	int4	10	√		null
remote	fk_precision	int4	10	√		null
remote	fk_status	int4	10	√		null
remote	folder	varchar	50	√		null
remote	geometry	geometry	2147483647
remote	geometry_alt1	geometry	2147483647	√		null
remote	geometry_alt2	geometry	2147483647	√		null
remote	id	serial	10		√	nextval('qwat_od.remote_id_seq'::regclass)
remote	identification	varchar	15	√		null
remote	label_1_rotation	float8	17,17	√		null
remote	label_1_text	varchar	120	√		null
remote	label_1_visible	int2	5	√		1
remote	label_1_x	float8	17,17	√		null
remote	label_1_y	float8	17,17	√		null
remote	label_2_rotation	float8	17,17	√		null
remote	label_2_text	varchar	120	√		null
remote	label_2_visible	int2	5	√		1
remote	label_2_x	float8	17,17	√		null
remote	label_2_y	float8	17,17	√		null
remote	origin	varchar	150	√		null
remote	plan	varchar	50	√		null
remote	remark	text	2147483647	√		null
remote	update_geometry_alt1	bool	1	√		null
remote	update_geometry_alt2	bool	1	√		null
remote	year	int2	5	√		null
samplingpoint	id	int4	10
source	contract_end	date	13	√		null
source	fk_source_quality	int2	5	√		null
source	fk_source_type	int2	5	√		null
source	flow_average	numeric	10,3	√		null
source	flow_concession	numeric	10,2	√		null
source	flow_lowest	numeric	10,3	√		null
source	gathering_chamber	bool	1	√		null
source	id	int4	10
subscriber	fk_pipe	int4	10	√		null
subscriber	fk_subscriber_type	int4	10
subscriber	flow_current	numeric	8,2	√		null
subscriber	flow_planned	numeric	8,2	√		null
subscriber	id	int4	10
subscriber	parcel	varchar	12	√		null
subscriber_reference	fk_subscriber	int4	10
subscriber_reference	geometry	geometry	2147483647	√		null
subscriber_reference	id	serial	10		√	nextval('qwat_od.subscriber_reference_id_seq'::regclass)
surveypoint	altitude	numeric	10,3	√		NULL::numeric
surveypoint	code	varchar	50	√		null
surveypoint	date	date	13	√		null
surveypoint	description	text	2147483647	√		null
surveypoint	fk_folder	int4	10	√		null
surveypoint	fk_survey_type	int4	10
surveypoint	fk_worker	int4	10	√		null
surveypoint	geometry	geometry	2147483647	√		null
surveypoint	id	int4	10
tank	_cistern1_litrepercm	numeric	9,3	√		null
tank	_cistern2_litrepercm	numeric	9,3	√		null
tank	_litrepercm	numeric	9,3	√		null
tank	altitude_apron	numeric	7,3	√		null
tank	altitude_overflow	numeric	7,3	√		null
tank	cistern1_dimension_1	numeric	10,2	√		null
tank	cistern1_dimension_2	numeric	10,2	√		null
tank	cistern1_fk_type	int4	10	√		null
tank	cistern1_storage	numeric	10,2	√		null
tank	cistern2_dimension_1	numeric	10,2	√		null
tank	cistern2_dimension_2	numeric	10,2	√		null
tank	cistern2_fk_type	int4	10	√		null
tank	cistern2_storage	numeric	10,2	√		null
tank	fire_remote	bool	1	√		null
tank	fire_valve	bool	1	√		null
tank	fk_overflow	int4	10	√		null
tank	fk_tank_firestorage	int4	10	√		null
tank	height_max	numeric	7,3	√		null
tank	id	int4	10
tank	storage_fire	numeric	10,1	√		null	litres
tank	storage_supply	numeric	10,1	√		null	litres
tank	storage_total	numeric	10,1	√		null	litres
treatment	activatedcharcoal	bool	1	√		null
treatment	filtration_membrane	bool	1	√		null
treatment	filtration_sandorgravel	bool	1	√		null
treatment	flocculation	bool	1	√		null
treatment	id	int4	10
treatment	sanitization_chlorine_gazeous	bool	1	√		null
treatment	sanitization_chlorine_liquid	bool	1	√		null
treatment	sanitization_ozone	bool	1	√		null
treatment	sanitization_uv	bool	1	√		null
treatment	settling	bool	1	√		null
treatment	treatment_capacity	numeric	10,2	√		null
valve	_geometry_alt1_used	bool	1	√		null
valve	_geometry_alt2_used	bool	1	√		null
valve	_pipe_node_type	pipe_connection	2147483647	√		null
valve	_pipe_orientation	float8	17,17	√		0
valve	_pipe_schema_visible	bool	1	√		false
valve	_printmaps	text	2147483647	√		null
valve	altitude	numeric	10,3	√		NULL::numeric
valve	closed	bool	1	√		false
valve	diameter_nominal	varchar	10	√		null
valve	fk_distributor	int4	10
valve	fk_district	int4	10	√		null
valve	fk_folder	int4	10	√		null
valve	fk_handle_precision	int4	10	√		null
valve	fk_handle_precisionalti	int4	10	√		null
valve	fk_locationtype	_int4	10	√		null
valve	fk_maintenance	_int4	10	√		null
valve	fk_object_reference	int4	10	√		null
valve	fk_pipe	int4	10	√		null
valve	fk_precision	int4	10
valve	fk_precisionalti	int4	10	√		null
valve	fk_pressurezone	int4	10	√		null
valve	fk_printmap	_int4	10	√		null
valve	fk_status	int4	10
valve	fk_valve_actuation	int4	10
valve	fk_valve_function	int4	10
valve	fk_valve_type	int4	10
valve	geometry	geometry	2147483647
valve	geometry_alt1	geometry	2147483647	√		null
valve	geometry_alt2	geometry	2147483647	√		null
valve	handle_altitude	numeric	10,3	√		null
valve	handle_geometry	geometry	2147483647	√		null
valve	id	serial	10		√	nextval('qwat_od.valve_id_seq'::regclass)
valve	identification	varchar	50	√		null
valve	label_1_rotation	float8	17,17	√		null
valve	label_1_text	varchar	120	√		null
valve	label_1_visible	int2	5	√		1
valve	label_1_x	float8	17,17	√		null
valve	label_1_y	float8	17,17	√		null
valve	label_2_rotation	float8	17,17	√		null
valve	label_2_text	varchar	120	√		null
valve	label_2_visible	int2	5	√		1
valve	label_2_x	float8	17,17	√		null
valve	label_2_y	float8	17,17	√		null
valve	networkseparation	bool	1	√		false
valve	orientation	float8	17,17	√		null
valve	remark	text	2147483647	√		null
valve	schema_force_visible	bool	1	√		null
valve	update_geometry_alt1	bool	1	√		null
valve	update_geometry_alt2	bool	1	√		null
valve	year	int2	5	√		null
valve	year_end	int2	5	√		null
vw_consumptionzone	_sum_population	int8	19	√		null
vw_consumptionzone	_sum_subscriber	int8	19	√		null
vw_consumptionzone	colorcode	int2	5	√		null
vw_consumptionzone	geometry	geometry	2147483647	√		null
vw_consumptionzone	id	int4	10	√		null
vw_consumptionzone	name	varchar	50	√		null
vw_consumptionzone	population	int4	10	√		null
vw_element_hydrant	_geometry_alt1_used	bool	1	√		null
vw_element_hydrant	_geometry_alt2_used	bool	1	√		null
vw_element_hydrant	_pipe_node_type	pipe_connection	2147483647	√		null
vw_element_hydrant	_pipe_orientation	float8	17,17	√		null
vw_element_hydrant	_pipe_schema_visible	bool	1	√		null
vw_element_hydrant	_printmaps	text	2147483647	√		null
vw_element_hydrant	altitude	numeric	10,3	√		null
vw_element_hydrant	fk_distributor	int4	10	√		null
vw_element_hydrant	fk_district	int4	10	√		null
vw_element_hydrant	fk_folder	int4	10	√		null
vw_element_hydrant	fk_locationtype	_int4	10	√		null
vw_element_hydrant	fk_material	int4	10	√		null
vw_element_hydrant	fk_model_inf	int4	10	√		null
vw_element_hydrant	fk_model_sup	int4	10	√		null
vw_element_hydrant	fk_object_reference	int4	10	√		null
vw_element_hydrant	fk_output	int4	10	√		null
vw_element_hydrant	fk_precision	int4	10	√		null
vw_element_hydrant	fk_precisionalti	int4	10	√		null
vw_element_hydrant	fk_pressurezone	int4	10	√		null
vw_element_hydrant	fk_printmap	_int4	10	√		null
vw_element_hydrant	fk_provider	int4	10	√		null
vw_element_hydrant	fk_status	int4	10	√		null
vw_element_hydrant	flow	numeric	8,2	√		null
vw_element_hydrant	geometry	geometry	2147483647	√		null
vw_element_hydrant	geometry_alt1	geometry	2147483647	√		null
vw_element_hydrant	geometry_alt2	geometry	2147483647	√		null
vw_element_hydrant	id	int4	10	√		null
vw_element_hydrant	identification	varchar	50	√		null
vw_element_hydrant	label_1_rotation	float8	17,17	√		null
vw_element_hydrant	label_1_text	varchar	120	√		null
vw_element_hydrant	label_1_visible	int2	5	√		null
vw_element_hydrant	label_1_x	float8	17,17	√		null
vw_element_hydrant	label_1_y	float8	17,17	√		null
vw_element_hydrant	label_2_rotation	float8	17,17	√		null
vw_element_hydrant	label_2_text	varchar	120	√		null
vw_element_hydrant	label_2_visible	int2	5	√		null
vw_element_hydrant	label_2_x	float8	17,17	√		null
vw_element_hydrant	label_2_y	float8	17,17	√		null
vw_element_hydrant	marked	bool	1	√		null
vw_element_hydrant	observation_date	date	13	√		null
vw_element_hydrant	observation_source	varchar	45	√		null
vw_element_hydrant	orientation	float8	17,17	√		null
vw_element_hydrant	pressure_dynamic	numeric	5,2	√		null
vw_element_hydrant	pressure_static	numeric	5,2	√		null
vw_element_hydrant	remark	text	2147483647	√		null
vw_element_hydrant	schema_force_visible	bool	1	√		null
vw_element_hydrant	underground	bool	1	√		null
vw_element_hydrant	update_geometry_alt1	bool	1	√		null
vw_element_hydrant	update_geometry_alt2	bool	1	√		null
vw_element_hydrant	year	int2	5	√		null
vw_element_hydrant	year_end	int2	5	√		null
vw_element_installation	_cistern1_litrepercm	numeric	9,3	√		null
vw_element_installation	_cistern2_litrepercm	numeric	9,3	√		null
vw_element_installation	_geometry_alt1_used	bool	1	√		null
vw_element_installation	_geometry_alt2_used	bool	1	√		null
vw_element_installation	_litrepercm	numeric	9,3	√		null
vw_element_installation	_pipe_node_type	pipe_connection	2147483647	√		null
vw_element_installation	_pipe_orientation	float8	17,17	√		null
vw_element_installation	_pipe_schema_visible	bool	1	√		null
vw_element_installation	_printmaps	text	2147483647	√		null
vw_element_installation	activatedcharcoal	bool	1	√		null
vw_element_installation	altitude	numeric	10,3	√		null
vw_element_installation	altitude_apron	numeric	7,3	√		null
vw_element_installation	altitude_overflow	numeric	7,3	√		null
vw_element_installation	cistern1_dimension_1	numeric	10,2	√		null
vw_element_installation	cistern1_dimension_2	numeric	10,2	√		null
vw_element_installation	cistern1_fk_type	int4	10	√		null
vw_element_installation	cistern1_storage	numeric	10,2	√		null
vw_element_installation	cistern2_dimension_1	numeric	10,2	√		null
vw_element_installation	cistern2_dimension_2	numeric	10,2	√		null
vw_element_installation	cistern2_fk_type	int4	10	√		null
vw_element_installation	cistern2_storage	numeric	10,2	√		null
vw_element_installation	contract_end	date	13	√		null
vw_element_installation	depth	numeric	10,3	√		null
vw_element_installation	eca	varchar	30	√		null
vw_element_installation	filtration_membrane	bool	1	√		null
vw_element_installation	filtration_sandorgravel	bool	1	√		null
vw_element_installation	fire_remote	bool	1	√		null
vw_element_installation	fire_valve	bool	1	√		null
vw_element_installation	fk_distributor	int4	10	√		null
vw_element_installation	fk_district	int4	10	√		null
vw_element_installation	fk_folder	int4	10	√		null
vw_element_installation	fk_locationtype	_int4	10	√		null
vw_element_installation	fk_object_reference	int4	10	√		null
vw_element_installation	fk_overflow	int4	10	√		null
vw_element_installation	fk_parent	int4	10	√		null
vw_element_installation	fk_pipe_in	int4	10	√		null
vw_element_installation	fk_pipe_out	int4	10	√		null
vw_element_installation	fk_precision	int4	10	√		null
vw_element_installation	fk_precisionalti	int4	10	√		null
vw_element_installation	fk_pressurecontrol_type	int4	10	√		null
vw_element_installation	fk_pressurezone	int4	10	√		null
vw_element_installation	fk_printmap	_int4	10	√		null
vw_element_installation	fk_pump_operating	int2	5	√		null
vw_element_installation	fk_pump_type	int2	5	√		null
vw_element_installation	fk_remote	int4	10	√		null
vw_element_installation	fk_source_quality	int2	5	√		null
vw_element_installation	fk_source_type	int2	5	√		null
vw_element_installation	fk_status	int4	10	√		null
vw_element_installation	fk_tank_firestorage	int4	10	√		null
vw_element_installation	fk_watertype	int4	10	√		null
vw_element_installation	flocculation	bool	1	√		null
vw_element_installation	flow_average	numeric	10,3	√		null
vw_element_installation	flow_concession	numeric	10,2	√		null
vw_element_installation	flow_lowest	numeric	10,3	√		null
vw_element_installation	flow_meter	bool	1	√		null
vw_element_installation	gathering_chamber	bool	1	√		null
vw_element_installation	geometry	geometry	2147483647	√		null
vw_element_installation	geometry_alt1	geometry	2147483647	√		null
vw_element_installation	geometry_alt2	geometry	2147483647	√		null
vw_element_installation	geometry_polygon	geometry	2147483647	√		null
vw_element_installation	height_max	numeric	7,3	√		null
vw_element_installation	id	int4	10	√		null
vw_element_installation	identification	varchar	50	√		null
vw_element_installation	installation_type	installation_type	2147483647	√		null
vw_element_installation	label_1_rotation	float8	17,17	√		null
vw_element_installation	label_1_text	varchar	120	√		null
vw_element_installation	label_1_visible	int2	5	√		null
vw_element_installation	label_1_x	float8	17,17	√		null
vw_element_installation	label_1_y	float8	17,17	√		null
vw_element_installation	label_2_rotation	float8	17,17	√		null
vw_element_installation	label_2_text	varchar	120	√		null
vw_element_installation	label_2_visible	int2	5	√		null
vw_element_installation	label_2_x	float8	17,17	√		null
vw_element_installation	label_2_y	float8	17,17	√		null
vw_element_installation	manometer	bool	1	√		null
vw_element_installation	manometric_height	numeric	10,2	√		null
vw_element_installation	name	varchar	60	√		null
vw_element_installation	networkseparation	bool	1	√		null
vw_element_installation	no_pumps	int2	5	√		null
vw_element_installation	no_valves	int2	5	√		null
vw_element_installation	open_water_surface	bool	1	√		null
vw_element_installation	orientation	float8	17,17	√		null
vw_element_installation	parcel	varchar	30	√		null
vw_element_installation	rejected_flow	numeric	10,2	√		null
vw_element_installation	remark	text	2147483647	√		null
vw_element_installation	sanitization_chlorine_gazeous	bool	1	√		null
vw_element_installation	sanitization_chlorine_liquid	bool	1	√		null
vw_element_installation	sanitization_ozone	bool	1	√		null
vw_element_installation	sanitization_uv	bool	1	√		null
vw_element_installation	schema_force_visible	bool	1	√		null
vw_element_installation	settling	bool	1	√		null
vw_element_installation	storage_fire	numeric	10,1	√		null
vw_element_installation	storage_supply	numeric	10,1	√		null
vw_element_installation	storage_total	numeric	10,1	√		null
vw_element_installation	treatment_capacity	numeric	10,2	√		null
vw_element_installation	update_geometry_alt1	bool	1	√		null
vw_element_installation	update_geometry_alt2	bool	1	√		null
vw_element_installation	water_meter	bool	1	√		null
vw_element_installation	year	int2	5	√		null
vw_element_installation	year_end	int2	5	√		null
vw_element_meter	_geometry_alt1_used	bool	1	√		null
vw_element_meter	_geometry_alt2_used	bool	1	√		null
vw_element_meter	_pipe_node_type	pipe_connection	2147483647	√		null
vw_element_meter	_pipe_orientation	float8	17,17	√		null
vw_element_meter	_pipe_schema_visible	bool	1	√		null
vw_element_meter	_printmaps	text	2147483647	√		null
vw_element_meter	altitude	numeric	10,3	√		null
vw_element_meter	fk_distributor	int4	10	√		null
vw_element_meter	fk_district	int4	10	√		null
vw_element_meter	fk_folder	int4	10	√		null
vw_element_meter	fk_locationtype	_int4	10	√		null
vw_element_meter	fk_object_reference	int4	10	√		null
vw_element_meter	fk_pipe	int4	10	√		null
vw_element_meter	fk_precision	int4	10	√		null
vw_element_meter	fk_precisionalti	int4	10	√		null
vw_element_meter	fk_pressurezone	int4	10	√		null
vw_element_meter	fk_printmap	_int4	10	√		null
vw_element_meter	fk_status	int4	10	√		null
vw_element_meter	geometry	geometry	2147483647	√		null
vw_element_meter	geometry_alt1	geometry	2147483647	√		null
vw_element_meter	geometry_alt2	geometry	2147483647	√		null
vw_element_meter	id	int4	10	√		null
vw_element_meter	identification	varchar	50	√		null
vw_element_meter	label_1_rotation	float8	17,17	√		null
vw_element_meter	label_1_text	varchar	120	√		null
vw_element_meter	label_1_visible	int2	5	√		null
vw_element_meter	label_1_x	float8	17,17	√		null
vw_element_meter	label_1_y	float8	17,17	√		null
vw_element_meter	label_2_rotation	float8	17,17	√		null
vw_element_meter	label_2_text	varchar	120	√		null
vw_element_meter	label_2_visible	int2	5	√		null
vw_element_meter	label_2_x	float8	17,17	√		null
vw_element_meter	label_2_y	float8	17,17	√		null
vw_element_meter	orientation	float8	17,17	√		null
vw_element_meter	parcel	varchar	50	√		null
vw_element_meter	remark	text	2147483647	√		null
vw_element_meter	schema_force_visible	bool	1	√		null
vw_element_meter	update_geometry_alt1	bool	1	√		null
vw_element_meter	update_geometry_alt2	bool	1	√		null
vw_element_meter	year	int2	5	√		null
vw_element_meter	year_end	int2	5	√		null
vw_element_part	_geometry_alt1_used	bool	1	√		null
vw_element_part	_geometry_alt2_used	bool	1	√		null
vw_element_part	_pipe_node_type	pipe_connection	2147483647	√		null
vw_element_part	_pipe_orientation	float8	17,17	√		null
vw_element_part	_pipe_schema_visible	bool	1	√		null
vw_element_part	_printmaps	text	2147483647	√		null
vw_element_part	altitude	numeric	10,3	√		null
vw_element_part	fk_distributor	int4	10	√		null
vw_element_part	fk_district	int4	10	√		null
vw_element_part	fk_folder	int4	10	√		null
vw_element_part	fk_locationtype	_int4	10	√		null
vw_element_part	fk_object_reference	int4	10	√		null
vw_element_part	fk_part_type	int4	10	√		null
vw_element_part	fk_pipe	int4	10	√		null
vw_element_part	fk_precision	int4	10	√		null
vw_element_part	fk_precisionalti	int4	10	√		null
vw_element_part	fk_pressurezone	int4	10	√		null
vw_element_part	fk_printmap	_int4	10	√		null
vw_element_part	fk_status	int4	10	√		null
vw_element_part	geometry	geometry	2147483647	√		null
vw_element_part	geometry_alt1	geometry	2147483647	√		null
vw_element_part	geometry_alt2	geometry	2147483647	√		null
vw_element_part	id	int4	10	√		null
vw_element_part	identification	varchar	50	√		null
vw_element_part	label_1_rotation	float8	17,17	√		null
vw_element_part	label_1_text	varchar	120	√		null
vw_element_part	label_1_visible	int2	5	√		null
vw_element_part	label_1_x	float8	17,17	√		null
vw_element_part	label_1_y	float8	17,17	√		null
vw_element_part	label_2_rotation	float8	17,17	√		null
vw_element_part	label_2_text	varchar	120	√		null
vw_element_part	label_2_visible	int2	5	√		null
vw_element_part	label_2_x	float8	17,17	√		null
vw_element_part	label_2_y	float8	17,17	√		null
vw_element_part	orientation	float8	17,17	√		null
vw_element_part	remark	text	2147483647	√		null
vw_element_part	schema_force_visible	bool	1	√		null
vw_element_part	update_geometry_alt1	bool	1	√		null
vw_element_part	update_geometry_alt2	bool	1	√		null
vw_element_part	year	int2	5	√		null
vw_element_part	year_end	int2	5	√		null
vw_element_samplingpoint	_geometry_alt1_used	bool	1	√		null
vw_element_samplingpoint	_geometry_alt2_used	bool	1	√		null
vw_element_samplingpoint	_pipe_node_type	pipe_connection	2147483647	√		null
vw_element_samplingpoint	_pipe_orientation	float8	17,17	√		null
vw_element_samplingpoint	_pipe_schema_visible	bool	1	√		null
vw_element_samplingpoint	_printmaps	text	2147483647	√		null
vw_element_samplingpoint	altitude	numeric	10,3	√		null
vw_element_samplingpoint	fk_distributor	int4	10	√		null
vw_element_samplingpoint	fk_district	int4	10	√		null
vw_element_samplingpoint	fk_folder	int4	10	√		null
vw_element_samplingpoint	fk_locationtype	_int4	10	√		null
vw_element_samplingpoint	fk_object_reference	int4	10	√		null
vw_element_samplingpoint	fk_precision	int4	10	√		null
vw_element_samplingpoint	fk_precisionalti	int4	10	√		null
vw_element_samplingpoint	fk_pressurezone	int4	10	√		null
vw_element_samplingpoint	fk_printmap	_int4	10	√		null
vw_element_samplingpoint	fk_status	int4	10	√		null
vw_element_samplingpoint	geometry	geometry	2147483647	√		null
vw_element_samplingpoint	geometry_alt1	geometry	2147483647	√		null
vw_element_samplingpoint	geometry_alt2	geometry	2147483647	√		null
vw_element_samplingpoint	id	int4	10	√		null
vw_element_samplingpoint	identification	varchar	50	√		null
vw_element_samplingpoint	label_1_rotation	float8	17,17	√		null
vw_element_samplingpoint	label_1_text	varchar	120	√		null
vw_element_samplingpoint	label_1_visible	int2	5	√		null
vw_element_samplingpoint	label_1_x	float8	17,17	√		null
vw_element_samplingpoint	label_1_y	float8	17,17	√		null
vw_element_samplingpoint	label_2_rotation	float8	17,17	√		null
vw_element_samplingpoint	label_2_text	varchar	120	√		null
vw_element_samplingpoint	label_2_visible	int2	5	√		null
vw_element_samplingpoint	label_2_x	float8	17,17	√		null
vw_element_samplingpoint	label_2_y	float8	17,17	√		null
vw_element_samplingpoint	orientation	float8	17,17	√		null
vw_element_samplingpoint	remark	text	2147483647	√		null
vw_element_samplingpoint	schema_force_visible	bool	1	√		null
vw_element_samplingpoint	update_geometry_alt1	bool	1	√		null
vw_element_samplingpoint	update_geometry_alt2	bool	1	√		null
vw_element_samplingpoint	year	int2	5	√		null
vw_element_samplingpoint	year_end	int2	5	√		null
vw_element_subscriber	_geometry_alt1_used	bool	1	√		null
vw_element_subscriber	_geometry_alt2_used	bool	1	√		null
vw_element_subscriber	_pipe_node_type	pipe_connection	2147483647	√		null
vw_element_subscriber	_pipe_orientation	float8	17,17	√		null
vw_element_subscriber	_pipe_schema_visible	bool	1	√		null
vw_element_subscriber	_printmaps	text	2147483647	√		null
vw_element_subscriber	altitude	numeric	10,3	√		null
vw_element_subscriber	fk_distributor	int4	10	√		null
vw_element_subscriber	fk_district	int4	10	√		null
vw_element_subscriber	fk_folder	int4	10	√		null
vw_element_subscriber	fk_locationtype	_int4	10	√		null
vw_element_subscriber	fk_object_reference	int4	10	√		null
vw_element_subscriber	fk_pipe	int4	10	√		null
vw_element_subscriber	fk_precision	int4	10	√		null
vw_element_subscriber	fk_precisionalti	int4	10	√		null
vw_element_subscriber	fk_pressurezone	int4	10	√		null
vw_element_subscriber	fk_printmap	_int4	10	√		null
vw_element_subscriber	fk_status	int4	10	√		null
vw_element_subscriber	fk_subscriber_type	int4	10	√		null
vw_element_subscriber	flow_current	numeric	8,2	√		null
vw_element_subscriber	flow_planned	numeric	8,2	√		null
vw_element_subscriber	geometry	geometry	2147483647	√		null
vw_element_subscriber	geometry_alt1	geometry	2147483647	√		null
vw_element_subscriber	geometry_alt2	geometry	2147483647	√		null
vw_element_subscriber	id	int4	10	√		null
vw_element_subscriber	identification	varchar	50	√		null
vw_element_subscriber	label_1_rotation	float8	17,17	√		null
vw_element_subscriber	label_1_text	varchar	120	√		null
vw_element_subscriber	label_1_visible	int2	5	√		null
vw_element_subscriber	label_1_x	float8	17,17	√		null
vw_element_subscriber	label_1_y	float8	17,17	√		null
vw_element_subscriber	label_2_rotation	float8	17,17	√		null
vw_element_subscriber	label_2_text	varchar	120	√		null
vw_element_subscriber	label_2_visible	int2	5	√		null
vw_element_subscriber	label_2_x	float8	17,17	√		null
vw_element_subscriber	label_2_y	float8	17,17	√		null
vw_element_subscriber	orientation	float8	17,17	√		null
vw_element_subscriber	parcel	varchar	12	√		null
vw_element_subscriber	remark	text	2147483647	√		null
vw_element_subscriber	schema_force_visible	bool	1	√		null
vw_element_subscriber	update_geometry_alt1	bool	1	√		null
vw_element_subscriber	update_geometry_alt2	bool	1	√		null
vw_element_subscriber	year	int2	5	√		null
vw_element_subscriber	year_end	int2	5	√		null
vw_export_hydrant	_geometry_alt1_used	bool	1	√		null
vw_export_hydrant	_geometry_alt2_used	bool	1	√		null
vw_export_hydrant	_pipe_node_type	pipe_connection	2147483647	√		null
vw_export_hydrant	_pipe_orientation	float8	17,17	√		null
vw_export_hydrant	_pipe_schema_visible	bool	1	√		null
vw_export_hydrant	_printmaps	text	2147483647	√		null
vw_export_hydrant	altitude	numeric	10,3	√		null
vw_export_hydrant	distributor_name	varchar	30	√		null
vw_export_hydrant	district_colorcode	int2	5	√		null
vw_export_hydrant	district_land_registry	varchar	12	√		null
vw_export_hydrant	district_name	varchar	40	√		null
vw_export_hydrant	district_prefix	varchar	12	√		null
vw_export_hydrant	district_shortname	varchar	12	√		null
vw_export_hydrant	district_zip	varchar	12	√		null
vw_export_hydrant	fk_distributor	int4	10	√		null
vw_export_hydrant	fk_district	int4	10	√		null
vw_export_hydrant	fk_folder	int4	10	√		null
vw_export_hydrant	fk_locationtype	_int4	10	√		null
vw_export_hydrant	fk_material	int4	10	√		null
vw_export_hydrant	fk_model_inf	int4	10	√		null
vw_export_hydrant	fk_model_sup	int4	10	√		null
vw_export_hydrant	fk_object_reference	int4	10	√		null
vw_export_hydrant	fk_output	int4	10	√		null
vw_export_hydrant	fk_precision	int4	10	√		null
vw_export_hydrant	fk_precisionalti	int4	10	√		null
vw_export_hydrant	fk_pressurezone	int4	10	√		null
vw_export_hydrant	fk_printmap	_int4	10	√		null
vw_export_hydrant	fk_provider	int4	10	√		null
vw_export_hydrant	fk_status	int4	10	√		null
vw_export_hydrant	flow	numeric	8,2	√		null
vw_export_hydrant	folder_date_end	date	13	√		null
vw_export_hydrant	folder_date_start	date	13	√		null
vw_export_hydrant	folder_description	text	2147483647	√		null
vw_export_hydrant	folder_identification	varchar	50	√		null
vw_export_hydrant	geometry	geometry	2147483647	√		null
vw_export_hydrant	geometry_alt1	geometry	2147483647	√		null
vw_export_hydrant	geometry_alt2	geometry	2147483647	√		null
vw_export_hydrant	id	int4	10	√		null
vw_export_hydrant	identification	varchar	50	√		null
vw_export_hydrant	label_1_rotation	float8	17,17	√		null
vw_export_hydrant	label_1_text	varchar	120	√		null
vw_export_hydrant	label_1_visible	int2	5	√		null
vw_export_hydrant	label_1_x	float8	17,17	√		null
vw_export_hydrant	label_1_y	float8	17,17	√		null
vw_export_hydrant	label_2_rotation	float8	17,17	√		null
vw_export_hydrant	label_2_text	varchar	120	√		null
vw_export_hydrant	label_2_visible	int2	5	√		null
vw_export_hydrant	label_2_x	float8	17,17	√		null
vw_export_hydrant	label_2_y	float8	17,17	√		null
vw_export_hydrant	marked	bool	1	√		null
vw_export_hydrant	material_description_en	text	2147483647	√		null
vw_export_hydrant	material_description_fr	text	2147483647	√		null
vw_export_hydrant	material_description_ro	text	2147483647	√		null
vw_export_hydrant	material_pressure_nominal	int2	5	√		null
vw_export_hydrant	material_short_en	varchar	10	√		null
vw_export_hydrant	material_short_fr	varchar	10	√		null
vw_export_hydrant	material_short_ro	varchar	10	√		null
vw_export_hydrant	material_value_en	varchar	50	√		null
vw_export_hydrant	material_value_fr	varchar	50	√		null
vw_export_hydrant	material_value_ro	varchar	50	√		null
vw_export_hydrant	material_vl_active	bool	1	√		null
vw_export_hydrant	model_inf_description_en	text	2147483647	√		null
vw_export_hydrant	model_inf_description_fr	text	2147483647	√		null
vw_export_hydrant	model_inf_description_ro	text	2147483647	√		null
vw_export_hydrant	model_inf_short_en	varchar	10	√		null
vw_export_hydrant	model_inf_short_fr	varchar	10	√		null
vw_export_hydrant	model_inf_short_ro	varchar	10	√		null
vw_export_hydrant	model_inf_value_en	varchar	50	√		null
vw_export_hydrant	model_inf_value_fr	varchar	50	√		null
vw_export_hydrant	model_inf_value_ro	varchar	50	√		null
vw_export_hydrant	model_inf_vl_active	bool	1	√		null
vw_export_hydrant	model_sup_description_en	text	2147483647	√		null
vw_export_hydrant	model_sup_description_fr	text	2147483647	√		null
vw_export_hydrant	model_sup_description_ro	text	2147483647	√		null
vw_export_hydrant	model_sup_short_en	varchar	10	√		null
vw_export_hydrant	model_sup_short_fr	varchar	10	√		null
vw_export_hydrant	model_sup_short_ro	varchar	10	√		null
vw_export_hydrant	model_sup_value_en	varchar	50	√		null
vw_export_hydrant	model_sup_value_fr	varchar	50	√		null
vw_export_hydrant	model_sup_value_ro	varchar	50	√		null
vw_export_hydrant	model_sup_vl_active	bool	1	√		null
vw_export_hydrant	object_reference_description_en	text	2147483647	√		null
vw_export_hydrant	object_reference_description_fr	text	2147483647	√		null
vw_export_hydrant	object_reference_description_ro	text	2147483647	√		null
vw_export_hydrant	object_reference_short_en	varchar	10	√		null
vw_export_hydrant	object_reference_short_fr	varchar	10	√		null
vw_export_hydrant	object_reference_short_ro	varchar	10	√		null
vw_export_hydrant	object_reference_value_en	varchar	50	√		null
vw_export_hydrant	object_reference_value_fr	varchar	50	√		null
vw_export_hydrant	object_reference_value_ro	varchar	50	√		null
vw_export_hydrant	object_reference_vl_active	bool	1	√		null
vw_export_hydrant	observation_date	date	13	√		null
vw_export_hydrant	observation_source	varchar	45	√		null
vw_export_hydrant	orientation	float8	17,17	√		null
vw_export_hydrant	output_description_en	text	2147483647	√		null
vw_export_hydrant	output_description_fr	text	2147483647	√		null
vw_export_hydrant	output_description_ro	text	2147483647	√		null
vw_export_hydrant	output_short_en	varchar	10	√		null
vw_export_hydrant	output_short_fr	varchar	10	√		null
vw_export_hydrant	output_short_ro	varchar	10	√		null
vw_export_hydrant	output_value_en	varchar	50	√		null
vw_export_hydrant	output_value_fr	varchar	50	√		null
vw_export_hydrant	output_value_ro	varchar	50	√		null
vw_export_hydrant	output_vl_active	bool	1	√		null
vw_export_hydrant	precision_code_sire	int2	5	√		null
vw_export_hydrant	precision_description_en	text	2147483647	√		null
vw_export_hydrant	precision_description_fr	text	2147483647	√		null
vw_export_hydrant	precision_description_ro	text	2147483647	√		null
vw_export_hydrant	precision_short_en	varchar	10	√		null
vw_export_hydrant	precision_short_fr	varchar	10	√		null
vw_export_hydrant	precision_short_ro	varchar	10	√		null
vw_export_hydrant	precision_value_en	varchar	50	√		null
vw_export_hydrant	precision_value_fr	varchar	50	√		null
vw_export_hydrant	precision_value_ro	varchar	50	√		null
vw_export_hydrant	precision_vl_active	bool	1	√		null
vw_export_hydrant	precisionalti_code_sire	int2	5	√		null
vw_export_hydrant	precisionalti_description_en	text	2147483647	√		null
vw_export_hydrant	precisionalti_description_fr	text	2147483647	√		null
vw_export_hydrant	precisionalti_description_ro	text	2147483647	√		null
vw_export_hydrant	precisionalti_short_en	varchar	10	√		null
vw_export_hydrant	precisionalti_short_fr	varchar	10	√		null
vw_export_hydrant	precisionalti_short_ro	varchar	10	√		null
vw_export_hydrant	precisionalti_value_en	varchar	50	√		null
vw_export_hydrant	precisionalti_value_fr	varchar	50	√		null
vw_export_hydrant	precisionalti_value_ro	varchar	50	√		null
vw_export_hydrant	precisionalti_vl_active	bool	1	√		null
vw_export_hydrant	pressure_dynamic	numeric	5,2	√		null
vw_export_hydrant	pressure_static	numeric	5,2	√		null
vw_export_hydrant	pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_hydrant	pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_hydrant	pressurezone_colorcode	int2	5	√		null
vw_export_hydrant	pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_hydrant	pressurezone_fk_distributor	int4	10	√		null
vw_export_hydrant	pressurezone_name	varchar	50	√		null
vw_export_hydrant	pressurezone_population	int4	10	√		null
vw_export_hydrant	pressurezone_subscriber	int4	10	√		null
vw_export_hydrant	pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_hydrant	pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_hydrant	provider_description_en	text	2147483647	√		null
vw_export_hydrant	provider_description_fr	text	2147483647	√		null
vw_export_hydrant	provider_description_ro	text	2147483647	√		null
vw_export_hydrant	provider_short_en	varchar	10	√		null
vw_export_hydrant	provider_short_fr	varchar	10	√		null
vw_export_hydrant	provider_short_ro	varchar	10	√		null
vw_export_hydrant	provider_value_en	varchar	50	√		null
vw_export_hydrant	provider_value_fr	varchar	50	√		null
vw_export_hydrant	provider_value_ro	varchar	50	√		null
vw_export_hydrant	provider_vl_active	bool	1	√		null
vw_export_hydrant	remark	text	2147483647	√		null
vw_export_hydrant	schema_force_visible	bool	1	√		null
vw_export_hydrant	status_active	bool	1	√		null
vw_export_hydrant	status_code_sire	int2	5	√		null
vw_export_hydrant	status_description_en	text	2147483647	√		null
vw_export_hydrant	status_description_fr	text	2147483647	√		null
vw_export_hydrant	status_description_ro	text	2147483647	√		null
vw_export_hydrant	status_functional	bool	1	√		null
vw_export_hydrant	status_short_en	varchar	10	√		null
vw_export_hydrant	status_short_fr	varchar	10	√		null
vw_export_hydrant	status_short_ro	varchar	10	√		null
vw_export_hydrant	status_value_en	varchar	50	√		null
vw_export_hydrant	status_value_fr	varchar	50	√		null
vw_export_hydrant	status_value_ro	varchar	50	√		null
vw_export_hydrant	status_vl_active	bool	1	√		null
vw_export_hydrant	underground	bool	1	√		null
vw_export_hydrant	update_geometry_alt1	bool	1	√		null
vw_export_hydrant	update_geometry_alt2	bool	1	√		null
vw_export_hydrant	year	int2	5	√		null
vw_export_hydrant	year_end	int2	5	√		null
vw_export_installation	_cistern1_litrepercm	numeric	9,3	√		null
vw_export_installation	_cistern2_litrepercm	numeric	9,3	√		null
vw_export_installation	_geometry_alt1_used	bool	1	√		null
vw_export_installation	_geometry_alt2_used	bool	1	√		null
vw_export_installation	_litrepercm	numeric	9,3	√		null
vw_export_installation	_pipe_node_type	pipe_connection	2147483647	√		null
vw_export_installation	_pipe_orientation	float8	17,17	√		null
vw_export_installation	_pipe_schema_visible	bool	1	√		null
vw_export_installation	_printmaps	text	2147483647	√		null
vw_export_installation	activatedcharcoal	bool	1	√		null
vw_export_installation	altitude	numeric	10,3	√		null
vw_export_installation	altitude_apron	numeric	7,3	√		null
vw_export_installation	altitude_overflow	numeric	7,3	√		null
vw_export_installation	cistern1_description_en	text	2147483647	√		null
vw_export_installation	cistern1_description_fr	text	2147483647	√		null
vw_export_installation	cistern1_description_ro	text	2147483647	√		null
vw_export_installation	cistern1_dimension_1	numeric	10,2	√		null
vw_export_installation	cistern1_dimension_2	numeric	10,2	√		null
vw_export_installation	cistern1_fk_type	int4	10	√		null
vw_export_installation	cistern1_short_en	varchar	10	√		null
vw_export_installation	cistern1_short_fr	varchar	10	√		null
vw_export_installation	cistern1_short_ro	varchar	10	√		null
vw_export_installation	cistern1_storage	numeric	10,2	√		null
vw_export_installation	cistern1_value_en	varchar	50	√		null
vw_export_installation	cistern1_value_fr	varchar	50	√		null
vw_export_installation	cistern1_value_ro	varchar	50	√		null
vw_export_installation	cistern1_vl_active	bool	1	√		null
vw_export_installation	cistern2_description_en	text	2147483647	√		null
vw_export_installation	cistern2_description_fr	text	2147483647	√		null
vw_export_installation	cistern2_description_ro	text	2147483647	√		null
vw_export_installation	cistern2_dimension_1	numeric	10,2	√		null
vw_export_installation	cistern2_dimension_2	numeric	10,2	√		null
vw_export_installation	cistern2_fk_type	int4	10	√		null
vw_export_installation	cistern2_short_en	varchar	10	√		null
vw_export_installation	cistern2_short_fr	varchar	10	√		null
vw_export_installation	cistern2_short_ro	varchar	10	√		null
vw_export_installation	cistern2_storage	numeric	10,2	√		null
vw_export_installation	cistern2_value_en	varchar	50	√		null
vw_export_installation	cistern2_value_fr	varchar	50	√		null
vw_export_installation	cistern2_value_ro	varchar	50	√		null
vw_export_installation	cistern2_vl_active	bool	1	√		null
vw_export_installation	contract_end	date	13	√		null
vw_export_installation	depth	numeric	10,3	√		null
vw_export_installation	distributor_name	varchar	30	√		null
vw_export_installation	district_colorcode	int2	5	√		null
vw_export_installation	district_land_registry	varchar	12	√		null
vw_export_installation	district_name	varchar	40	√		null
vw_export_installation	district_prefix	varchar	12	√		null
vw_export_installation	district_shortname	varchar	12	√		null
vw_export_installation	district_zip	varchar	12	√		null
vw_export_installation	eca	varchar	30	√		null
vw_export_installation	filtration_membrane	bool	1	√		null
vw_export_installation	filtration_sandorgravel	bool	1	√		null
vw_export_installation	fire_remote	bool	1	√		null
vw_export_installation	fire_valve	bool	1	√		null
vw_export_installation	fk_distributor	int4	10	√		null
vw_export_installation	fk_district	int4	10	√		null
vw_export_installation	fk_folder	int4	10	√		null
vw_export_installation	fk_locationtype	_int4	10	√		null
vw_export_installation	fk_object_reference	int4	10	√		null
vw_export_installation	fk_overflow	int4	10	√		null
vw_export_installation	fk_parent	int4	10	√		null
vw_export_installation	fk_pipe_in	int4	10	√		null
vw_export_installation	fk_pipe_out	int4	10	√		null
vw_export_installation	fk_precision	int4	10	√		null
vw_export_installation	fk_precisionalti	int4	10	√		null
vw_export_installation	fk_pressurecontrol_type	int4	10	√		null
vw_export_installation	fk_pressurezone	int4	10	√		null
vw_export_installation	fk_printmap	_int4	10	√		null
vw_export_installation	fk_pump_operating	int2	5	√		null
vw_export_installation	fk_pump_type	int2	5	√		null
vw_export_installation	fk_remote	int4	10	√		null
vw_export_installation	fk_source_quality	int2	5	√		null
vw_export_installation	fk_source_type	int2	5	√		null
vw_export_installation	fk_status	int4	10	√		null
vw_export_installation	fk_tank_firestorage	int4	10	√		null
vw_export_installation	fk_watertype	int4	10	√		null
vw_export_installation	flocculation	bool	1	√		null
vw_export_installation	flow_average	numeric	10,3	√		null
vw_export_installation	flow_concession	numeric	10,2	√		null
vw_export_installation	flow_lowest	numeric	10,3	√		null
vw_export_installation	flow_meter	bool	1	√		null
vw_export_installation	folder_date_end	date	13	√		null
vw_export_installation	folder_date_start	date	13	√		null
vw_export_installation	folder_description	text	2147483647	√		null
vw_export_installation	folder_identification	varchar	50	√		null
vw_export_installation	gathering_chamber	bool	1	√		null
vw_export_installation	geometry	geometry	2147483647	√		null
vw_export_installation	geometry_alt1	geometry	2147483647	√		null
vw_export_installation	geometry_alt2	geometry	2147483647	√		null
vw_export_installation	geometry_polygon	geometry	2147483647	√		null
vw_export_installation	height_max	numeric	7,3	√		null
vw_export_installation	id	int4	10	√		null
vw_export_installation	identification	varchar	50	√		null
vw_export_installation	installation_type	installation_type	2147483647	√		null
vw_export_installation	label_1_rotation	float8	17,17	√		null
vw_export_installation	label_1_text	varchar	120	√		null
vw_export_installation	label_1_visible	int2	5	√		null
vw_export_installation	label_1_x	float8	17,17	√		null
vw_export_installation	label_1_y	float8	17,17	√		null
vw_export_installation	label_2_rotation	float8	17,17	√		null
vw_export_installation	label_2_text	varchar	120	√		null
vw_export_installation	label_2_visible	int2	5	√		null
vw_export_installation	label_2_x	float8	17,17	√		null
vw_export_installation	label_2_y	float8	17,17	√		null
vw_export_installation	manometer	bool	1	√		null
vw_export_installation	manometric_height	numeric	10,2	√		null
vw_export_installation	name	varchar	60	√		null
vw_export_installation	networkseparation	bool	1	√		null
vw_export_installation	no_pumps	int2	5	√		null
vw_export_installation	no_valves	int2	5	√		null
vw_export_installation	object_reference_description_en	text	2147483647	√		null
vw_export_installation	object_reference_description_fr	text	2147483647	√		null
vw_export_installation	object_reference_description_ro	text	2147483647	√		null
vw_export_installation	object_reference_short_en	varchar	10	√		null
vw_export_installation	object_reference_short_fr	varchar	10	√		null
vw_export_installation	object_reference_short_ro	varchar	10	√		null
vw_export_installation	object_reference_value_en	varchar	50	√		null
vw_export_installation	object_reference_value_fr	varchar	50	√		null
vw_export_installation	object_reference_value_ro	varchar	50	√		null
vw_export_installation	object_reference_vl_active	bool	1	√		null
vw_export_installation	open_water_surface	bool	1	√		null
vw_export_installation	orientation	float8	17,17	√		null
vw_export_installation	overflow_description_en	text	2147483647	√		null
vw_export_installation	overflow_description_fr	text	2147483647	√		null
vw_export_installation	overflow_description_ro	text	2147483647	√		null
vw_export_installation	overflow_short_en	varchar	10	√		null
vw_export_installation	overflow_short_fr	varchar	10	√		null
vw_export_installation	overflow_short_ro	varchar	10	√		null
vw_export_installation	overflow_value_en	varchar	50	√		null
vw_export_installation	overflow_value_fr	varchar	50	√		null
vw_export_installation	overflow_value_ro	varchar	50	√		null
vw_export_installation	overflow_vl_active	bool	1	√		null
vw_export_installation	parcel	varchar	30	√		null
vw_export_installation	precision_code_sire	int2	5	√		null
vw_export_installation	precision_description_en	text	2147483647	√		null
vw_export_installation	precision_description_fr	text	2147483647	√		null
vw_export_installation	precision_description_ro	text	2147483647	√		null
vw_export_installation	precision_short_en	varchar	10	√		null
vw_export_installation	precision_short_fr	varchar	10	√		null
vw_export_installation	precision_short_ro	varchar	10	√		null
vw_export_installation	precision_value_en	varchar	50	√		null
vw_export_installation	precision_value_fr	varchar	50	√		null
vw_export_installation	precision_value_ro	varchar	50	√		null
vw_export_installation	precision_vl_active	bool	1	√		null
vw_export_installation	precisionalti_code_sire	int2	5	√		null
vw_export_installation	precisionalti_description_en	text	2147483647	√		null
vw_export_installation	precisionalti_description_fr	text	2147483647	√		null
vw_export_installation	precisionalti_description_ro	text	2147483647	√		null
vw_export_installation	precisionalti_short_en	varchar	10	√		null
vw_export_installation	precisionalti_short_fr	varchar	10	√		null
vw_export_installation	precisionalti_short_ro	varchar	10	√		null
vw_export_installation	precisionalti_value_en	varchar	50	√		null
vw_export_installation	precisionalti_value_fr	varchar	50	√		null
vw_export_installation	precisionalti_value_ro	varchar	50	√		null
vw_export_installation	precisionalti_vl_active	bool	1	√		null
vw_export_installation	pressurecontrol_type_description_en	text	2147483647	√		null
vw_export_installation	pressurecontrol_type_description_fr	text	2147483647	√		null
vw_export_installation	pressurecontrol_type_description_ro	text	2147483647	√		null
vw_export_installation	pressurecontrol_type_short_en	varchar	10	√		null
vw_export_installation	pressurecontrol_type_short_fr	varchar	10	√		null
vw_export_installation	pressurecontrol_type_short_ro	varchar	10	√		null
vw_export_installation	pressurecontrol_type_value_en	varchar	50	√		null
vw_export_installation	pressurecontrol_type_value_fr	varchar	50	√		null
vw_export_installation	pressurecontrol_type_value_ro	varchar	50	√		null
vw_export_installation	pressurecontrol_type_vl_active	bool	1	√		null
vw_export_installation	pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_installation	pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_installation	pressurezone_colorcode	int2	5	√		null
vw_export_installation	pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_installation	pressurezone_fk_distributor	int4	10	√		null
vw_export_installation	pressurezone_name	varchar	50	√		null
vw_export_installation	pressurezone_population	int4	10	√		null
vw_export_installation	pressurezone_subscriber	int4	10	√		null
vw_export_installation	pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_installation	pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_installation	pump_operating_code_sire	int2	5	√		null
vw_export_installation	pump_operating_description_en	text	2147483647	√		null
vw_export_installation	pump_operating_description_fr	text	2147483647	√		null
vw_export_installation	pump_operating_description_ro	text	2147483647	√		null
vw_export_installation	pump_operating_short_en	varchar	10	√		null
vw_export_installation	pump_operating_short_fr	varchar	10	√		null
vw_export_installation	pump_operating_short_ro	varchar	10	√		null
vw_export_installation	pump_operating_value_en	varchar	50	√		null
vw_export_installation	pump_operating_value_fr	varchar	50	√		null
vw_export_installation	pump_operating_value_ro	varchar	50	√		null
vw_export_installation	pump_operating_vl_active	bool	1	√		null
vw_export_installation	pump_type_code_sire	int2	5	√		null
vw_export_installation	pump_type_description_en	text	2147483647	√		null
vw_export_installation	pump_type_description_fr	text	2147483647	√		null
vw_export_installation	pump_type_description_ro	text	2147483647	√		null
vw_export_installation	pump_type_short_en	varchar	10	√		null
vw_export_installation	pump_type_short_fr	varchar	10	√		null
vw_export_installation	pump_type_short_ro	varchar	10	√		null
vw_export_installation	pump_type_value_en	varchar	50	√		null
vw_export_installation	pump_type_value_fr	varchar	50	√		null
vw_export_installation	pump_type_value_ro	varchar	50	√		null
vw_export_installation	pump_type_vl_active	bool	1	√		null
vw_export_installation	rejected_flow	numeric	10,2	√		null
vw_export_installation	remark	text	2147483647	√		null
vw_export_installation	remote_description_en	text	2147483647	√		null
vw_export_installation	remote_description_fr	text	2147483647	√		null
vw_export_installation	remote_description_ro	text	2147483647	√		null
vw_export_installation	remote_short_en	varchar	10	√		null
vw_export_installation	remote_short_fr	varchar	10	√		null
vw_export_installation	remote_short_ro	varchar	10	√		null
vw_export_installation	remote_value_en	varchar	50	√		null
vw_export_installation	remote_value_fr	varchar	50	√		null
vw_export_installation	remote_value_ro	varchar	50	√		null
vw_export_installation	remote_vl_active	bool	1	√		null
vw_export_installation	sanitization_chlorine_gazeous	bool	1	√		null
vw_export_installation	sanitization_chlorine_liquid	bool	1	√		null
vw_export_installation	sanitization_ozone	bool	1	√		null
vw_export_installation	sanitization_uv	bool	1	√		null
vw_export_installation	schema_force_visible	bool	1	√		null
vw_export_installation	settling	bool	1	√		null
vw_export_installation	source_quality_code_sire	int2	5	√		null
vw_export_installation	source_quality_description_en	text	2147483647	√		null
vw_export_installation	source_quality_description_fr	text	2147483647	√		null
vw_export_installation	source_quality_description_ro	text	2147483647	√		null
vw_export_installation	source_quality_short_en	varchar	10	√		null
vw_export_installation	source_quality_short_fr	varchar	10	√		null
vw_export_installation	source_quality_short_ro	varchar	10	√		null
vw_export_installation	source_quality_value_en	varchar	50	√		null
vw_export_installation	source_quality_value_fr	varchar	50	√		null
vw_export_installation	source_quality_value_ro	varchar	50	√		null
vw_export_installation	source_quality_vl_active	bool	1	√		null
vw_export_installation	source_type_code_sire	int2	5	√		null
vw_export_installation	source_type_description_en	text	2147483647	√		null
vw_export_installation	source_type_description_fr	text	2147483647	√		null
vw_export_installation	source_type_description_ro	text	2147483647	√		null
vw_export_installation	source_type_short_en	varchar	10	√		null
vw_export_installation	source_type_short_fr	varchar	10	√		null
vw_export_installation	source_type_short_ro	varchar	10	√		null
vw_export_installation	source_type_value_en	varchar	50	√		null
vw_export_installation	source_type_value_fr	varchar	50	√		null
vw_export_installation	source_type_value_ro	varchar	50	√		null
vw_export_installation	source_type_vl_active	bool	1	√		null
vw_export_installation	status_active	bool	1	√		null
vw_export_installation	status_code_sire	int2	5	√		null
vw_export_installation	status_description_en	text	2147483647	√		null
vw_export_installation	status_description_fr	text	2147483647	√		null
vw_export_installation	status_description_ro	text	2147483647	√		null
vw_export_installation	status_functional	bool	1	√		null
vw_export_installation	status_short_en	varchar	10	√		null
vw_export_installation	status_short_fr	varchar	10	√		null
vw_export_installation	status_short_ro	varchar	10	√		null
vw_export_installation	status_value_en	varchar	50	√		null
vw_export_installation	status_value_fr	varchar	50	√		null
vw_export_installation	status_value_ro	varchar	50	√		null
vw_export_installation	status_vl_active	bool	1	√		null
vw_export_installation	storage_fire	numeric	10,1	√		null
vw_export_installation	storage_supply	numeric	10,1	√		null
vw_export_installation	storage_total	numeric	10,1	√		null
vw_export_installation	tank_firestorage_description_en	text	2147483647	√		null
vw_export_installation	tank_firestorage_description_fr	text	2147483647	√		null
vw_export_installation	tank_firestorage_description_ro	text	2147483647	√		null
vw_export_installation	tank_firestorage_short_en	varchar	10	√		null
vw_export_installation	tank_firestorage_short_fr	varchar	10	√		null
vw_export_installation	tank_firestorage_short_ro	varchar	10	√		null
vw_export_installation	tank_firestorage_value_en	varchar	50	√		null
vw_export_installation	tank_firestorage_value_fr	varchar	50	√		null
vw_export_installation	tank_firestorage_value_ro	varchar	50	√		null
vw_export_installation	tank_firestorage_vl_active	bool	1	√		null
vw_export_installation	treatment_capacity	numeric	10,2	√		null
vw_export_installation	update_geometry_alt1	bool	1	√		null
vw_export_installation	update_geometry_alt2	bool	1	√		null
vw_export_installation	water_meter	bool	1	√		null
vw_export_installation	watertype_code_sire	int2	5	√		null
vw_export_installation	watertype_description_en	text	2147483647	√		null
vw_export_installation	watertype_description_fr	text	2147483647	√		null
vw_export_installation	watertype_description_ro	text	2147483647	√		null
vw_export_installation	watertype_short_en	varchar	10	√		null
vw_export_installation	watertype_short_fr	varchar	10	√		null
vw_export_installation	watertype_short_ro	varchar	10	√		null
vw_export_installation	watertype_value_en	varchar	50	√		null
vw_export_installation	watertype_value_fr	varchar	50	√		null
vw_export_installation	watertype_value_ro	varchar	50	√		null
vw_export_installation	watertype_vl_active	bool	1	√		null
vw_export_installation	year	int2	5	√		null
vw_export_installation	year_end	int2	5	√		null
vw_export_leak	_repaired	bool	1	√		null
vw_export_leak	address	text	2147483647	√		null
vw_export_leak	cause_description_en	text	2147483647	√		null
vw_export_leak	cause_description_fr	text	2147483647	√		null
vw_export_leak	cause_description_ro	text	2147483647	√		null
vw_export_leak	cause_short_en	varchar	10	√		null
vw_export_leak	cause_short_fr	varchar	10	√		null
vw_export_leak	cause_short_ro	varchar	10	√		null
vw_export_leak	cause_value_en	varchar	50	√		null
vw_export_leak	cause_value_fr	varchar	50	√		null
vw_export_leak	cause_value_ro	varchar	50	√		null
vw_export_leak	cause_vl_active	bool	1	√		null
vw_export_leak	description	text	2147483647	√		null
vw_export_leak	detection_date	date	13	√		null
vw_export_leak	fk_cause	int4	10	√		null
vw_export_leak	fk_pipe	int4	10	√		null
vw_export_leak	geometry	geometry	2147483647	√		null
vw_export_leak	id	int4	10	√		null
vw_export_leak	label_1_rotation	float8	17,17	√		null
vw_export_leak	label_1_text	varchar	120	√		null
vw_export_leak	label_1_visible	int2	5	√		null
vw_export_leak	label_1_x	float8	17,17	√		null
vw_export_leak	label_1_y	float8	17,17	√		null
vw_export_leak	label_2_rotation	float8	17,17	√		null
vw_export_leak	label_2_text	varchar	120	√		null
vw_export_leak	label_2_visible	int2	5	√		null
vw_export_leak	label_2_x	float8	17,17	√		null
vw_export_leak	label_2_y	float8	17,17	√		null
vw_export_leak	pipe__diff_elevation	numeric	8,2	√		null
vw_export_leak	pipe__geometry_alt1_used	bool	1	√		null
vw_export_leak	pipe__geometry_alt2_used	bool	1	√		null
vw_export_leak	pipe__length2d	numeric	8,2	√		null
vw_export_leak	pipe__length3d	numeric	8,2	√		null
vw_export_leak	pipe__printmaps	varchar	100	√		null
vw_export_leak	pipe__valve_closed	bool	1	√		null
vw_export_leak	pipe__valve_count	int2	5	√		null
vw_export_leak	pipe_distributor_name	varchar	30	√		null
vw_export_leak	pipe_district_colorcode	int2	5	√		null
vw_export_leak	pipe_district_land_registry	varchar	12	√		null
vw_export_leak	pipe_district_name	varchar	40	√		null
vw_export_leak	pipe_district_prefix	varchar	12	√		null
vw_export_leak	pipe_district_shortname	varchar	12	√		null
vw_export_leak	pipe_district_zip	varchar	12	√		null
vw_export_leak	pipe_fk_bedding	int4	10	√		null
vw_export_leak	pipe_fk_distributor	int4	10	√		null
vw_export_leak	pipe_fk_district	int4	10	√		null
vw_export_leak	pipe_fk_folder	int4	10	√		null
vw_export_leak	pipe_fk_function	int4	10	√		null
vw_export_leak	pipe_fk_installmethod	int4	10	√		null
vw_export_leak	pipe_fk_locationtype	_int4	10	√		null
vw_export_leak	pipe_fk_material	int4	10	√		null
vw_export_leak	pipe_fk_node_a	int4	10	√		null
vw_export_leak	pipe_fk_node_b	int4	10	√		null
vw_export_leak	pipe_fk_parent	int4	10	√		null
vw_export_leak	pipe_fk_precision	int4	10	√		null
vw_export_leak	pipe_fk_pressurezone	int4	10	√		null
vw_export_leak	pipe_fk_printmap	_int4	10	√		null
vw_export_leak	pipe_fk_protection	int4	10	√		null
vw_export_leak	pipe_fk_status	int4	10	√		null
vw_export_leak	pipe_fk_watertype	int4	10	√		null
vw_export_leak	pipe_folder_date_end	date	13	√		null
vw_export_leak	pipe_folder_date_start	date	13	√		null
vw_export_leak	pipe_folder_description	text	2147483647	√		null
vw_export_leak	pipe_folder_identification	varchar	50	√		null
vw_export_leak	pipe_function_code_sire	int2	5	√		null
vw_export_leak	pipe_function_description_en	text	2147483647	√		null
vw_export_leak	pipe_function_description_fr	text	2147483647	√		null
vw_export_leak	pipe_function_description_ro	text	2147483647	√		null
vw_export_leak	pipe_function_major	bool	1	√		null
vw_export_leak	pipe_function_schema_visible	bool	1	√		null
vw_export_leak	pipe_function_short_en	varchar	10	√		null
vw_export_leak	pipe_function_short_fr	varchar	10	√		null
vw_export_leak	pipe_function_short_ro	varchar	10	√		null
vw_export_leak	pipe_function_value_en	varchar	50	√		null
vw_export_leak	pipe_function_value_fr	varchar	50	√		null
vw_export_leak	pipe_function_value_ro	varchar	50	√		null
vw_export_leak	pipe_function_vl_active	bool	1	√		null
vw_export_leak	pipe_installmethod_description_en	text	2147483647	√		null
vw_export_leak	pipe_installmethod_description_fr	text	2147483647	√		null
vw_export_leak	pipe_installmethod_description_ro	text	2147483647	√		null
vw_export_leak	pipe_installmethod_short_en	varchar	10	√		null
vw_export_leak	pipe_installmethod_short_fr	varchar	10	√		null
vw_export_leak	pipe_installmethod_short_ro	varchar	10	√		null
vw_export_leak	pipe_installmethod_value_en	varchar	50	√		null
vw_export_leak	pipe_installmethod_value_fr	varchar	50	√		null
vw_export_leak	pipe_installmethod_value_ro	varchar	50	√		null
vw_export_leak	pipe_installmethod_vl_active	bool	1	√		null
vw_export_leak	pipe_material__displayname_en	varchar	30	√		null
vw_export_leak	pipe_material__displayname_fr	varchar	30	√		null
vw_export_leak	pipe_material__displayname_ro	varchar	30	√		null
vw_export_leak	pipe_material_code_sire	int2	5	√		null
vw_export_leak	pipe_material_description_en	text	2147483647	√		null
vw_export_leak	pipe_material_description_fr	text	2147483647	√		null
vw_export_leak	pipe_material_description_ro	text	2147483647	√		null
vw_export_leak	pipe_material_diameter	varchar	10	√		null
vw_export_leak	pipe_material_diameter_external	numeric	7,3	√		null
vw_export_leak	pipe_material_diameter_internal	numeric	7,3	√		null
vw_export_leak	pipe_material_diameter_nominal	int2	5	√		null
vw_export_leak	pipe_material_pressure_nominal	float8	17,17	√		null
vw_export_leak	pipe_material_sdr	float8	17,17	√		null
vw_export_leak	pipe_material_short_en	varchar	10	√		null
vw_export_leak	pipe_material_short_fr	varchar	10	√		null
vw_export_leak	pipe_material_short_ro	varchar	10	√		null
vw_export_leak	pipe_material_sn	int4	10	√		null
vw_export_leak	pipe_material_value_en	varchar	50	√		null
vw_export_leak	pipe_material_value_fr	varchar	50	√		null
vw_export_leak	pipe_material_value_ro	varchar	50	√		null
vw_export_leak	pipe_material_vl_active	bool	1	√		null
vw_export_leak	pipe_material_wall_thickness	numeric	4,1	√		null
vw_export_leak	pipe_node_a__geometry_alt1_used	bool	1	√		null
vw_export_leak	pipe_node_a__geometry_alt2_used	bool	1	√		null
vw_export_leak	pipe_node_a__pipe_node_type	pipe_connection	2147483647	√		null
vw_export_leak	pipe_node_a__pipe_orientation	float8	17,17	√		null
vw_export_leak	pipe_node_a__pipe_schema_visible	bool	1	√		null
vw_export_leak	pipe_node_a__printmaps	text	2147483647	√		null
vw_export_leak	pipe_node_a_fk_district	int4	10	√		null
vw_export_leak	pipe_node_a_fk_pressurezone	int4	10	√		null
vw_export_leak	pipe_node_a_fk_printmap	_int4	10	√		null
vw_export_leak	pipe_node_a_update_geometry_alt1	bool	1	√		null
vw_export_leak	pipe_node_a_update_geometry_alt2	bool	1	√		null
vw_export_leak	pipe_node_b__geometry_alt1_used	bool	1	√		null
vw_export_leak	pipe_node_b__geometry_alt2_used	bool	1	√		null
vw_export_leak	pipe_node_b__pipe_node_type	pipe_connection	2147483647	√		null
vw_export_leak	pipe_node_b__pipe_orientation	float8	17,17	√		null
vw_export_leak	pipe_node_b__pipe_schema_visible	bool	1	√		null
vw_export_leak	pipe_node_b__printmaps	text	2147483647	√		null
vw_export_leak	pipe_node_b_fk_district	int4	10	√		null
vw_export_leak	pipe_node_b_fk_pressurezone	int4	10	√		null
vw_export_leak	pipe_node_b_fk_printmap	_int4	10	√		null
vw_export_leak	pipe_node_b_update_geometry_alt1	bool	1	√		null
vw_export_leak	pipe_node_b_update_geometry_alt2	bool	1	√		null
vw_export_leak	pipe_precision_code_sire	int2	5	√		null
vw_export_leak	pipe_precision_description_en	text	2147483647	√		null
vw_export_leak	pipe_precision_description_fr	text	2147483647	√		null
vw_export_leak	pipe_precision_description_ro	text	2147483647	√		null
vw_export_leak	pipe_precision_short_en	varchar	10	√		null
vw_export_leak	pipe_precision_short_fr	varchar	10	√		null
vw_export_leak	pipe_precision_short_ro	varchar	10	√		null
vw_export_leak	pipe_precision_value_en	varchar	50	√		null
vw_export_leak	pipe_precision_value_fr	varchar	50	√		null
vw_export_leak	pipe_precision_value_ro	varchar	50	√		null
vw_export_leak	pipe_precision_vl_active	bool	1	√		null
vw_export_leak	pipe_pressure_nominal	int2	5	√		null
vw_export_leak	pipe_pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_leak	pipe_pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_leak	pipe_pressurezone_colorcode	int2	5	√		null
vw_export_leak	pipe_pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_leak	pipe_pressurezone_fk_distributor	int4	10	√		null
vw_export_leak	pipe_pressurezone_name	varchar	50	√		null
vw_export_leak	pipe_pressurezone_population	int4	10	√		null
vw_export_leak	pipe_pressurezone_subscriber	int4	10	√		null
vw_export_leak	pipe_pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_leak	pipe_pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_leak	pipe_protection_description_en	text	2147483647	√		null
vw_export_leak	pipe_protection_description_fr	text	2147483647	√		null
vw_export_leak	pipe_protection_description_ro	text	2147483647	√		null
vw_export_leak	pipe_protection_short_en	varchar	10	√		null
vw_export_leak	pipe_protection_short_fr	varchar	10	√		null
vw_export_leak	pipe_protection_short_ro	varchar	10	√		null
vw_export_leak	pipe_protection_value_en	varchar	50	√		null
vw_export_leak	pipe_protection_value_fr	varchar	50	√		null
vw_export_leak	pipe_protection_value_ro	varchar	50	√		null
vw_export_leak	pipe_protection_vl_active	bool	1	√		null
vw_export_leak	pipe_remark	text	2147483647	√		null
vw_export_leak	pipe_replaced	bool	1	√		null
vw_export_leak	pipe_schema_force_visible	bool	1	√		null
vw_export_leak	pipe_status_active	bool	1	√		null
vw_export_leak	pipe_status_code_sire	int2	5	√		null
vw_export_leak	pipe_status_description_en	text	2147483647	√		null
vw_export_leak	pipe_status_description_fr	text	2147483647	√		null
vw_export_leak	pipe_status_description_ro	text	2147483647	√		null
vw_export_leak	pipe_status_functional	bool	1	√		null
vw_export_leak	pipe_status_short_en	varchar	10	√		null
vw_export_leak	pipe_status_short_fr	varchar	10	√		null
vw_export_leak	pipe_status_short_ro	varchar	10	√		null
vw_export_leak	pipe_status_value_en	varchar	50	√		null
vw_export_leak	pipe_status_value_fr	varchar	50	√		null
vw_export_leak	pipe_status_value_ro	varchar	50	√		null
vw_export_leak	pipe_status_vl_active	bool	1	√		null
vw_export_leak	pipe_tunnel_or_bridge	bool	1	√		null
vw_export_leak	pipe_update_geometry_alt1	bool	1	√		null
vw_export_leak	pipe_update_geometry_alt2	bool	1	√		null
vw_export_leak	pipe_year	int2	5	√		null
vw_export_leak	pipe_year_end	int2	5	√		null
vw_export_leak	pipe_year_rehabilitation	int2	5	√		null
vw_export_leak	repair	text	2147483647	√		null
vw_export_leak	repair_date	date	13	√		null
vw_export_leak	widespread_damage	bool	1	√		null
vw_export_meter	_geometry_alt1_used	bool	1	√		null
vw_export_meter	_geometry_alt2_used	bool	1	√		null
vw_export_meter	_pipe_node_type	pipe_connection	2147483647	√		null
vw_export_meter	_pipe_orientation	float8	17,17	√		null
vw_export_meter	_pipe_schema_visible	bool	1	√		null
vw_export_meter	_printmaps	text	2147483647	√		null
vw_export_meter	altitude	numeric	10,3	√		null
vw_export_meter	distributor_name	varchar	30	√		null
vw_export_meter	district_colorcode	int2	5	√		null
vw_export_meter	district_land_registry	varchar	12	√		null
vw_export_meter	district_name	varchar	40	√		null
vw_export_meter	district_prefix	varchar	12	√		null
vw_export_meter	district_shortname	varchar	12	√		null
vw_export_meter	district_zip	varchar	12	√		null
vw_export_meter	fk_distributor	int4	10	√		null
vw_export_meter	fk_district	int4	10	√		null
vw_export_meter	fk_folder	int4	10	√		null
vw_export_meter	fk_locationtype	_int4	10	√		null
vw_export_meter	fk_object_reference	int4	10	√		null
vw_export_meter	fk_pipe	int4	10	√		null
vw_export_meter	fk_precision	int4	10	√		null
vw_export_meter	fk_precisionalti	int4	10	√		null
vw_export_meter	fk_pressurezone	int4	10	√		null
vw_export_meter	fk_printmap	_int4	10	√		null
vw_export_meter	fk_status	int4	10	√		null
vw_export_meter	folder_date_end	date	13	√		null
vw_export_meter	folder_date_start	date	13	√		null
vw_export_meter	folder_description	text	2147483647	√		null
vw_export_meter	folder_identification	varchar	50	√		null
vw_export_meter	geometry	geometry	2147483647	√		null
vw_export_meter	geometry_alt1	geometry	2147483647	√		null
vw_export_meter	geometry_alt2	geometry	2147483647	√		null
vw_export_meter	id	int4	10	√		null
vw_export_meter	identification	varchar	50	√		null
vw_export_meter	label_1_rotation	float8	17,17	√		null
vw_export_meter	label_1_text	varchar	120	√		null
vw_export_meter	label_1_visible	int2	5	√		null
vw_export_meter	label_1_x	float8	17,17	√		null
vw_export_meter	label_1_y	float8	17,17	√		null
vw_export_meter	label_2_rotation	float8	17,17	√		null
vw_export_meter	label_2_text	varchar	120	√		null
vw_export_meter	label_2_visible	int2	5	√		null
vw_export_meter	label_2_x	float8	17,17	√		null
vw_export_meter	label_2_y	float8	17,17	√		null
vw_export_meter	object_reference_description_en	text	2147483647	√		null
vw_export_meter	object_reference_description_fr	text	2147483647	√		null
vw_export_meter	object_reference_description_ro	text	2147483647	√		null
vw_export_meter	object_reference_short_en	varchar	10	√		null
vw_export_meter	object_reference_short_fr	varchar	10	√		null
vw_export_meter	object_reference_short_ro	varchar	10	√		null
vw_export_meter	object_reference_value_en	varchar	50	√		null
vw_export_meter	object_reference_value_fr	varchar	50	√		null
vw_export_meter	object_reference_value_ro	varchar	50	√		null
vw_export_meter	object_reference_vl_active	bool	1	√		null
vw_export_meter	orientation	float8	17,17	√		null
vw_export_meter	parcel	varchar	50	√		null
vw_export_meter	precision_code_sire	int2	5	√		null
vw_export_meter	precision_description_en	text	2147483647	√		null
vw_export_meter	precision_description_fr	text	2147483647	√		null
vw_export_meter	precision_description_ro	text	2147483647	√		null
vw_export_meter	precision_short_en	varchar	10	√		null
vw_export_meter	precision_short_fr	varchar	10	√		null
vw_export_meter	precision_short_ro	varchar	10	√		null
vw_export_meter	precision_value_en	varchar	50	√		null
vw_export_meter	precision_value_fr	varchar	50	√		null
vw_export_meter	precision_value_ro	varchar	50	√		null
vw_export_meter	precision_vl_active	bool	1	√		null
vw_export_meter	precisionalti_code_sire	int2	5	√		null
vw_export_meter	precisionalti_description_en	text	2147483647	√		null
vw_export_meter	precisionalti_description_fr	text	2147483647	√		null
vw_export_meter	precisionalti_description_ro	text	2147483647	√		null
vw_export_meter	precisionalti_short_en	varchar	10	√		null
vw_export_meter	precisionalti_short_fr	varchar	10	√		null
vw_export_meter	precisionalti_short_ro	varchar	10	√		null
vw_export_meter	precisionalti_value_en	varchar	50	√		null
vw_export_meter	precisionalti_value_fr	varchar	50	√		null
vw_export_meter	precisionalti_value_ro	varchar	50	√		null
vw_export_meter	precisionalti_vl_active	bool	1	√		null
vw_export_meter	pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_meter	pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_meter	pressurezone_colorcode	int2	5	√		null
vw_export_meter	pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_meter	pressurezone_fk_distributor	int4	10	√		null
vw_export_meter	pressurezone_name	varchar	50	√		null
vw_export_meter	pressurezone_population	int4	10	√		null
vw_export_meter	pressurezone_subscriber	int4	10	√		null
vw_export_meter	pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_meter	pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_meter	remark	text	2147483647	√		null
vw_export_meter	schema_force_visible	bool	1	√		null
vw_export_meter	status_active	bool	1	√		null
vw_export_meter	status_code_sire	int2	5	√		null
vw_export_meter	status_description_en	text	2147483647	√		null
vw_export_meter	status_description_fr	text	2147483647	√		null
vw_export_meter	status_description_ro	text	2147483647	√		null
vw_export_meter	status_functional	bool	1	√		null
vw_export_meter	status_short_en	varchar	10	√		null
vw_export_meter	status_short_fr	varchar	10	√		null
vw_export_meter	status_short_ro	varchar	10	√		null
vw_export_meter	status_value_en	varchar	50	√		null
vw_export_meter	status_value_fr	varchar	50	√		null
vw_export_meter	status_value_ro	varchar	50	√		null
vw_export_meter	status_vl_active	bool	1	√		null
vw_export_meter	update_geometry_alt1	bool	1	√		null
vw_export_meter	update_geometry_alt2	bool	1	√		null
vw_export_meter	year	int2	5	√		null
vw_export_meter	year_end	int2	5	√		null
vw_export_part	_geometry_alt1_used	bool	1	√		null
vw_export_part	_geometry_alt2_used	bool	1	√		null
vw_export_part	_pipe_node_type	pipe_connection	2147483647	√		null
vw_export_part	_pipe_orientation	float8	17,17	√		null
vw_export_part	_pipe_schema_visible	bool	1	√		null
vw_export_part	_printmaps	text	2147483647	√		null
vw_export_part	altitude	numeric	10,3	√		null
vw_export_part	distributor_name	varchar	30	√		null
vw_export_part	district_colorcode	int2	5	√		null
vw_export_part	district_land_registry	varchar	12	√		null
vw_export_part	district_name	varchar	40	√		null
vw_export_part	district_prefix	varchar	12	√		null
vw_export_part	district_shortname	varchar	12	√		null
vw_export_part	district_zip	varchar	12	√		null
vw_export_part	fk_distributor	int4	10	√		null
vw_export_part	fk_district	int4	10	√		null
vw_export_part	fk_folder	int4	10	√		null
vw_export_part	fk_locationtype	_int4	10	√		null
vw_export_part	fk_object_reference	int4	10	√		null
vw_export_part	fk_part_type	int4	10	√		null
vw_export_part	fk_pipe	int4	10	√		null
vw_export_part	fk_precision	int4	10	√		null
vw_export_part	fk_precisionalti	int4	10	√		null
vw_export_part	fk_pressurezone	int4	10	√		null
vw_export_part	fk_printmap	_int4	10	√		null
vw_export_part	fk_status	int4	10	√		null
vw_export_part	folder_date_end	date	13	√		null
vw_export_part	folder_date_start	date	13	√		null
vw_export_part	folder_description	text	2147483647	√		null
vw_export_part	folder_identification	varchar	50	√		null
vw_export_part	geometry	geometry	2147483647	√		null
vw_export_part	geometry_alt1	geometry	2147483647	√		null
vw_export_part	geometry_alt2	geometry	2147483647	√		null
vw_export_part	id	int4	10	√		null
vw_export_part	identification	varchar	50	√		null
vw_export_part	label_1_rotation	float8	17,17	√		null
vw_export_part	label_1_text	varchar	120	√		null
vw_export_part	label_1_visible	int2	5	√		null
vw_export_part	label_1_x	float8	17,17	√		null
vw_export_part	label_1_y	float8	17,17	√		null
vw_export_part	label_2_rotation	float8	17,17	√		null
vw_export_part	label_2_text	varchar	120	√		null
vw_export_part	label_2_visible	int2	5	√		null
vw_export_part	label_2_x	float8	17,17	√		null
vw_export_part	label_2_y	float8	17,17	√		null
vw_export_part	object_reference_description_en	text	2147483647	√		null
vw_export_part	object_reference_description_fr	text	2147483647	√		null
vw_export_part	object_reference_description_ro	text	2147483647	√		null
vw_export_part	object_reference_short_en	varchar	10	√		null
vw_export_part	object_reference_short_fr	varchar	10	√		null
vw_export_part	object_reference_short_ro	varchar	10	√		null
vw_export_part	object_reference_value_en	varchar	50	√		null
vw_export_part	object_reference_value_fr	varchar	50	√		null
vw_export_part	object_reference_value_ro	varchar	50	√		null
vw_export_part	object_reference_vl_active	bool	1	√		null
vw_export_part	orientation	float8	17,17	√		null
vw_export_part	part_type_description_en	text	2147483647	√		null
vw_export_part	part_type_description_fr	text	2147483647	√		null
vw_export_part	part_type_description_ro	text	2147483647	√		null
vw_export_part	part_type_short_en	varchar	10	√		null
vw_export_part	part_type_short_fr	varchar	10	√		null
vw_export_part	part_type_short_ro	varchar	10	√		null
vw_export_part	part_type_value_en	varchar	50	√		null
vw_export_part	part_type_value_fr	varchar	50	√		null
vw_export_part	part_type_value_ro	varchar	50	√		null
vw_export_part	part_type_vl_active	bool	1	√		null
vw_export_part	precision_code_sire	int2	5	√		null
vw_export_part	precision_description_en	text	2147483647	√		null
vw_export_part	precision_description_fr	text	2147483647	√		null
vw_export_part	precision_description_ro	text	2147483647	√		null
vw_export_part	precision_short_en	varchar	10	√		null
vw_export_part	precision_short_fr	varchar	10	√		null
vw_export_part	precision_short_ro	varchar	10	√		null
vw_export_part	precision_value_en	varchar	50	√		null
vw_export_part	precision_value_fr	varchar	50	√		null
vw_export_part	precision_value_ro	varchar	50	√		null
vw_export_part	precision_vl_active	bool	1	√		null
vw_export_part	precisionalti_code_sire	int2	5	√		null
vw_export_part	precisionalti_description_en	text	2147483647	√		null
vw_export_part	precisionalti_description_fr	text	2147483647	√		null
vw_export_part	precisionalti_description_ro	text	2147483647	√		null
vw_export_part	precisionalti_short_en	varchar	10	√		null
vw_export_part	precisionalti_short_fr	varchar	10	√		null
vw_export_part	precisionalti_short_ro	varchar	10	√		null
vw_export_part	precisionalti_value_en	varchar	50	√		null
vw_export_part	precisionalti_value_fr	varchar	50	√		null
vw_export_part	precisionalti_value_ro	varchar	50	√		null
vw_export_part	precisionalti_vl_active	bool	1	√		null
vw_export_part	pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_part	pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_part	pressurezone_colorcode	int2	5	√		null
vw_export_part	pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_part	pressurezone_fk_distributor	int4	10	√		null
vw_export_part	pressurezone_name	varchar	50	√		null
vw_export_part	pressurezone_population	int4	10	√		null
vw_export_part	pressurezone_subscriber	int4	10	√		null
vw_export_part	pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_part	pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_part	remark	text	2147483647	√		null
vw_export_part	schema_force_visible	bool	1	√		null
vw_export_part	status_active	bool	1	√		null
vw_export_part	status_code_sire	int2	5	√		null
vw_export_part	status_description_en	text	2147483647	√		null
vw_export_part	status_description_fr	text	2147483647	√		null
vw_export_part	status_description_ro	text	2147483647	√		null
vw_export_part	status_functional	bool	1	√		null
vw_export_part	status_short_en	varchar	10	√		null
vw_export_part	status_short_fr	varchar	10	√		null
vw_export_part	status_short_ro	varchar	10	√		null
vw_export_part	status_value_en	varchar	50	√		null
vw_export_part	status_value_fr	varchar	50	√		null
vw_export_part	status_value_ro	varchar	50	√		null
vw_export_part	status_vl_active	bool	1	√		null
vw_export_part	update_geometry_alt1	bool	1	√		null
vw_export_part	update_geometry_alt2	bool	1	√		null
vw_export_part	year	int2	5	√		null
vw_export_part	year_end	int2	5	√		null
vw_export_pipe	_diff_elevation	numeric	8,2	√		null
vw_export_pipe	_geometry_alt1_used	bool	1	√		null
vw_export_pipe	_geometry_alt2_used	bool	1	√		null
vw_export_pipe	_length2d	numeric	8,2	√		null
vw_export_pipe	_length3d	numeric	8,2	√		null
vw_export_pipe	_printmaps	varchar	100	√		null
vw_export_pipe	_valve_closed	bool	1	√		null
vw_export_pipe	_valve_count	int2	5	√		null
vw_export_pipe	distributor_name	varchar	30	√		null
vw_export_pipe	district_colorcode	int2	5	√		null
vw_export_pipe	district_land_registry	varchar	12	√		null
vw_export_pipe	district_name	varchar	40	√		null
vw_export_pipe	district_prefix	varchar	12	√		null
vw_export_pipe	district_shortname	varchar	12	√		null
vw_export_pipe	district_zip	varchar	12	√		null
vw_export_pipe	fk_bedding	int4	10	√		null
vw_export_pipe	fk_distributor	int4	10	√		null
vw_export_pipe	fk_district	int4	10	√		null
vw_export_pipe	fk_folder	int4	10	√		null
vw_export_pipe	fk_function	int4	10	√		null
vw_export_pipe	fk_installmethod	int4	10	√		null
vw_export_pipe	fk_locationtype	_int4	10	√		null
vw_export_pipe	fk_material	int4	10	√		null
vw_export_pipe	fk_node_a	int4	10	√		null
vw_export_pipe	fk_node_b	int4	10	√		null
vw_export_pipe	fk_parent	int4	10	√		null
vw_export_pipe	fk_precision	int4	10	√		null
vw_export_pipe	fk_pressurezone	int4	10	√		null
vw_export_pipe	fk_printmap	_int4	10	√		null
vw_export_pipe	fk_protection	int4	10	√		null
vw_export_pipe	fk_status	int4	10	√		null
vw_export_pipe	fk_watertype	int4	10	√		null
vw_export_pipe	folder_date_end	date	13	√		null
vw_export_pipe	folder_date_start	date	13	√		null
vw_export_pipe	folder_description	text	2147483647	√		null
vw_export_pipe	folder_identification	varchar	50	√		null
vw_export_pipe	function_code_sire	int2	5	√		null
vw_export_pipe	function_description_en	text	2147483647	√		null
vw_export_pipe	function_description_fr	text	2147483647	√		null
vw_export_pipe	function_description_ro	text	2147483647	√		null
vw_export_pipe	function_major	bool	1	√		null
vw_export_pipe	function_schema_visible	bool	1	√		null
vw_export_pipe	function_short_en	varchar	10	√		null
vw_export_pipe	function_short_fr	varchar	10	√		null
vw_export_pipe	function_short_ro	varchar	10	√		null
vw_export_pipe	function_value_en	varchar	50	√		null
vw_export_pipe	function_value_fr	varchar	50	√		null
vw_export_pipe	function_value_ro	varchar	50	√		null
vw_export_pipe	function_vl_active	bool	1	√		null
vw_export_pipe	geometry	geometry	2147483647	√		null
vw_export_pipe	geometry_alt1	geometry	2147483647	√		null
vw_export_pipe	geometry_alt2	geometry	2147483647	√		null
vw_export_pipe	id	int4	10	√		null
vw_export_pipe	installmethod_description_en	text	2147483647	√		null
vw_export_pipe	installmethod_description_fr	text	2147483647	√		null
vw_export_pipe	installmethod_description_ro	text	2147483647	√		null
vw_export_pipe	installmethod_short_en	varchar	10	√		null
vw_export_pipe	installmethod_short_fr	varchar	10	√		null
vw_export_pipe	installmethod_short_ro	varchar	10	√		null
vw_export_pipe	installmethod_value_en	varchar	50	√		null
vw_export_pipe	installmethod_value_fr	varchar	50	√		null
vw_export_pipe	installmethod_value_ro	varchar	50	√		null
vw_export_pipe	installmethod_vl_active	bool	1	√		null
vw_export_pipe	label_1_text	varchar	120	√		null
vw_export_pipe	label_1_visible	int2	5	√		null
vw_export_pipe	label_2_text	varchar	120	√		null
vw_export_pipe	label_2_visible	int2	5	√		null
vw_export_pipe	material__displayname_en	varchar	30	√		null
vw_export_pipe	material__displayname_fr	varchar	30	√		null
vw_export_pipe	material__displayname_ro	varchar	30	√		null
vw_export_pipe	material_code_sire	int2	5	√		null
vw_export_pipe	material_description_en	text	2147483647	√		null
vw_export_pipe	material_description_fr	text	2147483647	√		null
vw_export_pipe	material_description_ro	text	2147483647	√		null
vw_export_pipe	material_diameter	varchar	10	√		null
vw_export_pipe	material_diameter_external	numeric	7,3	√		null
vw_export_pipe	material_diameter_internal	numeric	7,3	√		null
vw_export_pipe	material_diameter_nominal	int2	5	√		null
vw_export_pipe	material_pressure_nominal	float8	17,17	√		null
vw_export_pipe	material_sdr	float8	17,17	√		null
vw_export_pipe	material_short_en	varchar	10	√		null
vw_export_pipe	material_short_fr	varchar	10	√		null
vw_export_pipe	material_short_ro	varchar	10	√		null
vw_export_pipe	material_sn	int4	10	√		null
vw_export_pipe	material_value_en	varchar	50	√		null
vw_export_pipe	material_value_fr	varchar	50	√		null
vw_export_pipe	material_value_ro	varchar	50	√		null
vw_export_pipe	material_vl_active	bool	1	√		null
vw_export_pipe	material_wall_thickness	numeric	4,1	√		null
vw_export_pipe	node_a__geometry_alt1_used	bool	1	√		null
vw_export_pipe	node_a__geometry_alt2_used	bool	1	√		null
vw_export_pipe	node_a__pipe_node_type	pipe_connection	2147483647	√		null
vw_export_pipe	node_a__pipe_orientation	float8	17,17	√		null
vw_export_pipe	node_a__pipe_schema_visible	bool	1	√		null
vw_export_pipe	node_a__printmaps	text	2147483647	√		null
vw_export_pipe	node_a_fk_district	int4	10	√		null
vw_export_pipe	node_a_fk_pressurezone	int4	10	√		null
vw_export_pipe	node_a_fk_printmap	_int4	10	√		null
vw_export_pipe	node_a_update_geometry_alt1	bool	1	√		null
vw_export_pipe	node_a_update_geometry_alt2	bool	1	√		null
vw_export_pipe	node_b__geometry_alt1_used	bool	1	√		null
vw_export_pipe	node_b__geometry_alt2_used	bool	1	√		null
vw_export_pipe	node_b__pipe_node_type	pipe_connection	2147483647	√		null
vw_export_pipe	node_b__pipe_orientation	float8	17,17	√		null
vw_export_pipe	node_b__pipe_schema_visible	bool	1	√		null
vw_export_pipe	node_b__printmaps	text	2147483647	√		null
vw_export_pipe	node_b_fk_district	int4	10	√		null
vw_export_pipe	node_b_fk_pressurezone	int4	10	√		null
vw_export_pipe	node_b_fk_printmap	_int4	10	√		null
vw_export_pipe	node_b_update_geometry_alt1	bool	1	√		null
vw_export_pipe	node_b_update_geometry_alt2	bool	1	√		null
vw_export_pipe	precision_code_sire	int2	5	√		null
vw_export_pipe	precision_description_en	text	2147483647	√		null
vw_export_pipe	precision_description_fr	text	2147483647	√		null
vw_export_pipe	precision_description_ro	text	2147483647	√		null
vw_export_pipe	precision_short_en	varchar	10	√		null
vw_export_pipe	precision_short_fr	varchar	10	√		null
vw_export_pipe	precision_short_ro	varchar	10	√		null
vw_export_pipe	precision_value_en	varchar	50	√		null
vw_export_pipe	precision_value_fr	varchar	50	√		null
vw_export_pipe	precision_value_ro	varchar	50	√		null
vw_export_pipe	precision_vl_active	bool	1	√		null
vw_export_pipe	pressure_nominal	int2	5	√		null
vw_export_pipe	pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_pipe	pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_pipe	pressurezone_colorcode	int2	5	√		null
vw_export_pipe	pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_pipe	pressurezone_fk_distributor	int4	10	√		null
vw_export_pipe	pressurezone_name	varchar	50	√		null
vw_export_pipe	pressurezone_population	int4	10	√		null
vw_export_pipe	pressurezone_subscriber	int4	10	√		null
vw_export_pipe	pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_pipe	pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_pipe	protection_description_en	text	2147483647	√		null
vw_export_pipe	protection_description_fr	text	2147483647	√		null
vw_export_pipe	protection_description_ro	text	2147483647	√		null
vw_export_pipe	protection_short_en	varchar	10	√		null
vw_export_pipe	protection_short_fr	varchar	10	√		null
vw_export_pipe	protection_short_ro	varchar	10	√		null
vw_export_pipe	protection_value_en	varchar	50	√		null
vw_export_pipe	protection_value_fr	varchar	50	√		null
vw_export_pipe	protection_value_ro	varchar	50	√		null
vw_export_pipe	protection_vl_active	bool	1	√		null
vw_export_pipe	remark	text	2147483647	√		null
vw_export_pipe	schema_force_visible	bool	1	√		null
vw_export_pipe	status_active	bool	1	√		null
vw_export_pipe	status_code_sire	int2	5	√		null
vw_export_pipe	status_description_en	text	2147483647	√		null
vw_export_pipe	status_description_fr	text	2147483647	√		null
vw_export_pipe	status_description_ro	text	2147483647	√		null
vw_export_pipe	status_functional	bool	1	√		null
vw_export_pipe	status_short_en	varchar	10	√		null
vw_export_pipe	status_short_fr	varchar	10	√		null
vw_export_pipe	status_short_ro	varchar	10	√		null
vw_export_pipe	status_value_en	varchar	50	√		null
vw_export_pipe	status_value_fr	varchar	50	√		null
vw_export_pipe	status_value_ro	varchar	50	√		null
vw_export_pipe	status_vl_active	bool	1	√		null
vw_export_pipe	tunnel_or_bridge	bool	1	√		null
vw_export_pipe	update_geometry_alt1	bool	1	√		null
vw_export_pipe	update_geometry_alt2	bool	1	√		null
vw_export_pipe	year	int2	5	√		null
vw_export_pipe	year_end	int2	5	√		null
vw_export_pipe	year_rehabilitation	int2	5	√		null
vw_export_subscriber	_geometry_alt1_used	bool	1	√		null
vw_export_subscriber	_geometry_alt2_used	bool	1	√		null
vw_export_subscriber	_pipe_node_type	pipe_connection	2147483647	√		null
vw_export_subscriber	_pipe_orientation	float8	17,17	√		null
vw_export_subscriber	_pipe_schema_visible	bool	1	√		null
vw_export_subscriber	_printmaps	text	2147483647	√		null
vw_export_subscriber	altitude	numeric	10,3	√		null
vw_export_subscriber	distributor_name	varchar	30	√		null
vw_export_subscriber	district_colorcode	int2	5	√		null
vw_export_subscriber	district_land_registry	varchar	12	√		null
vw_export_subscriber	district_name	varchar	40	√		null
vw_export_subscriber	district_prefix	varchar	12	√		null
vw_export_subscriber	district_shortname	varchar	12	√		null
vw_export_subscriber	district_zip	varchar	12	√		null
vw_export_subscriber	fk_distributor	int4	10	√		null
vw_export_subscriber	fk_district	int4	10	√		null
vw_export_subscriber	fk_folder	int4	10	√		null
vw_export_subscriber	fk_locationtype	_int4	10	√		null
vw_export_subscriber	fk_object_reference	int4	10	√		null
vw_export_subscriber	fk_pipe	int4	10	√		null
vw_export_subscriber	fk_precision	int4	10	√		null
vw_export_subscriber	fk_precisionalti	int4	10	√		null
vw_export_subscriber	fk_pressurezone	int4	10	√		null
vw_export_subscriber	fk_printmap	_int4	10	√		null
vw_export_subscriber	fk_status	int4	10	√		null
vw_export_subscriber	fk_subscriber_type	int4	10	√		null
vw_export_subscriber	flow_current	numeric	8,2	√		null
vw_export_subscriber	flow_planned	numeric	8,2	√		null
vw_export_subscriber	folder_date_end	date	13	√		null
vw_export_subscriber	folder_date_start	date	13	√		null
vw_export_subscriber	folder_description	text	2147483647	√		null
vw_export_subscriber	folder_identification	varchar	50	√		null
vw_export_subscriber	geometry	geometry	2147483647	√		null
vw_export_subscriber	geometry_alt1	geometry	2147483647	√		null
vw_export_subscriber	geometry_alt2	geometry	2147483647	√		null
vw_export_subscriber	id	int4	10	√		null
vw_export_subscriber	identification	varchar	50	√		null
vw_export_subscriber	label_1_rotation	float8	17,17	√		null
vw_export_subscriber	label_1_text	varchar	120	√		null
vw_export_subscriber	label_1_visible	int2	5	√		null
vw_export_subscriber	label_1_x	float8	17,17	√		null
vw_export_subscriber	label_1_y	float8	17,17	√		null
vw_export_subscriber	label_2_rotation	float8	17,17	√		null
vw_export_subscriber	label_2_text	varchar	120	√		null
vw_export_subscriber	label_2_visible	int2	5	√		null
vw_export_subscriber	label_2_x	float8	17,17	√		null
vw_export_subscriber	label_2_y	float8	17,17	√		null
vw_export_subscriber	object_reference_description_en	text	2147483647	√		null
vw_export_subscriber	object_reference_description_fr	text	2147483647	√		null
vw_export_subscriber	object_reference_description_ro	text	2147483647	√		null
vw_export_subscriber	object_reference_short_en	varchar	10	√		null
vw_export_subscriber	object_reference_short_fr	varchar	10	√		null
vw_export_subscriber	object_reference_short_ro	varchar	10	√		null
vw_export_subscriber	object_reference_value_en	varchar	50	√		null
vw_export_subscriber	object_reference_value_fr	varchar	50	√		null
vw_export_subscriber	object_reference_value_ro	varchar	50	√		null
vw_export_subscriber	object_reference_vl_active	bool	1	√		null
vw_export_subscriber	orientation	float8	17,17	√		null
vw_export_subscriber	parcel	varchar	12	√		null
vw_export_subscriber	precision_code_sire	int2	5	√		null
vw_export_subscriber	precision_description_en	text	2147483647	√		null
vw_export_subscriber	precision_description_fr	text	2147483647	√		null
vw_export_subscriber	precision_description_ro	text	2147483647	√		null
vw_export_subscriber	precision_short_en	varchar	10	√		null
vw_export_subscriber	precision_short_fr	varchar	10	√		null
vw_export_subscriber	precision_short_ro	varchar	10	√		null
vw_export_subscriber	precision_value_en	varchar	50	√		null
vw_export_subscriber	precision_value_fr	varchar	50	√		null
vw_export_subscriber	precision_value_ro	varchar	50	√		null
vw_export_subscriber	precision_vl_active	bool	1	√		null
vw_export_subscriber	precisionalti_code_sire	int2	5	√		null
vw_export_subscriber	precisionalti_description_en	text	2147483647	√		null
vw_export_subscriber	precisionalti_description_fr	text	2147483647	√		null
vw_export_subscriber	precisionalti_description_ro	text	2147483647	√		null
vw_export_subscriber	precisionalti_short_en	varchar	10	√		null
vw_export_subscriber	precisionalti_short_fr	varchar	10	√		null
vw_export_subscriber	precisionalti_short_ro	varchar	10	√		null
vw_export_subscriber	precisionalti_value_en	varchar	50	√		null
vw_export_subscriber	precisionalti_value_fr	varchar	50	√		null
vw_export_subscriber	precisionalti_value_ro	varchar	50	√		null
vw_export_subscriber	precisionalti_vl_active	bool	1	√		null
vw_export_subscriber	pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_subscriber	pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_subscriber	pressurezone_colorcode	int2	5	√		null
vw_export_subscriber	pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_subscriber	pressurezone_fk_distributor	int4	10	√		null
vw_export_subscriber	pressurezone_name	varchar	50	√		null
vw_export_subscriber	pressurezone_population	int4	10	√		null
vw_export_subscriber	pressurezone_subscriber	int4	10	√		null
vw_export_subscriber	pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_subscriber	pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_subscriber	remark	text	2147483647	√		null
vw_export_subscriber	schema_force_visible	bool	1	√		null
vw_export_subscriber	status_active	bool	1	√		null
vw_export_subscriber	status_code_sire	int2	5	√		null
vw_export_subscriber	status_description_en	text	2147483647	√		null
vw_export_subscriber	status_description_fr	text	2147483647	√		null
vw_export_subscriber	status_description_ro	text	2147483647	√		null
vw_export_subscriber	status_functional	bool	1	√		null
vw_export_subscriber	status_short_en	varchar	10	√		null
vw_export_subscriber	status_short_fr	varchar	10	√		null
vw_export_subscriber	status_short_ro	varchar	10	√		null
vw_export_subscriber	status_value_en	varchar	50	√		null
vw_export_subscriber	status_value_fr	varchar	50	√		null
vw_export_subscriber	status_value_ro	varchar	50	√		null
vw_export_subscriber	status_vl_active	bool	1	√		null
vw_export_subscriber	subscriber_type_description_en	text	2147483647	√		null
vw_export_subscriber	subscriber_type_description_fr	text	2147483647	√		null
vw_export_subscriber	subscriber_type_description_ro	text	2147483647	√		null
vw_export_subscriber	subscriber_type_short_en	varchar	10	√		null
vw_export_subscriber	subscriber_type_short_fr	varchar	10	√		null
vw_export_subscriber	subscriber_type_short_ro	varchar	10	√		null
vw_export_subscriber	subscriber_type_value_en	varchar	50	√		null
vw_export_subscriber	subscriber_type_value_fr	varchar	50	√		null
vw_export_subscriber	subscriber_type_value_ro	varchar	50	√		null
vw_export_subscriber	subscriber_type_vl_active	bool	1	√		null
vw_export_subscriber	update_geometry_alt1	bool	1	√		null
vw_export_subscriber	update_geometry_alt2	bool	1	√		null
vw_export_subscriber	year	int2	5	√		null
vw_export_subscriber	year_end	int2	5	√		null
vw_export_valve	_geometry_alt1_used	bool	1	√		null
vw_export_valve	_geometry_alt2_used	bool	1	√		null
vw_export_valve	_pipe_node_type	pipe_connection	2147483647	√		null
vw_export_valve	_pipe_orientation	float8	17,17	√		null
vw_export_valve	_pipe_schema_visible	bool	1	√		null
vw_export_valve	_printmaps	text	2147483647	√		null
vw_export_valve	altitude	numeric	10,3	√		null
vw_export_valve	closed	bool	1	√		null
vw_export_valve	diameter_nominal	varchar	10	√		null
vw_export_valve	distributor_name	varchar	30	√		null
vw_export_valve	district_colorcode	int2	5	√		null
vw_export_valve	district_land_registry	varchar	12	√		null
vw_export_valve	district_name	varchar	40	√		null
vw_export_valve	district_prefix	varchar	12	√		null
vw_export_valve	district_shortname	varchar	12	√		null
vw_export_valve	district_zip	varchar	12	√		null
vw_export_valve	fk_distributor	int4	10	√		null
vw_export_valve	fk_district	int4	10	√		null
vw_export_valve	fk_folder	int4	10	√		null
vw_export_valve	fk_handle_precision	int4	10	√		null
vw_export_valve	fk_handle_precisionalti	int4	10	√		null
vw_export_valve	fk_locationtype	_int4	10	√		null
vw_export_valve	fk_maintenance	_int4	10	√		null
vw_export_valve	fk_object_reference	int4	10	√		null
vw_export_valve	fk_pipe	int4	10	√		null
vw_export_valve	fk_precision	int4	10	√		null
vw_export_valve	fk_precisionalti	int4	10	√		null
vw_export_valve	fk_pressurezone	int4	10	√		null
vw_export_valve	fk_printmap	_int4	10	√		null
vw_export_valve	fk_status	int4	10	√		null
vw_export_valve	fk_valve_actuation	int4	10	√		null
vw_export_valve	fk_valve_function	int4	10	√		null
vw_export_valve	fk_valve_type	int4	10	√		null
vw_export_valve	folder_date_end	date	13	√		null
vw_export_valve	folder_date_start	date	13	√		null
vw_export_valve	folder_description	text	2147483647	√		null
vw_export_valve	folder_identification	varchar	50	√		null
vw_export_valve	geometry	geometry	2147483647	√		null
vw_export_valve	geometry_alt1	geometry	2147483647	√		null
vw_export_valve	geometry_alt2	geometry	2147483647	√		null
vw_export_valve	handle_altitude	numeric	10,3	√		null
vw_export_valve	handle_geometry	geometry	2147483647	√		null
vw_export_valve	id	int4	10	√		null
vw_export_valve	identification	varchar	50	√		null
vw_export_valve	label_1_rotation	float8	17,17	√		null
vw_export_valve	label_1_text	varchar	120	√		null
vw_export_valve	label_1_visible	int2	5	√		null
vw_export_valve	label_1_x	float8	17,17	√		null
vw_export_valve	label_1_y	float8	17,17	√		null
vw_export_valve	label_2_rotation	float8	17,17	√		null
vw_export_valve	label_2_text	varchar	120	√		null
vw_export_valve	label_2_visible	int2	5	√		null
vw_export_valve	label_2_x	float8	17,17	√		null
vw_export_valve	label_2_y	float8	17,17	√		null
vw_export_valve	networkseparation	bool	1	√		null
vw_export_valve	object_reference_description_en	text	2147483647	√		null
vw_export_valve	object_reference_description_fr	text	2147483647	√		null
vw_export_valve	object_reference_description_ro	text	2147483647	√		null
vw_export_valve	object_reference_short_en	varchar	10	√		null
vw_export_valve	object_reference_short_fr	varchar	10	√		null
vw_export_valve	object_reference_short_ro	varchar	10	√		null
vw_export_valve	object_reference_value_en	varchar	50	√		null
vw_export_valve	object_reference_value_fr	varchar	50	√		null
vw_export_valve	object_reference_value_ro	varchar	50	√		null
vw_export_valve	object_reference_vl_active	bool	1	√		null
vw_export_valve	orientation	float8	17,17	√		null
vw_export_valve	precision_code_sire	int2	5	√		null
vw_export_valve	precision_description_en	text	2147483647	√		null
vw_export_valve	precision_description_fr	text	2147483647	√		null
vw_export_valve	precision_description_ro	text	2147483647	√		null
vw_export_valve	precision_short_en	varchar	10	√		null
vw_export_valve	precision_short_fr	varchar	10	√		null
vw_export_valve	precision_short_ro	varchar	10	√		null
vw_export_valve	precision_value_en	varchar	50	√		null
vw_export_valve	precision_value_fr	varchar	50	√		null
vw_export_valve	precision_value_ro	varchar	50	√		null
vw_export_valve	precision_vl_active	bool	1	√		null
vw_export_valve	precisionalti_code_sire	int2	5	√		null
vw_export_valve	precisionalti_description_en	text	2147483647	√		null
vw_export_valve	precisionalti_description_fr	text	2147483647	√		null
vw_export_valve	precisionalti_description_ro	text	2147483647	√		null
vw_export_valve	precisionalti_short_en	varchar	10	√		null
vw_export_valve	precisionalti_short_fr	varchar	10	√		null
vw_export_valve	precisionalti_short_ro	varchar	10	√		null
vw_export_valve	precisionalti_value_en	varchar	50	√		null
vw_export_valve	precisionalti_value_fr	varchar	50	√		null
vw_export_valve	precisionalti_value_ro	varchar	50	√		null
vw_export_valve	precisionalti_vl_active	bool	1	√		null
vw_export_valve	pressurezone__geometry_alt1_used	bool	1	√		null
vw_export_valve	pressurezone__geometry_alt2_used	bool	1	√		null
vw_export_valve	pressurezone_colorcode	int2	5	√		null
vw_export_valve	pressurezone_fk_consumptionzone	int4	10	√		null
vw_export_valve	pressurezone_fk_distributor	int4	10	√		null
vw_export_valve	pressurezone_name	varchar	50	√		null
vw_export_valve	pressurezone_population	int4	10	√		null
vw_export_valve	pressurezone_subscriber	int4	10	√		null
vw_export_valve	pressurezone_update_geometry_alt1	bool	1	√		null
vw_export_valve	pressurezone_update_geometry_alt2	bool	1	√		null
vw_export_valve	remark	text	2147483647	√		null
vw_export_valve	schema_force_visible	bool	1	√		null
vw_export_valve	status_active	bool	1	√		null
vw_export_valve	status_code_sire	int2	5	√		null
vw_export_valve	status_description_en	text	2147483647	√		null
vw_export_valve	status_description_fr	text	2147483647	√		null
vw_export_valve	status_description_ro	text	2147483647	√		null
vw_export_valve	status_functional	bool	1	√		null
vw_export_valve	status_short_en	varchar	10	√		null
vw_export_valve	status_short_fr	varchar	10	√		null
vw_export_valve	status_short_ro	varchar	10	√		null
vw_export_valve	status_value_en	varchar	50	√		null
vw_export_valve	status_value_fr	varchar	50	√		null
vw_export_valve	status_value_ro	varchar	50	√		null
vw_export_valve	status_vl_active	bool	1	√		null
vw_export_valve	update_geometry_alt1	bool	1	√		null
vw_export_valve	update_geometry_alt2	bool	1	√		null
vw_export_valve	valve_actuation_description_en	text	2147483647	√		null
vw_export_valve	valve_actuation_description_fr	text	2147483647	√		null
vw_export_valve	valve_actuation_description_ro	text	2147483647	√		null
vw_export_valve	valve_actuation_schema_visible	bool	1	√		null
vw_export_valve	valve_actuation_short_en	varchar	10	√		null
vw_export_valve	valve_actuation_short_fr	varchar	10	√		null
vw_export_valve	valve_actuation_short_ro	varchar	10	√		null
vw_export_valve	valve_actuation_value_en	varchar	50	√		null
vw_export_valve	valve_actuation_value_fr	varchar	50	√		null
vw_export_valve	valve_actuation_value_ro	varchar	50	√		null
vw_export_valve	valve_actuation_vl_active	bool	1	√		null
vw_export_valve	valve_function_description_en	text	2147483647	√		null
vw_export_valve	valve_function_description_fr	text	2147483647	√		null
vw_export_valve	valve_function_description_ro	text	2147483647	√		null
vw_export_valve	valve_function_schema_visible	bool	1	√		null
vw_export_valve	valve_function_short_en	varchar	10	√		null
vw_export_valve	valve_function_short_fr	varchar	10	√		null
vw_export_valve	valve_function_short_ro	varchar	10	√		null
vw_export_valve	valve_function_value_en	varchar	50	√		null
vw_export_valve	valve_function_value_fr	varchar	50	√		null
vw_export_valve	valve_function_value_ro	varchar	50	√		null
vw_export_valve	valve_function_vl_active	bool	1	√		null
vw_export_valve	valve_type_description_en	text	2147483647	√		null
vw_export_valve	valve_type_description_fr	text	2147483647	√		null
vw_export_valve	valve_type_description_ro	text	2147483647	√		null
vw_export_valve	valve_type_short_en	varchar	10	√		null
vw_export_valve	valve_type_short_fr	varchar	10	√		null
vw_export_valve	valve_type_short_ro	varchar	10	√		null
vw_export_valve	valve_type_value_en	varchar	50	√		null
vw_export_valve	valve_type_value_fr	varchar	50	√		null
vw_export_valve	valve_type_value_ro	varchar	50	√		null
vw_export_valve	valve_type_vl_active	bool	1	√		null
vw_export_valve	year	int2	5	√		null
vw_export_valve	year_end	int2	5	√		null
vw_installation_chamber	depth	numeric	10,3	√		null
vw_installation_chamber	eca	varchar	30	√		null
vw_installation_chamber	fk_parent	int4	10	√		null
vw_installation_chamber	fk_remote	int4	10	√		null
vw_installation_chamber	fk_watertype	int4	10	√		null
vw_installation_chamber	flow_meter	bool	1	√		null
vw_installation_chamber	geometry_polygon	geometry	2147483647	√		null
vw_installation_chamber	id	int4	10	√		null
vw_installation_chamber	manometer	bool	1	√		null
vw_installation_chamber	name	varchar	60	√		null
vw_installation_chamber	networkseparation	bool	1	√		null
vw_installation_chamber	no_valves	int2	5	√		null
vw_installation_chamber	open_water_surface	bool	1	√		null
vw_installation_chamber	parcel	varchar	30	√		null
vw_installation_chamber	water_meter	bool	1	√		null
vw_installation_pressurecontrol	eca	varchar	30	√		null
vw_installation_pressurecontrol	fk_parent	int4	10	√		null
vw_installation_pressurecontrol	fk_pressurecontrol_type	int4	10	√		null
vw_installation_pressurecontrol	fk_remote	int4	10	√		null
vw_installation_pressurecontrol	fk_watertype	int4	10	√		null
vw_installation_pressurecontrol	geometry_polygon	geometry	2147483647	√		null
vw_installation_pressurecontrol	id	int4	10	√		null
vw_installation_pressurecontrol	name	varchar	60	√		null
vw_installation_pressurecontrol	open_water_surface	bool	1	√		null
vw_installation_pressurecontrol	parcel	varchar	30	√		null
vw_installation_pump	eca	varchar	30	√		null
vw_installation_pump	fk_parent	int4	10	√		null
vw_installation_pump	fk_pipe_in	int4	10	√		null
vw_installation_pump	fk_pipe_out	int4	10	√		null
vw_installation_pump	fk_pump_operating	int2	5	√		null
vw_installation_pump	fk_pump_type	int2	5	√		null
vw_installation_pump	fk_remote	int4	10	√		null
vw_installation_pump	fk_watertype	int4	10	√		null
vw_installation_pump	geometry_polygon	geometry	2147483647	√		null
vw_installation_pump	id	int4	10	√		null
vw_installation_pump	manometric_height	numeric	10,2	√		null
vw_installation_pump	name	varchar	60	√		null
vw_installation_pump	no_pumps	int2	5	√		null
vw_installation_pump	open_water_surface	bool	1	√		null
vw_installation_pump	parcel	varchar	30	√		null
vw_installation_pump	rejected_flow	numeric	10,2	√		null
vw_installation_source	contract_end	date	13	√		null
vw_installation_source	eca	varchar	30	√		null
vw_installation_source	fk_parent	int4	10	√		null
vw_installation_source	fk_remote	int4	10	√		null
vw_installation_source	fk_source_quality	int2	5	√		null
vw_installation_source	fk_source_type	int2	5	√		null
vw_installation_source	fk_watertype	int4	10	√		null
vw_installation_source	flow_average	numeric	10,3	√		null
vw_installation_source	flow_concession	numeric	10,2	√		null
vw_installation_source	flow_lowest	numeric	10,3	√		null
vw_installation_source	gathering_chamber	bool	1	√		null
vw_installation_source	geometry_polygon	geometry	2147483647	√		null
vw_installation_source	id	int4	10	√		null
vw_installation_source	name	varchar	60	√		null
vw_installation_source	open_water_surface	bool	1	√		null
vw_installation_source	parcel	varchar	30	√		null
vw_installation_tank	_cistern1_litrepercm	numeric	9,3	√		null
vw_installation_tank	_cistern2_litrepercm	numeric	9,3	√		null
vw_installation_tank	_litrepercm	numeric	9,3	√		null
vw_installation_tank	altitude_apron	numeric	7,3	√		null
vw_installation_tank	altitude_overflow	numeric	7,3	√		null
vw_installation_tank	cistern1_dimension_1	numeric	10,2	√		null
vw_installation_tank	cistern1_dimension_2	numeric	10,2	√		null
vw_installation_tank	cistern1_fk_type	int4	10	√		null
vw_installation_tank	cistern1_storage	numeric	10,2	√		null
vw_installation_tank	cistern2_dimension_1	numeric	10,2	√		null
vw_installation_tank	cistern2_dimension_2	numeric	10,2	√		null
vw_installation_tank	cistern2_fk_type	int4	10	√		null
vw_installation_tank	cistern2_storage	numeric	10,2	√		null
vw_installation_tank	eca	varchar	30	√		null
vw_installation_tank	fire_remote	bool	1	√		null
vw_installation_tank	fire_valve	bool	1	√		null
vw_installation_tank	fk_overflow	int4	10	√		null
vw_installation_tank	fk_parent	int4	10	√		null
vw_installation_tank	fk_remote	int4	10	√		null
vw_installation_tank	fk_tank_firestorage	int4	10	√		null
vw_installation_tank	fk_watertype	int4	10	√		null
vw_installation_tank	geometry_polygon	geometry	2147483647	√		null
vw_installation_tank	height_max	numeric	7,3	√		null
vw_installation_tank	id	int4	10	√		null
vw_installation_tank	name	varchar	60	√		null
vw_installation_tank	open_water_surface	bool	1	√		null
vw_installation_tank	parcel	varchar	30	√		null
vw_installation_tank	storage_fire	numeric	10,1	√		null
vw_installation_tank	storage_supply	numeric	10,1	√		null
vw_installation_tank	storage_total	numeric	10,1	√		null
vw_installation_treatment	activatedcharcoal	bool	1	√		null
vw_installation_treatment	eca	varchar	30	√		null
vw_installation_treatment	filtration_membrane	bool	1	√		null
vw_installation_treatment	filtration_sandorgravel	bool	1	√		null
vw_installation_treatment	fk_parent	int4	10	√		null
vw_installation_treatment	fk_remote	int4	10	√		null
vw_installation_treatment	fk_watertype	int4	10	√		null
vw_installation_treatment	flocculation	bool	1	√		null
vw_installation_treatment	geometry_polygon	geometry	2147483647	√		null
vw_installation_treatment	id	int4	10	√		null
vw_installation_treatment	name	varchar	60	√		null
vw_installation_treatment	open_water_surface	bool	1	√		null
vw_installation_treatment	parcel	varchar	30	√		null
vw_installation_treatment	sanitization_chlorine_gazeous	bool	1	√		null
vw_installation_treatment	sanitization_chlorine_liquid	bool	1	√		null
vw_installation_treatment	sanitization_ozone	bool	1	√		null
vw_installation_treatment	sanitization_uv	bool	1	√		null
vw_installation_treatment	settling	bool	1	√		null
vw_installation_treatment	treatment_capacity	numeric	10,2	√		null
vw_node_element	_geometry_alt1_used	bool	1	√		null
vw_node_element	_geometry_alt2_used	bool	1	√		null
vw_node_element	_pipe_node_type	pipe_connection	2147483647	√		null
vw_node_element	_pipe_orientation	float8	17,17	√		null
vw_node_element	_pipe_schema_visible	bool	1	√		null
vw_node_element	_printmaps	text	2147483647	√		null
vw_node_element	altitude	numeric	10,3	√		null
vw_node_element	fk_distributor	int4	10	√		null
vw_node_element	fk_district	int4	10	√		null
vw_node_element	fk_folder	int4	10	√		null
vw_node_element	fk_locationtype	_int4	10	√		null
vw_node_element	fk_object_reference	int4	10	√		null
vw_node_element	fk_precision	int4	10	√		null
vw_node_element	fk_precisionalti	int4	10	√		null
vw_node_element	fk_pressurezone	int4	10	√		null
vw_node_element	fk_printmap	_int4	10	√		null
vw_node_element	fk_status	int4	10	√		null
vw_node_element	geometry	geometry	2147483647	√		null
vw_node_element	geometry_alt1	geometry	2147483647	√		null
vw_node_element	geometry_alt2	geometry	2147483647	√		null
vw_node_element	id	int4	10	√		null
vw_node_element	identification	varchar	50	√		null
vw_node_element	label_1_rotation	float8	17,17	√		null
vw_node_element	label_1_text	varchar	120	√		null
vw_node_element	label_1_visible	int2	5	√		null
vw_node_element	label_1_x	float8	17,17	√		null
vw_node_element	label_1_y	float8	17,17	√		null
vw_node_element	label_2_rotation	float8	17,17	√		null
vw_node_element	label_2_text	varchar	120	√		null
vw_node_element	label_2_visible	int2	5	√		null
vw_node_element	label_2_x	float8	17,17	√		null
vw_node_element	label_2_y	float8	17,17	√		null
vw_node_element	orientation	float8	17,17	√		null
vw_node_element	remark	text	2147483647	√		null
vw_node_element	schema_force_visible	bool	1	√		null
vw_node_element	update_geometry_alt1	bool	1	√		null
vw_node_element	update_geometry_alt2	bool	1	√		null
vw_node_element	year	int2	5	√		null
vw_node_element	year_end	int2	5	√		null
vw_pipe_child_parent	child	int4	10	√		null
vw_pipe_child_parent	geometry	geometry	2147483647	√		null
vw_pipe_child_parent	parent	int4	10	√		null
vw_pipe_schema	_length2d	numeric	131089	√		null
vw_pipe_schema	_length3d	numeric	131089	√		null
vw_pipe_schema	_pressurezone	varchar	50	√		null
vw_pipe_schema	_pressurezone_colorcode	int2	5	√		null
vw_pipe_schema	_printmaps	varchar	100	√		null
vw_pipe_schema	_valve_closed	bool	1	√		null
vw_pipe_schema	_valve_count	int8	19	√		null
vw_pipe_schema	fk_distributor	int4	10	√		null
vw_pipe_schema	fk_district	int4	10	√		null
vw_pipe_schema	fk_folder	int4	10	√		null
vw_pipe_schema	fk_function	int4	10	√		null
vw_pipe_schema	fk_installmethod	int4	10	√		null
vw_pipe_schema	fk_material	int4	10	√		null
vw_pipe_schema	fk_precision	int4	10	√		null
vw_pipe_schema	fk_pressurezone	int4	10	√		null
vw_pipe_schema	fk_printmap	_int4	10	√		null
vw_pipe_schema	fk_protection	int4	10	√		null
vw_pipe_schema	fk_status	int4	10	√		null
vw_pipe_schema	geometry	geometry	2147483647	√		null
vw_pipe_schema	id	int4	10	√		null
vw_pipe_schema	label_2_text	varchar	120	√		null
vw_pipe_schema	label_2_visible	int2	5	√		null
vw_pipe_schema	number_of_pipe	int8	19	√		null
vw_pipe_schema	pressure_nominal	int2	5	√		null
vw_pipe_schema	remark	text	2147483647	√		null
vw_pipe_schema	tunnel_or_bridge	bool	1	√		null
vw_pipe_schema	year	int2	5	√		null
vw_pipe_schema	year_end	int2	5	√		null
vw_pipe_schema_error	error_desc	varchar	2147483647	√		null
vw_pipe_schema_error	geometry	geometry	2147483647	√		null
vw_pipe_schema_error	groupid	int4	10	√		null
vw_pipe_schema_merged	_length2d	numeric	131089	√		null
vw_pipe_schema_merged	_length3d	numeric	131089	√		null
vw_pipe_schema_merged	_valve_closed	bool	1	√		null
vw_pipe_schema_merged	_valve_count	int8	19	√		null
vw_pipe_schema_merged	geometry	geometry	2147483647	√		null
vw_pipe_schema_merged	id	int4	10	√		null
vw_pipe_schema_merged	number_of_pipe	int8	19	√		null
vw_pipe_schema_merged	tunnel_or_bridge	bool	1	√		null
vw_pipe_schema_visibleitems	_length2d	numeric	8,2	√		null
vw_pipe_schema_visibleitems	_length3d	numeric	8,2	√		null
vw_pipe_schema_visibleitems	_valve_closed	bool	1	√		null
vw_pipe_schema_visibleitems	_valve_count	int2	5	√		null
vw_pipe_schema_visibleitems	fk_material	int4	10	√		null
vw_pipe_schema_visibleitems	fk_parent	int4	10	√		null
vw_pipe_schema_visibleitems	geometry	geometry	2147483647	√		null
vw_pipe_schema_visibleitems	id	int4	10	√		null
vw_pipe_schema_visibleitems	schema_force_visible	bool	1	√		null
vw_pipe_schema_visibleitems	tunnel_or_bridge	bool	1	√		null
vw_printmap	_district	varchar	40	√		null
vw_printmap	_district_short	varchar	12	√		null
vw_printmap	_longname	text	2147483647	√		null
vw_printmap	fk_district	int2	5	√		null
vw_printmap	geometry	geometry	2147483647	√		null
vw_printmap	id	int4	10	√		null
vw_printmap	label_1_rotation	float8	17,17	√		null
vw_printmap	label_1_text	varchar	120	√		null
vw_printmap	label_1_visible	int2	5	√		null
vw_printmap	label_1_x	float8	17,17	√		null
vw_printmap	label_1_y	float8	17,17	√		null
vw_printmap	label_2_rotation	float8	17,17	√		null
vw_printmap	label_2_text	varchar	120	√		null
vw_printmap	label_2_visible	int2	5	√		null
vw_printmap	label_2_x	float8	17,17	√		null
vw_printmap	label_2_y	float8	17,17	√		null
vw_printmap	name	varchar	20	√		null
vw_printmap	remark	text	2147483647	√		null
vw_printmap	version_date	date	13	√		null
vw_printmap	x_max	float8	17,17	√		null
vw_printmap	x_min	float8	17,17	√		null
vw_printmap	y_max	float8	17,17	√		null
vw_printmap	y_min	float8	17,17	√		null
vw_protectionzone	_type	varchar	10	√		null
vw_protectionzone	_type_long	varchar	50	√		null
vw_protectionzone	agent	varchar	40	√		null
vw_protectionzone	date	date	13	√		null
vw_protectionzone	fk_type	int4	10	√		null
vw_protectionzone	geometry	geometry	2147483647	√		null
vw_protectionzone	id	int4	10	√		null
vw_protectionzone	name	varchar	40	√		null
vw_protectionzone	validated	bool	1	√		null
vw_qwat_installation	_cistern1_litrepercm	numeric	9,3	√		null
vw_qwat_installation	_cistern2_litrepercm	numeric	9,3	√		null
vw_qwat_installation	_litrepercm	numeric	9,3	√		null
vw_qwat_installation	activatedcharcoal	bool	1	√		null
vw_qwat_installation	altitude_apron	numeric	7,3	√		null
vw_qwat_installation	altitude_overflow	numeric	7,3	√		null
vw_qwat_installation	cistern1_dimension_1	numeric	10,2	√		null
vw_qwat_installation	cistern1_dimension_2	numeric	10,2	√		null
vw_qwat_installation	cistern1_fk_type	int4	10	√		null
vw_qwat_installation	cistern1_storage	numeric	10,2	√		null
vw_qwat_installation	cistern2_dimension_1	numeric	10,2	√		null
vw_qwat_installation	cistern2_dimension_2	numeric	10,2	√		null
vw_qwat_installation	cistern2_fk_type	int4	10	√		null
vw_qwat_installation	cistern2_storage	numeric	10,2	√		null
vw_qwat_installation	contract_end	date	13	√		null
vw_qwat_installation	depth	numeric	10,3	√		null
vw_qwat_installation	eca	varchar	30	√		null
vw_qwat_installation	filtration_membrane	bool	1	√		null
vw_qwat_installation	filtration_sandorgravel	bool	1	√		null
vw_qwat_installation	fire_remote	bool	1	√		null
vw_qwat_installation	fire_valve	bool	1	√		null
vw_qwat_installation	fk_overflow	int4	10	√		null
vw_qwat_installation	fk_parent	int4	10	√		null
vw_qwat_installation	fk_pipe_in	int4	10	√		null
vw_qwat_installation	fk_pipe_out	int4	10	√		null
vw_qwat_installation	fk_pressurecontrol_type	int4	10	√		null
vw_qwat_installation	fk_pump_operating	int2	5	√		null
vw_qwat_installation	fk_pump_type	int2	5	√		null
vw_qwat_installation	fk_remote	int4	10	√		null
vw_qwat_installation	fk_source_quality	int2	5	√		null
vw_qwat_installation	fk_source_type	int2	5	√		null
vw_qwat_installation	fk_tank_firestorage	int4	10	√		null
vw_qwat_installation	fk_watertype	int4	10	√		null
vw_qwat_installation	flocculation	bool	1	√		null
vw_qwat_installation	flow_average	numeric	10,3	√		null
vw_qwat_installation	flow_concession	numeric	10,2	√		null
vw_qwat_installation	flow_lowest	numeric	10,3	√		null
vw_qwat_installation	flow_meter	bool	1	√		null
vw_qwat_installation	gathering_chamber	bool	1	√		null
vw_qwat_installation	geometry_polygon	geometry	2147483647	√		null
vw_qwat_installation	height_max	numeric	7,3	√		null
vw_qwat_installation	id	int4	10	√		null
vw_qwat_installation	installation_type	installation_type	2147483647	√		null
vw_qwat_installation	manometer	bool	1	√		null
vw_qwat_installation	manometric_height	numeric	10,2	√		null
vw_qwat_installation	name	varchar	60	√		null
vw_qwat_installation	networkseparation	bool	1	√		null
vw_qwat_installation	no_pumps	int2	5	√		null
vw_qwat_installation	no_valves	int2	5	√		null
vw_qwat_installation	open_water_surface	bool	1	√		null
vw_qwat_installation	parcel	varchar	30	√		null
vw_qwat_installation	rejected_flow	numeric	10,2	√		null
vw_qwat_installation	sanitization_chlorine_gazeous	bool	1	√		null
vw_qwat_installation	sanitization_chlorine_liquid	bool	1	√		null
vw_qwat_installation	sanitization_ozone	bool	1	√		null
vw_qwat_installation	sanitization_uv	bool	1	√		null
vw_qwat_installation	settling	bool	1	√		null
vw_qwat_installation	storage_fire	numeric	10,1	√		null
vw_qwat_installation	storage_supply	numeric	10,1	√		null
vw_qwat_installation	storage_total	numeric	10,1	√		null
vw_qwat_installation	treatment_capacity	numeric	10,2	√		null
vw_qwat_installation	water_meter	bool	1	√		null
vw_qwat_network_element	_cistern1_litrepercm	numeric	9,3	√		null
vw_qwat_network_element	_cistern2_litrepercm	numeric	9,3	√		null
vw_qwat_network_element	_geometry_alt1_used	bool	1	√		null
vw_qwat_network_element	_geometry_alt2_used	bool	1	√		null
vw_qwat_network_element	_litrepercm	numeric	9,3	√		null
vw_qwat_network_element	_pipe_node_type	pipe_connection	2147483647	√		null
vw_qwat_network_element	_pipe_orientation	float8	17,17	√		null
vw_qwat_network_element	_pipe_schema_visible	bool	1	√		null
vw_qwat_network_element	_printmaps	text	2147483647	√		null
vw_qwat_network_element	activatedcharcoal	bool	1	√		null
vw_qwat_network_element	altitude	numeric	10,3	√		null
vw_qwat_network_element	altitude_apron	numeric	7,3	√		null
vw_qwat_network_element	altitude_overflow	numeric	7,3	√		null
vw_qwat_network_element	cistern1_dimension_1	numeric	10,2	√		null
vw_qwat_network_element	cistern1_dimension_2	numeric	10,2	√		null
vw_qwat_network_element	cistern1_fk_type	int4	10	√		null
vw_qwat_network_element	cistern1_storage	numeric	10,2	√		null
vw_qwat_network_element	cistern2_dimension_1	numeric	10,2	√		null
vw_qwat_network_element	cistern2_dimension_2	numeric	10,2	√		null
vw_qwat_network_element	cistern2_fk_type	int4	10	√		null
vw_qwat_network_element	cistern2_storage	numeric	10,2	√		null
vw_qwat_network_element	contract_end	date	13	√		null
vw_qwat_network_element	depth	numeric	10,3	√		null
vw_qwat_network_element	eca	varchar	30	√		null
vw_qwat_network_element	element_type	element_type	2147483647	√		null
vw_qwat_network_element	filtration_membrane	bool	1	√		null
vw_qwat_network_element	filtration_sandorgravel	bool	1	√		null
vw_qwat_network_element	fire_remote	bool	1	√		null
vw_qwat_network_element	fire_valve	bool	1	√		null
vw_qwat_network_element	fk_distributor	int4	10	√		null
vw_qwat_network_element	fk_district	int4	10	√		null
vw_qwat_network_element	fk_folder	int4	10	√		null
vw_qwat_network_element	fk_locationtype	_int4	10	√		null
vw_qwat_network_element	fk_material	int4	10	√		null
vw_qwat_network_element	fk_model_inf	int4	10	√		null
vw_qwat_network_element	fk_model_sup	int4	10	√		null
vw_qwat_network_element	fk_object_reference	int4	10	√		null
vw_qwat_network_element	fk_output	int4	10	√		null
vw_qwat_network_element	fk_overflow	int4	10	√		null
vw_qwat_network_element	fk_parent	int4	10	√		null
vw_qwat_network_element	fk_part_type	int4	10	√		null
vw_qwat_network_element	fk_pipe	int4	10	√		null
vw_qwat_network_element	fk_pipe_in	int4	10	√		null
vw_qwat_network_element	fk_pipe_out	int4	10	√		null
vw_qwat_network_element	fk_precision	int4	10	√		null
vw_qwat_network_element	fk_precisionalti	int4	10	√		null
vw_qwat_network_element	fk_pressurecontrol_type	int4	10	√		null
vw_qwat_network_element	fk_pressurezone	int4	10	√		null
vw_qwat_network_element	fk_printmap	_int4	10	√		null
vw_qwat_network_element	fk_provider	int4	10	√		null
vw_qwat_network_element	fk_pump_operating	int2	5	√		null
vw_qwat_network_element	fk_pump_type	int2	5	√		null
vw_qwat_network_element	fk_remote	int4	10	√		null
vw_qwat_network_element	fk_source_quality	int2	5	√		null
vw_qwat_network_element	fk_source_type	int2	5	√		null
vw_qwat_network_element	fk_status	int4	10	√		null
vw_qwat_network_element	fk_subscriber_type	int4	10	√		null
vw_qwat_network_element	fk_tank_firestorage	int4	10	√		null
vw_qwat_network_element	fk_watertype	int4	10	√		null
vw_qwat_network_element	flocculation	bool	1	√		null
vw_qwat_network_element	flow	numeric	8,2	√		null
vw_qwat_network_element	flow_average	numeric	10,3	√		null
vw_qwat_network_element	flow_concession	numeric	10,2	√		null
vw_qwat_network_element	flow_current	numeric	8,2	√		null
vw_qwat_network_element	flow_lowest	numeric	10,3	√		null
vw_qwat_network_element	flow_meter	bool	1	√		null
vw_qwat_network_element	flow_planned	numeric	8,2	√		null
vw_qwat_network_element	gathering_chamber	bool	1	√		null
vw_qwat_network_element	geometry	geometry	2147483647	√		null
vw_qwat_network_element	geometry_alt1	geometry	2147483647	√		null
vw_qwat_network_element	geometry_alt2	geometry	2147483647	√		null
vw_qwat_network_element	geometry_polygon	geometry	2147483647	√		null
vw_qwat_network_element	height_max	numeric	7,3	√		null
vw_qwat_network_element	id	int4	10	√		null
vw_qwat_network_element	identification	varchar	50	√		null
vw_qwat_network_element	installation_type	installation_type	2147483647	√		null
vw_qwat_network_element	label_1_rotation	float8	17,17	√		null
vw_qwat_network_element	label_1_text	varchar	120	√		null
vw_qwat_network_element	label_1_visible	int2	5	√		null
vw_qwat_network_element	label_1_x	float8	17,17	√		null
vw_qwat_network_element	label_1_y	float8	17,17	√		null
vw_qwat_network_element	label_2_rotation	float8	17,17	√		null
vw_qwat_network_element	label_2_text	varchar	120	√		null
vw_qwat_network_element	label_2_visible	int2	5	√		null
vw_qwat_network_element	label_2_x	float8	17,17	√		null
vw_qwat_network_element	label_2_y	float8	17,17	√		null
vw_qwat_network_element	manometer	bool	1	√		null
vw_qwat_network_element	manometric_height	numeric	10,2	√		null
vw_qwat_network_element	marked	bool	1	√		null
vw_qwat_network_element	name	varchar	60	√		null
vw_qwat_network_element	networkseparation	bool	1	√		null
vw_qwat_network_element	no_pumps	int2	5	√		null
vw_qwat_network_element	no_valves	int2	5	√		null
vw_qwat_network_element	observation_date	date	13	√		null
vw_qwat_network_element	observation_source	varchar	45	√		null
vw_qwat_network_element	open_water_surface	bool	1	√		null
vw_qwat_network_element	orientation	float8	17,17	√		null
vw_qwat_network_element	parcel	varchar	2147483647	√		null
vw_qwat_network_element	pressure_dynamic	numeric	5,2	√		null
vw_qwat_network_element	pressure_static	numeric	5,2	√		null
vw_qwat_network_element	rejected_flow	numeric	10,2	√		null
vw_qwat_network_element	remark	text	2147483647	√		null
vw_qwat_network_element	sanitization_chlorine_gazeous	bool	1	√		null
vw_qwat_network_element	sanitization_chlorine_liquid	bool	1	√		null
vw_qwat_network_element	sanitization_ozone	bool	1	√		null
vw_qwat_network_element	sanitization_uv	bool	1	√		null
vw_qwat_network_element	schema_force_visible	bool	1	√		null
vw_qwat_network_element	settling	bool	1	√		null
vw_qwat_network_element	storage_fire	numeric	10,1	√		null
vw_qwat_network_element	storage_supply	numeric	10,1	√		null
vw_qwat_network_element	storage_total	numeric	10,1	√		null
vw_qwat_network_element	treatment_capacity	numeric	10,2	√		null
vw_qwat_network_element	underground	bool	1	√		null
vw_qwat_network_element	update_geometry_alt1	bool	1	√		null
vw_qwat_network_element	update_geometry_alt2	bool	1	√		null
vw_qwat_network_element	water_meter	bool	1	√		null
vw_qwat_network_element	year	int2	5	√		null
vw_qwat_network_element	year_end	int2	5	√		null
vw_qwat_node	_geometry_alt1_used	bool	1	√		null
vw_qwat_node	_geometry_alt2_used	bool	1	√		null
vw_qwat_node	_pipe_node_type	pipe_connection	2147483647	√		null
vw_qwat_node	_pipe_orientation	float8	17,17	√		null
vw_qwat_node	_pipe_schema_visible	bool	1	√		null
vw_qwat_node	_printmaps	text	2147483647	√		null
vw_qwat_node	altitude	numeric	10,3	√		null
vw_qwat_node	fk_distributor	int4	10	√		null
vw_qwat_node	fk_district	int4	10	√		null
vw_qwat_node	fk_folder	int4	10	√		null
vw_qwat_node	fk_locationtype	_int4	10	√		null
vw_qwat_node	fk_object_reference	int4	10	√		null
vw_qwat_node	fk_precision	int4	10	√		null
vw_qwat_node	fk_precisionalti	int4	10	√		null
vw_qwat_node	fk_pressurezone	int4	10	√		null
vw_qwat_node	fk_printmap	_int4	10	√		null
vw_qwat_node	fk_status	int4	10	√		null
vw_qwat_node	geometry	geometry	2147483647	√		null
vw_qwat_node	geometry_alt1	geometry	2147483647	√		null
vw_qwat_node	geometry_alt2	geometry	2147483647	√		null
vw_qwat_node	id	int4	10	√		null
vw_qwat_node	identification	varchar	50	√		null
vw_qwat_node	label_1_rotation	float8	17,17	√		null
vw_qwat_node	label_1_text	varchar	120	√		null
vw_qwat_node	label_1_visible	int2	5	√		null
vw_qwat_node	label_1_x	float8	17,17	√		null
vw_qwat_node	label_1_y	float8	17,17	√		null
vw_qwat_node	label_2_rotation	float8	17,17	√		null
vw_qwat_node	label_2_text	varchar	120	√		null
vw_qwat_node	label_2_visible	int2	5	√		null
vw_qwat_node	label_2_x	float8	17,17	√		null
vw_qwat_node	label_2_y	float8	17,17	√		null
vw_qwat_node	node_type	node_type	2147483647	√		null
vw_qwat_node	orientation	float8	17,17	√		null
vw_qwat_node	remark	text	2147483647	√		null
vw_qwat_node	schema_force_visible	bool	1	√		null
vw_qwat_node	update_geometry_alt1	bool	1	√		null
vw_qwat_node	update_geometry_alt2	bool	1	√		null
vw_qwat_node	year	int2	5	√		null
vw_qwat_node	year_end	int2	5	√		null
vw_remote	destination	varchar	150	√		null
vw_remote	distributor	varchar	30	√		null
vw_remote	folder	varchar	50	√		null
vw_remote	geometry	geometry	2147483647	√		null
vw_remote	identification	varchar	15	√		null
vw_remote	label_1_rotation	float8	17,17	√		null
vw_remote	label_1_text	varchar	120	√		null
vw_remote	label_1_visible	int2	5	√		null
vw_remote	label_1_x	float8	17,17	√		null
vw_remote	label_1_y	float8	17,17	√		null
vw_remote	label_2_rotation	float8	17,17	√		null
vw_remote	label_2_text	varchar	120	√		null
vw_remote	label_2_visible	int2	5	√		null
vw_remote	label_2_x	float8	17,17	√		null
vw_remote	label_2_y	float8	17,17	√		null
vw_remote	material	varchar	30	√		null
vw_remote	origin	varchar	150	√		null
vw_remote	plan	varchar	50	√		null
vw_remote	precision	varchar	50	√		null
vw_remote	remark	text	2147483647	√		null
vw_remote	status	varchar	50	√		null
vw_remote	year	int2	5	√		null
vw_search_view	geometry	geometry	2147483647	√		null
vw_search_view	layer_name	text	2147483647	√		null
vw_search_view	search_text	text	2147483647	√		null
vw_subscriber_pipe_relation	geometry	geometry	2147483647	√		null
vw_subscriber_pipe_relation	id	int4	10	√		null
vw_subscriber_pipe_relation	identification	varchar	50	√		null
vw_valve_lines	geometry	geometry	2147483647	√		null
vw_valve_lines	id	int4	10	√		null
worker	date_end	date	13	√		null
worker	date_entry	date	13	√		null
worker	first_name	text	2147483647	√		null
worker	fk_type	_int4	10	√		null
worker	id	serial	10		√	nextval('qwat_od.worker_id_seq'::regclass)
worker	last_name	text	2147483647	√		null