Table qwat.qwat_od.surveypoint
Table for sampling points. Inherits from surveypoint.

 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 int4 10
surveypoint.id surveypoint_id_fkey R
surveypoint.id surveypoint_id_fkey R
fk_survey_type int4 10
survey_type.id surveypoint_fk_type R
fk_worker int4 10  √  null
worker.id surveypoint_fk_worker R
code varchar 50  √  null
description text 2147483647  √  null
date date 13  √  null
fk_folder int4 10  √  null
folder.id surveypoint_fk_folder R
altitude numeric 10,3  √  NULL::numeric
geometry geometry 2147483647  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc surveypoint_pkey
fk_folder Performance Asc fki_surveypoint_fk_folder
fk_survey_type Performance Asc fki_surveypoint_fk_type
fk_worker Performance Asc fki_surveypoint_fk_worker

Close relationships  within of separation: