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 |
---|---|---|---|---|---|---|---|
raster_columns | out_db | _bool | 1 | √ | null | ||
raster_columns | nodata_values | _float8 | 17,17 | √ | null | ||
raster_columns | pixel_types | _text | 2147483647 | √ | null | ||
raster_columns | regular_blocking | bool | 1 | √ | null | ||
raster_columns | same_alignment | bool | 1 | √ | null | ||
raster_columns | spatial_index | bool | 1 | √ | null | ||
raster_columns | scale_x | float8 | 17,17 | √ | null | ||
raster_columns | scale_y | float8 | 17,17 | √ | null | ||
raster_columns | extent | geometry | 2147483647 | √ | null | ||
spatial_ref_sys | auth_srid | int4 | 10 | √ | null | ||
raster_columns | blocksize_x | int4 | 10 | √ | null | ||
raster_columns | blocksize_y | int4 | 10 | √ | null | ||
geography_columns | coord_dimension | int4 | 10 | √ | null | ||
geometry_columns | coord_dimension | int4 | 10 | √ | null | ||
raster_columns | num_bands | int4 | 10 | √ | null | ||
raster_overviews | overview_factor | int4 | 10 | √ | null | ||
geography_columns | srid | int4 | 10 | √ | null | ||
geometry_columns | srid | int4 | 10 | √ | null | ||
raster_columns | srid | int4 | 10 | √ | null | ||
spatial_ref_sys | srid | int4 | 10 | ||||
geography_columns | f_geography_column | name | 2147483647 | √ | null | ||
geometry_columns | f_geometry_column | name | 2147483647 | √ | null | ||
geography_columns | f_table_catalog | name | 2147483647 | √ | null | ||
geography_columns | f_table_name | name | 2147483647 | √ | null | ||
geometry_columns | f_table_name | name | 2147483647 | √ | null | ||
geography_columns | f_table_schema | name | 2147483647 | √ | null | ||
geometry_columns | f_table_schema | name | 2147483647 | √ | 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_columns | r_raster_column | name | 2147483647 | √ | null | ||
raster_overviews | r_raster_column | name | 2147483647 | √ | null | ||
raster_columns | r_table_catalog | name | 2147483647 | √ | null | ||
raster_overviews | r_table_catalog | name | 2147483647 | √ | null | ||
raster_columns | r_table_name | name | 2147483647 | √ | null | ||
raster_overviews | r_table_name | name | 2147483647 | √ | null | ||
raster_columns | r_table_schema | name | 2147483647 | √ | null | ||
raster_overviews | r_table_schema | name | 2147483647 | √ | null | ||
geography_columns | type | text | 2147483647 | √ | null | ||
geometry_columns | type | varchar | 30 | √ | null | ||
spatial_ref_sys | auth_name | varchar | 256 | √ | null | ||
geometry_columns | f_table_catalog | varchar | 256 | √ | null | ||
spatial_ref_sys | proj4text | varchar | 2048 | √ | null | ||
spatial_ref_sys | srtext | varchar | 2048 | √ | null |