Table qwat.qwat_od.folder
Technical folders.

 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.folder_id_seq'::regclass)
network_element.fk_folder element_fk_folder R
pipe.fk_folder pipe_fk_folder R
surveypoint.fk_folder surveypoint_fk_folder R
valve.fk_folder valve_fk_folder R
identification varchar 50
description text 2147483647  √  null
date_start date 13  √  null
date_end date 13  √  null
geometry_polygon geometry 2147483647  √  null
geometry_line geometry 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc folder_pkey
geometry_line Performance Asc folder_geoidx_line
geometry_polygon Performance Asc folder_geoidx_polygon
identification Must be unique Asc folder_identification

Close relationships  within of separation: