SchemaSpy Analysis of sola.public - ColumnsDefault schema for all PostgreSQL databases. Contains functions supporting the PostGIS and UUID-OSSP extensions as well as some common SOLA functions. For information on PostGIS functions see http://postgis.net/docs/reference.html. For information on UUID-OSSP functions see http://www.postgresql.org/docs/9.3/static/uuid-ossp.html | Generated by SchemaSpy |
Generated by SchemaSpy on Tue May 31 09:59 NZST 2016 |
| ||||||
|
sola.public contains 45 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
spatial_ref_sys | auth_name | varchar | 256 | √ | 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 | extent | geometry | 2147483647 | √ | null | ||
geography_columns | f_geography_column | name | 2147483647 | √ | null | ||
geometry_columns | f_geometry_column | name | 2147483647 | √ | null | ||
geography_columns | f_table_catalog | name | 2147483647 | √ | null | ||
geometry_columns | f_table_catalog | varchar | 256 | √ | 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_columns | nodata_values | _float8 | 17,17 | √ | null | ||
raster_columns | num_bands | 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_columns | out_db | _bool | 1 | √ | null | ||
raster_overviews | overview_factor | int4 | 10 | √ | null | ||
raster_columns | pixel_types | _text | 2147483647 | √ | null | ||
spatial_ref_sys | proj4text | varchar | 2048 | √ | 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 | ||
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 | ||
geography_columns | srid | int4 | 10 | √ | null | ||
geometry_columns | srid | int4 | 10 | √ | null | ||
raster_columns | srid | int4 | 10 | √ | null | ||
spatial_ref_sys | srid | int4 | 10 | ||||
spatial_ref_sys | srtext | varchar | 2048 | √ | null | ||
geography_columns | type | text | 2147483647 | √ | null | ||
geometry_columns | type | varchar | 30 | √ | null |