SchemaSpy Analysis of petascopedb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Nov 19 22:04 CET 2012
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

petascopedb.public contains 140 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
ps_descriptions abstract text 2147483647  √  null
ps_services abstract varchar 100  √  'undefined'::character varying
ps_styles abstract varchar 4096  √  null
ps_services accessconstraints varchar 300  √  'undefined'::character varying
ps_services address varchar 200  √  'undefined'::character varying
ps_services addresstype varchar 200  √  'undefined'::character varying
ps_layers attributiontitle varchar 200  √  null
ps_layers attributionurl varchar 300  √  null
ps_layers authority varchar 200  √  null
ps_services availability int4 10
ps_crsset axis int4 10
ps_axistype axistype varchar 9
ps_services baselayername varchar 200
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_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_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_coverage crs text 2147483647  √  null
ps_crsset crs int4 10
ps_datatype datatype text 2147483647
ps_format description text 2147483647  √  null
ps_layers featureurl varchar 300  √  null
ps_services fees varchar 100  √  'undefined'::character varying
ps_services formats varchar 200
ps_format gdalid varchar 64  √  null
ps_celldomain hi int4 10
ps_crsdetails high1 float8 17,17
ps_crsdetails high2 float8 17,17
ps_services hostname varchar 200
ps_celldomain i int4 10
ps_domain i int4 10
ps_range i int4 10
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_interpolationset interpolationtype int4 10
ps_interpolationtype interpolationtype text 2147483647
ps_coverage interpolationtypedefault int4 10  √  null
ps_descriptions keywords text 2147483647  √  null
ps_services keywords varchar 100  √  'undefined'::character varying
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_layers layerid serial 10  √  nextval('ps_layers_layerid_seq'::regclass)
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 legendurl varchar 300  √  null
ps_styles legendwidth int4 10  √  null
ps_pyramidlevels levelid serial 10  √  nextval('ps_pyramidlevels_levelid_seq'::regclass)
ps_uom link text 2147483647  √  null
ps_celldomain lo int4 10
ps_layers logoformat varchar 200  √  null
ps_layers logoheight int4 10  √  null
ps_layers logourl varchar 300  √  null
ps_layers logowidth int4 10  √  null
ps_crsdetails low1 float8 17,17
ps_crsdetails low2 float8 17,17
ps_layers maptype varchar 200  √  null
ps_metadata metadata text 2147483647  √  null
ps_format mimetype varchar 128
ps_coverage name text 2147483647
ps_crs name text 2147483647
ps_domain name text 2147483647
ps_format name varchar 64
ps_layers name varchar 200  √  null
ps_range name text 2147483647
ps_services name varchar 200
ps_styles name varchar 200
ps_coverage nulldefault text 2147483647  √  null
ps_interpolationset nullresistance int4 10
ps_nullresistance nullresistance text 2147483647
ps_coverage nullresistancedefault int4 10  √  null
ps_coverage nullvalue text 2147483647  √  null
ps_nullset nullvalue text 2147483647
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_services path varchar 200
ps_services port int4 10
ps_services postcode varchar 200  √  'undefined'::character varying
ps_styles rasqlop text 2147483647  √  null
ps_layers resolution float8 17,17  √  null
ps_pyramidlevels scalefactor float8 17,17
ps_servicelayer serviceid int4 10
ps_services serviceid serial 10  √  nextval('ps_services_serviceid_seq'::regclass)
ps_styles sheeturl varchar 300  √  null
ps_layers srs varchar 200
ps_services stateorprovince varchar 200  √  'undefined'::character varying
ps_domain strhi text 2147483647  √  null
ps_domain strlo text 2147483647  √  null
ps_styles styleid serial 10  √  nextval('ps_styles_styleid_seq'::regclass)
ps_descriptions title text 2147483647
ps_layers title varchar 200
ps_services title varchar 200
ps_styles title varchar 200
ps_coverage type varchar 30  √  null
ps_domain type int4 10
ps_range type int4 10
ps_domain uom int4 10  √  null
ps_range uom int4 10  √  null
ps_uom uom text 2147483647  √  null
ps_dbupdates update int4 10  √  null
ps_services updatesequence int4 10  √  0
ps_services vendorcapabilities varchar 200  √  'undefined'::character varying