| SchemaSpy Analysis of qwat.public - Columns | Generated by SchemaSpy |
| Generated by SchemaSpy on mar. mars 21 17:52 CET 2017 |
| ||||||
|
| |||||||
qwat.public contains 45 columns - click on heading to sort:
| Table | Column | Type | Size | Nulls | Auto | Default | Comments |
|---|---|---|---|---|---|---|---|
| geography_columns | coord_dimension | int4 | 10 | √ | null | ||
| geography_columns | f_geography_column | name | 2147483647 | √ | null | ||
| geography_columns | f_table_catalog | name | 2147483647 | √ | null | ||
| geography_columns | f_table_name | name | 2147483647 | √ | null | ||
| geography_columns | f_table_schema | name | 2147483647 | √ | null | ||
| geography_columns | srid | int4 | 10 | √ | null | ||
| geography_columns | type | text | 2147483647 | √ | null | ||
| geometry_columns | coord_dimension | int4 | 10 | √ | null | ||
| geometry_columns | f_geometry_column | name | 2147483647 | √ | null | ||
| geometry_columns | f_table_catalog | varchar | 256 | √ | null | ||
| geometry_columns | f_table_name | name | 2147483647 | √ | null | ||
| geometry_columns | f_table_schema | name | 2147483647 | √ | null | ||
| geometry_columns | srid | int4 | 10 | √ | null | ||
| geometry_columns | type | varchar | 30 | √ | null | ||
| raster_columns | blocksize_x | int4 | 10 | √ | null | ||
| raster_columns | blocksize_y | int4 | 10 | √ | null | ||
| raster_columns | extent | geometry | 2147483647 | √ | null | ||
| raster_columns | nodata_values | _float8 | 17,17 | √ | null | ||
| raster_columns | num_bands | int4 | 10 | √ | null | ||
| raster_columns | out_db | _bool | 1 | √ | null | ||
| raster_columns | pixel_types | _text | 2147483647 | √ | null | ||
| raster_columns | r_raster_column | name | 2147483647 | √ | null | ||
| raster_columns | r_table_catalog | name | 2147483647 | √ | null | ||
| raster_columns | r_table_name | name | 2147483647 | √ | null | ||
| raster_columns | r_table_schema | name | 2147483647 | √ | null | ||
| raster_columns | regular_blocking | bool | 1 | √ | null | ||
| raster_columns | same_alignment | bool | 1 | √ | null | ||
| raster_columns | scale_x | float8 | 17,17 | √ | null | ||
| raster_columns | scale_y | float8 | 17,17 | √ | null | ||
| raster_columns | spatial_index | bool | 1 | √ | null | ||
| raster_columns | srid | int4 | 10 | √ | null | ||
| raster_overviews | o_raster_column | name | 2147483647 | √ | null | ||
| raster_overviews | o_table_catalog | name | 2147483647 | √ | null | ||
| raster_overviews | o_table_name | name | 2147483647 | √ | null | ||
| raster_overviews | o_table_schema | name | 2147483647 | √ | null | ||
| raster_overviews | overview_factor | int4 | 10 | √ | null | ||
| raster_overviews | r_raster_column | name | 2147483647 | √ | null | ||
| raster_overviews | r_table_catalog | name | 2147483647 | √ | null | ||
| raster_overviews | r_table_name | name | 2147483647 | √ | null | ||
| raster_overviews | r_table_schema | name | 2147483647 | √ | null | ||
| spatial_ref_sys | auth_name | varchar | 256 | √ | null | ||
| spatial_ref_sys | auth_srid | int4 | 10 | √ | null | ||
| spatial_ref_sys | proj4text | varchar | 2048 | √ | null | ||
| spatial_ref_sys | srid | int4 | 10 | ||||
| spatial_ref_sys | srtext | varchar | 2048 | √ | null |