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