SchemaSpy Analysis of qwat.public - 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.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