Table qwat.qwat_od.printmap
This table is used for polygons for predefined printable maps. shortname would be used as label string, and long_mame would be used in the print composer.

 Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id serial 10  √  nextval('qwat_od.printmap_id_seq'::regclass)
name varchar 20  √  null
fk_district int2 5  √  null
district.id printmap_fk_district R
remark text 2147483647  √  null
version_date date 13  √  null
x_min float8 17,17  √  null
y_min float8 17,17  √  null
x_max float8 17,17  √  null
y_max float8 17,17  √  null
geometry geometry 2147483647  √  null
label_1_visible int2 5  √  1
visible.vl_code_int printmap_label_1_visible R
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  √  1
visible.vl_code_int printmap_label_2_visible R
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

Table contained 3 rows at mar. mars 21 17:52 CET 2017

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc printmap_pkey
id Performance Asc fki_printmap_fk_district
label_1_visible Performance Asc fki_printmap_label_1_visible
label_2_visible Performance Asc fki_printmap_label_2_visible
geometry Performance Asc printmap_geoidx

Close relationships  within of separation: