| 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 |
|---|---|---|---|---|---|---|---|
| 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 |