SchemaSpy - View qwat.qwat_od.vw_element

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
id	int4	10	√	null
fk_district	int4	10	√	null
fk_pressurezone	int4	10	√	null
fk_printmap	_int4	10	√	null
_printmaps	text	2147483647	√	null
_geometry_alt1_used	bool	1	√	null
_geometry_alt2_used	bool	1	√	null
_pipe_node_type	pipe_connection	2147483647	√	null
_pipe_orientation	float8	17,17	√	null
_pipe_schema_visible	bool	1	√	null
geometry	geometry	2147483647	√	null
geometry_alt1	geometry	2147483647	√	null
geometry_alt2	geometry	2147483647	√	null
update_geometry_alt1	bool	1	√	null
update_geometry_alt2	bool	1	√	null
identification	varchar	50	√	null
fk_distributor	int4	10	√	null
fk_status	int4	10	√	null
fk_folder	int4	10	√	null
fk_locationtype	_int4	10	√	null
fk_precision	int4	10	√	null
fk_precisionalti	int4	10	√	null
fk_object_reference	int4	10	√	null
altitude	numeric	10,3	√	null
year	int2	5	√	null
year_end	int2	5	√	null
orientation	float8	17,17	√	null
remark	text	2147483647	√	null
schema_force_visible	bool	1	√	null
label_1_visible	int2	5	√	null
label_1_x	float8	17,17	√	null
label_1_y	float8	17,17	√	null
label_1_rotation	float8	17,17	√	null
label_1_text	varchar	120	√	null
label_2_visible	int2	5	√	null
label_2_x	float8	17,17	√	null
label_2_y	float8	17,17	√	null
label_2_rotation	float8	17,17	√	null
label_2_text	varchar	120	√	null
fk_provider	int4	10	√	null
fk_model_sup	int4	10	√	null
fk_model_inf	int4	10	√	null
fk_material	int4	10	√	null
fk_output	int4	10	√	null
underground	bool	1	√	null
marked	bool	1	√	null
pressure_static	numeric	5,2	√	null
pressure_dynamic	numeric	5,2	√	null
flow	numeric	8,2	√	null
observation_date	date	13	√	null
observation_source	varchar	45	√	null

Analyzed at mar. mars 21 17:52 CET 2017