SchemaSpy Analysis of petascopedb.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Mon Jul 07 14:34 CEST 2014
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

petascopedb.public contains 186 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
ps_services abstract varchar 100  √  'undefined'::character varying
ps_styles abstract varchar 4096  √  null
ps_description abstracts _text 2147483647  √  null
ps_service_identification access_constraints _text 2147483647  √  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_rasdaman_collection base_type text 2147483647  √  null
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_service_provider contact_administrative_area text 2147483647  √  null
ps_service_provider contact_city text 2147483647  √  null
ps_service_provider contact_country text 2147483647  √  null
ps_service_provider contact_delivery_points _text 2147483647  √  null
ps_service_provider contact_email_addresses _text 2147483647  √  null
ps_service_provider contact_hours_of_service text 2147483647  √  null
ps_service_provider contact_individual_name text 2147483647  √  null
ps_service_provider contact_instructions text 2147483647  √  null
ps_service_provider contact_phone_id int4 10  √  null
ps_service_provider contact_position_name text 2147483647  √  null
ps_service_provider contact_postal_code text 2147483647  √  null
ps_service_provider contact_role_id int4 10  √  null
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_quantity definition_uri text 2147483647  √  null
ps_gdal_format description text 2147483647  √  null
ps_quantity description text 2147483647  √  ''::text
ps_role_code description text 2147483647  √  null
ps_coverage description_id int4 10  √  null
ps_service_identification description_id int4 10  √  null
ps_telephone facsimile _text 2147483647  √  null
ps_layers featureurl varchar 300  √  null
ps_service_identification fees text 2147483647  √  null
ps_services fees varchar 100  √  'undefined'::character varying
ps_range_type_component field_table text 2147483647  √  'ps_quantity'::text
ps_format gdal_id int4 10  √  null
ps_description keyword_group_ids _int4 10  √  null
ps_services keywords varchar 100  √  'undefined'::character varying
ps_quantity label text 2147483647  √  ''::text
ps_keyword language text 2147483647  √  null
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_styles legendheight int4 10  √  null
ps_styles legendurl varchar 300  √  null
ps_styles legendwidth int4 10  √  null
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_layers maptype varchar 200  √  null
ps_range_data_type meaning text 2147483647  √  null
ps_layers name varchar 200  √  null
ps_quantity nil_ids _int4 10  √  null
ps_services postcode varchar 200  √  'undefined'::character varying
ps_styles rasqlop text 2147483647  √  null
ps_layers resolution float8 17,17  √  null
ps_styles sheeturl varchar 300  √  null
ps_quantity significant_figures int4 10  √  null
ps_service_provider site text 2147483647  √  null
ps_services stateorprovince varchar 200  √  'undefined'::character varying
ps_gml_subtype subtype_parent int4 10  √  null
ps_description titles _text 2147483647  √  null
ps_keyword_group type text 2147483647  √  null
ps_keyword_group type_codespace text 2147483647  √  null
ps_service_identification type_codespace text 2147483647  √  null
ps_services updatesequence int4 10  √  0
ps_numeric_constants value numeric 131089  √  null
ps_string_constants value text 2147483647  √  null
ps_services vendorcapabilities varchar 200  √  'undefined'::character varying
ps_telephone voice _text 2147483647  √  null
ps_services availability int4 10
ps_services baselayername varchar 200
ps_uom code text 2147483647
ps_vector_coefficients coefficient numeric 131089
ps_vector_coefficients coefficient_order int4 10
ps_pyramidlevels collectionname varchar 200
ps_range_type_component component_order int4 10
ps_bounding_box coverage_id int4 10
ps_domain_set coverage_id int4 10
ps_extra_metadata coverage_id int4 10
ps_gridded_domain_set coverage_id int4 10
ps_range_set coverage_id int4 10
ps_range_type_component coverage_id int4 10
ps_range_type_component data_type_id int4 10
ps_range_type_component field_id int4 10
ps_services formats varchar 200
ps_gdal_format gdal_id text 2147483647
ps_coverage gml_type_id int4 10
ps_rectilinear_axis grid_axis_id int4 10
ps_vector_coefficients grid_axis_id int4 10
ps_gridded_domain_set grid_origin _numeric 131089
ps_grid_axis gridded_coverage_id int4 10
ps_services hostname varchar 200
ps_bounding_box id serial 10  √  nextval('ps_bounding_box_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_dbupdates id serial 10  √  nextval('ps_dbupdates_id_seq'::regclass)
ps_description id serial 10  √  nextval('ps_description_id_seq'::regclass)
ps_extra_metadata id serial 10  √  nextval('ps_extra_metadata_id_seq'::regclass)
ps_extra_metadata_type id serial 10  √  nextval('ps_extra_metadata_type_id_seq'::regclass)
ps_format id serial 10  √  nextval('ps_format_id_seq'::regclass)
ps_gdal_format id serial 10  √  nextval('ps_gdal_format_id_seq'::regclass)
ps_gml_subtype id serial 10  √  nextval('ps_gml_subtype_id_seq'::regclass)
ps_grid_axis id serial 10  √  nextval('ps_grid_axis_id_seq'::regclass)
ps_interval id serial 10  √  nextval('ps_interval_id_seq'::regclass)
ps_keyword id serial 10  √  nextval('ps_keyword_id_seq'::regclass)
ps_keyword_group id serial 10  √  nextval('ps_keyword_group_id_seq'::regclass)
ps_mime_type id serial 10  √  nextval('ps_mime_type_id_seq'::regclass)
ps_nil_value id serial 10  √  nextval('ps_nil_value_id_seq'::regclass)
ps_quantity id serial 10  √  nextval('ps_quantity_id_seq'::regclass)
ps_range_data_type id serial 10  √  nextval('ps_range_data_type_id_seq'::regclass)
ps_range_set id serial 10  √  nextval('ps_range_set_id_seq'::regclass)
ps_range_type_component id serial 10  √  nextval('ps_range_type_component_id_seq'::regclass)
ps_rasdaman_collection id serial 10  √  nextval('ps_rasdaman_collection_id_seq'::regclass)
ps_role_code id serial 10  √  nextval('ps_role_code_id_seq'::regclass)
ps_service_identification id serial 10  √  nextval('ps_service_identification_id_seq'::regclass)
ps_service_provider id serial 10  √  nextval('ps_service_provider_id_seq'::regclass)
ps_telephone id serial 10  √  nextval('ps_telephone_id_seq'::regclass)
ps_uom id serial 10  √  nextval('ps_uom_id_seq'::regclass)
ps_quantity_interval interval_id int4 10
ps_numeric_constants key text 2147483647
ps_string_constants key text 2147483647
ps_keyword_group keyword_ids _int4 10
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_pyramidlevels levelid serial 10  √  nextval('ps_pyramidlevels_levelid_seq'::regclass)
ps_bounding_box lower_left _numeric 131089
ps_interval max numeric 131089
ps_extra_metadata metadata_type_id int4 10
ps_mime_type mime_type varchar 255
ps_format mime_type_id int4 10
ps_interval min numeric 131089
ps_coverage name text 2147483647
ps_format name text 2147483647
ps_range_data_type name text 2147483647
ps_range_type_component name text 2147483647
ps_rasdaman_collection name varchar 254
ps_service_provider name text 2147483647
ps_services name varchar 200
ps_styles name varchar 200
ps_domain_set native_crs_ids _int4 10
ps_coverage native_format_id int4 10
ps_rectilinear_axis offset_vector _numeric 131089
ps_rasdaman_collection oid numeric 20
ps_services path varchar 200
ps_services port int4 10
ps_quantity_interval quantity_id int4 10
ps_grid_axis rasdaman_order int4 10
ps_nil_value reason text 2147483647
ps_pyramidlevels scalefactor float8 17,17
ps_servicelayer serviceid int4 10
ps_services serviceid serial 10  √  nextval('ps_services_serviceid_seq'::regclass)
ps_layers srs varchar 200
ps_range_set storage_id int4 10
ps_range_set storage_table text 2147483647 'ps_rasdaman_collection'::text
ps_styles styleid serial 10  √  nextval('ps_styles_styleid_seq'::regclass)
ps_gml_subtype subtype text 2147483647
ps_layers title varchar 200
ps_services title varchar 200
ps_styles title varchar 200
ps_extra_metadata_type type text 2147483647
ps_service_identification type text 2147483647
ps_service_identification type_versions _text 2147483647
ps_quantity uom_id int4 10
ps_dbupdates update int4 10
ps_bounding_box upper_right _numeric 131089
ps_crs uri text 2147483647
ps_extra_metadata value text 2147483647
ps_keyword value text 2147483647
ps_nil_value value text 2147483647
ps_role_code value text 2147483647