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