Table qwat.qwat_od.protectionzone
protectionzones.

 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.protectionzone_id_seq'::regclass)
fk_type int4 10  √  null
protectionzone_type.id protectionzone_fk_type R
name varchar 40  √  null
validated bool 1  √  true
date date 13  √  null
agent varchar 40  √  null
geometry geometry 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc protectionzone_pk  
fk_type Performance Asc fki_protectionzone_fk_type  
geometry Performance Asc protectionzone_geoidx  
name Must be unique Asc protectionzone_name This unique column is also nullable

Close relationships: