SchemaSpy Analysis of qwat.qwat_dr - Columns Generated by
SchemaSpy
Generated by SchemaSpy on mar. mars 21 17:52 CET 2017
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

qwat.qwat_dr contains 31 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
annotationline annotation text 2147483647  √  null
annotationline geometry geometry 2147483647  √  null
annotationline id serial 10  √  nextval('qwat_dr.annotationline_id_seq'::regclass)
annotationline labelvisible bool 1 true
annotationline scale_1 bool 1  √  true
annotationline scale_2 bool 1  √  true
annotationline text_orientation numeric 7,2  √  null
annotationline text_size numeric 7,2  √  null
annotationpoint annotation text 2147483647  √  null
annotationpoint geometry geometry 2147483647  √  null
annotationpoint id serial 10  √  nextval('qwat_dr.annotationpoint_id_seq'::regclass)
annotationpoint scale_1 bool 1  √  true
annotationpoint scale_2 bool 1  √  true
annotationpoint text_orientation numeric 7,2  √  null
annotationpoint text_size numeric 7,2  √  null
constructionpoint altitude numeric 10,3  √  null
constructionpoint code varchar 15  √  null
constructionpoint fk_object_reference int4 10  √  null
constructionpoint geometry geometry 2147483647  √  null
constructionpoint id serial 10  √  nextval('qwat_dr.constructionpoint_id_seq'::regclass)
constructionpoint measurement_campaign varchar 200  √  null
constructionpoint remark text 2147483647  √  null
dimension_distance _calculation float8 17,17  √  null
dimension_distance geometry geometry 2147483647  √  null
dimension_distance id serial 10  √  nextval('qwat_dr.dimension_distance_id_seq'::regclass)
dimension_distance observation varchar 120  √  null
dimension_distance remark text 2147483647  √  null
dimension_orientation geometry geometry 2147483647  √  null
dimension_orientation id serial 10  √  nextval('qwat_dr.dimension_orientation_id_seq'::regclass)
dimension_orientation observation varchar 120  √  null
dimension_orientation remark text 2147483647  √  null