SchemaSpy Analysis of petascopedb.public - Columns | Generated by SchemaSpy |
Generated by SchemaSpy on Mon Nov 19 22:04 CET 2012 |
| ||||||
|
petascopedb.public contains 140 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
ps_layers | bboxxmax | float8 | 17,17 | √ | null | ||
ps_layers | bboxxmin | float8 | 17,17 | √ | null | ||
ps_layers | bboxymax | float8 | 17,17 | √ | null | ||
ps_layers | bboxymin | float8 | 17,17 | √ | null | ||
ps_crsdetails | high1 | float8 | 17,17 | ||||
ps_crsdetails | high2 | float8 | 17,17 | ||||
ps_layers | latlonboxxmax | float8 | 17,17 | √ | null | ||
ps_layers | latlonboxxmin | float8 | 17,17 | √ | null | ||
ps_layers | latlonboxymax | float8 | 17,17 | √ | null | ||
ps_layers | latlonboxymin | float8 | 17,17 | √ | null | ||
ps_crsdetails | low1 | float8 | 17,17 | ||||
ps_crsdetails | low2 | float8 | 17,17 | ||||
ps_domain | numhi | float8 | 17,17 | √ | null | ||
ps_domain | numlo | float8 | 17,17 | √ | null | ||
ps_crsdetails | offset1 | float8 | 17,17 | √ | null | ||
ps_crsdetails | offset2 | float8 | 17,17 | √ | null | ||
ps_layers | resolution | float8 | 17,17 | √ | null | ||
ps_pyramidlevels | scalefactor | float8 | 17,17 | ||||
ps_services | availability | int4 | 10 | ||||
ps_crsset | axis | int4 | 10 | ||||
ps_celldomain | coverage | int4 | 10 | ||||
ps_crsdetails | coverage | int4 | 10 | ||||
ps_descriptions | coverage | int4 | 10 | ||||
ps_domain | coverage | int4 | 10 | ||||
ps_interpolationset | coverage | int4 | 10 | ||||
ps_metadata | coverage | int4 | 10 | ||||
ps_nullset | coverage | int4 | 10 | ||||
ps_range | coverage | int4 | 10 | ||||
ps_crsset | crs | int4 | 10 | ||||
ps_celldomain | hi | int4 | 10 | ||||
ps_celldomain | i | int4 | 10 | ||||
ps_domain | i | int4 | 10 | ||||
ps_range | i | int4 | 10 | ||||
ps_interpolationset | interpolationtype | int4 | 10 | ||||
ps_coverage | interpolationtypedefault | int4 | 10 | √ | null | ||
ps_pyramidlevels | layerid | int4 | 10 | ||||
ps_servicelayer | layerid | int4 | 10 | ||||
ps_styles | layerid | int4 | 10 | ||||
ps_servicelayer | layerseq | int4 | 10 | ||||
ps_styles | legendheight | int4 | 10 | √ | null | ||
ps_styles | legendwidth | int4 | 10 | √ | null | ||
ps_celldomain | lo | int4 | 10 | ||||
ps_layers | logoheight | int4 | 10 | √ | null | ||
ps_layers | logowidth | int4 | 10 | √ | null | ||
ps_interpolationset | nullresistance | int4 | 10 | ||||
ps_coverage | nullresistancedefault | int4 | 10 | √ | null | ||
ps_services | port | int4 | 10 | ||||
ps_servicelayer | serviceid | int4 | 10 | ||||
ps_domain | type | int4 | 10 | ||||
ps_range | type | int4 | 10 | ||||
ps_domain | uom | int4 | 10 | √ | null | ||
ps_range | uom | int4 | 10 | √ | null | ||
ps_dbupdates | update | int4 | 10 | √ | null | ||
ps_services | updatesequence | int4 | 10 | √ | 0 | ||
ps_axistype | id | serial | 10 | √ | nextval('ps_axistype_id_seq'::regclass) | ||
ps_celldomain | id | serial | 10 | √ | nextval('ps_celldomain_id_seq'::regclass) | ||
ps_coverage | id | serial | 10 | √ | nextval('ps_coverage_id_seq'::regclass) | ||
ps_crs | id | serial | 10 | √ | nextval('ps_crs_id_seq'::regclass) | ||
ps_crsdetails | id | serial | 10 | √ | nextval('ps_crsdetails_id_seq'::regclass) | ||
ps_crsset | id | serial | 10 | √ | nextval('ps_crsset_id_seq'::regclass) | ||
ps_datatype | id | serial | 10 | √ | nextval('ps_datatype_id_seq'::regclass) | ||
ps_dbupdates | id | serial | 10 | √ | nextval('ps_dbupdates_id_seq'::regclass) | ||
ps_descriptions | id | serial | 10 | √ | nextval('ps_descriptions_id_seq'::regclass) | ||
ps_domain | id | serial | 10 | √ | nextval('ps_domain_id_seq'::regclass) | ||
ps_format | id | serial | 10 | √ | nextval('ps_format_id_seq'::regclass) | ||
ps_interpolationset | id | serial | 10 | √ | nextval('ps_interpolationset_id_seq'::regclass) | ||
ps_interpolationtype | id | serial | 10 | √ | nextval('ps_interpolationtype_id_seq'::regclass) | ||
ps_metadata | id | serial | 10 | √ | nextval('ps_metadata_id_seq'::regclass) | ||
ps_nullresistance | id | serial | 10 | √ | nextval('ps_nullresistance_id_seq'::regclass) | ||
ps_nullset | id | serial | 10 | √ | nextval('ps_nullset_id_seq'::regclass) | ||
ps_range | id | serial | 10 | √ | nextval('ps_range_id_seq'::regclass) | ||
ps_uom | id | serial | 10 | √ | nextval('ps_uom_id_seq'::regclass) | ||
ps_layers | layerid | serial | 10 | √ | nextval('ps_layers_layerid_seq'::regclass) | ||
ps_pyramidlevels | levelid | serial | 10 | √ | nextval('ps_pyramidlevels_levelid_seq'::regclass) | ||
ps_services | serviceid | serial | 10 | √ | nextval('ps_services_serviceid_seq'::regclass) | ||
ps_styles | styleid | serial | 10 | √ | nextval('ps_styles_styleid_seq'::regclass) | ||
ps_descriptions | abstract | text | 2147483647 | √ | null | ||
ps_coverage | crs | text | 2147483647 | √ | null | ||
ps_datatype | datatype | text | 2147483647 | ||||
ps_format | description | text | 2147483647 | √ | null | ||
ps_interpolationtype | interpolationtype | text | 2147483647 | ||||
ps_descriptions | keywords | text | 2147483647 | √ | null | ||
ps_uom | link | text | 2147483647 | √ | null | ||
ps_metadata | metadata | text | 2147483647 | √ | null | ||
ps_coverage | name | text | 2147483647 | ||||
ps_crs | name | text | 2147483647 | ||||
ps_domain | name | text | 2147483647 | ||||
ps_range | name | text | 2147483647 | ||||
ps_coverage | nulldefault | text | 2147483647 | √ | null | ||
ps_nullresistance | nullresistance | text | 2147483647 | ||||
ps_coverage | nullvalue | text | 2147483647 | √ | null | ||
ps_nullset | nullvalue | text | 2147483647 | ||||
ps_styles | rasqlop | text | 2147483647 | √ | null | ||
ps_domain | strhi | text | 2147483647 | √ | null | ||
ps_domain | strlo | text | 2147483647 | √ | null | ||
ps_descriptions | title | text | 2147483647 | ||||
ps_uom | uom | text | 2147483647 | √ | null | ||
ps_axistype | axistype | varchar | 9 | ||||
ps_coverage | type | varchar | 30 | √ | null | ||
ps_format | gdalid | varchar | 64 | √ | null | ||
ps_format | name | varchar | 64 | ||||
ps_services | abstract | varchar | 100 | √ | 'undefined'::character varying | ||
ps_services | fees | varchar | 100 | √ | 'undefined'::character varying | ||
ps_services | keywords | varchar | 100 | √ | 'undefined'::character varying | ||
ps_format | mimetype | varchar | 128 | ||||
ps_services | address | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | addresstype | varchar | 200 | √ | 'undefined'::character varying | ||
ps_layers | attributiontitle | varchar | 200 | √ | null | ||
ps_layers | authority | varchar | 200 | √ | null | ||
ps_services | baselayername | varchar | 200 | ||||
ps_services | city | varchar | 200 | √ | 'undefined'::character varying | ||
ps_pyramidlevels | collectionname | varchar | 200 | ||||
ps_services | contactelectronicmailaddress | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | contactfacsimiletelephone | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | contactorganization | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | contactperson | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | contactvoicetelephone | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | country | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | formats | varchar | 200 | ||||
ps_services | hostname | varchar | 200 | ||||
ps_layers | logoformat | varchar | 200 | √ | null | ||
ps_layers | maptype | varchar | 200 | √ | null | ||
ps_layers | name | varchar | 200 | √ | null | ||
ps_services | name | varchar | 200 | ||||
ps_styles | name | varchar | 200 | ||||
ps_services | path | varchar | 200 | ||||
ps_services | postcode | varchar | 200 | √ | 'undefined'::character varying | ||
ps_layers | srs | varchar | 200 | ||||
ps_services | stateorprovince | varchar | 200 | √ | 'undefined'::character varying | ||
ps_layers | title | varchar | 200 | ||||
ps_services | title | varchar | 200 | ||||
ps_styles | title | varchar | 200 | ||||
ps_services | vendorcapabilities | varchar | 200 | √ | 'undefined'::character varying | ||
ps_services | accessconstraints | varchar | 300 | √ | 'undefined'::character varying | ||
ps_layers | attributionurl | varchar | 300 | √ | null | ||
ps_layers | featureurl | varchar | 300 | √ | null | ||
ps_styles | legendurl | varchar | 300 | √ | null | ||
ps_layers | logourl | varchar | 300 | √ | null | ||
ps_styles | sheeturl | varchar | 300 | √ | null | ||
ps_styles | abstract | varchar | 4096 | √ | null |