espon_schemaspy_april19.public Database

Database Properties

Database Type: PostgreSQL - 10.1

Schema public

standard public schema

Tables

Search:

Table / View	Children	Parents	Columns	Rows	Type	Comments
edp_core_tdta_contact	1	0	7	108	Table	This table contains the various contact information such as name, phone, mail etc.
edp_core_tdta_data_item	2	2	8	4237269	Table	The table containing all the values (numeric and text) related to indicators. Each record is also linked to geometries through the gid_id.
edp_core_tdta_datafile	0	1	6	26	Table	This table contains the links to the data file uploaded in the system.
edp_core_tdta_gis	4	1	10	272639	Table	This table contains all the polygon geometries (PostGIS format) corresponding to the various nomenclature levels and version such as NUTS 0 to 3 and LAU.
edp_core_tdta_indicator	3	5	15	838	Table	This table stores information specific to indicator type object.
edp_core_tdta_label	0	1	5	167	Table	This table store the various labels that can be used in data.
edp_core_tdta_media	0	2	8	857	Table	Table including the date of creation et modification of different media, their name and filename, together with category id and id of the corresponding object.
edp_core_tdta_method	2	0	5	265	Table	This table describes methods that can be used for data items and datasets
edp_core_tdta_object	9	5	19	977	Table	tdta_object table is the main table. All types of object are described in this table for "common" attributes (including project, visibility, status, name, etc.)
edp_core_tdta_project	2	1	11	23	Table	This table contains information about the project.
edp_core_tdta_resource	0	2	3	88	Table	This table store information specific to resource type object (such as Mapkit, reports, tools).
edp_core_tdta_set	2	2	9	51	Table	This table store information specific to dataset type object as well as light groups of indicators.
edp_core_tdta_source	2	0	7	486	Table	This table describes sources that can be used for data items in datasets.
edp_core_tkey_constraint_class	1	0	3	5	Table	This is the value table for constraint access.
edp_core_tkey_constraint_use	1	0	3	8	Table	This is the value table for use access.
edp_core_tkey_contact_role	1	0	4	13	Table	This is a value table for the various role that a contact can have (Resource Provider, custodian, owner, distributor, publisher, etc.)
edp_core_tkey_core_type	1	0	3	4	Table	This is the value table containing possible value of core indicator type used in former M4D database (probably after 2013 data import, only two values will remain: core and not core!)
edp_core_tkey_dataitem_type	1	0	4	7	Table	This is the value table containing the data type such as integer, double, text.
edp_core_tkey_gis_level	0	0	3	9	Table	This table contains the administrative level of resolution resolution for the Nomenclatures
edp_core_tkey_indicator_type	1	0	2	4	Table	This is the value table for the indicator types (single, multi, dimension, class)
edp_core_tkey_indicator_year	0	1	3	399	Table	This table lists for each indicator the year containing values.
edp_core_tkey_keyword	1	1	4	389	Table	This is the relation table between keyword and objects.
edp_core_tkey_keyword_set	1	0	4	8	Table	This table includes keyword types such as indicator thems, dataset topics, GEMET Keywords, ESPON policies, etc.
edp_core_tkey_media_category	1	0	2	6	Table	This table includes the typologies of media
edp_core_tkey_nattype	1	0	3	6	Table	This is the value table containing the possible value of NAT type (Stock, Ratio, Rank, Typology, etc.)
edp_core_tkey_nomenclature	2	0	4	10	Table	This table includes the official names (EUROSTAT-GISCO) related to the nomenclatures (NUTS, LAU, UMZ, other).
edp_core_tkey_resource_type	1	0	2	8	Table	This value table includes the various possible type of resources (Mapkit, tool, report).
edp_core_tkey_set_ind_type	1	0	2	3	Table	This table contains the possible value of indicator type in the set object (Key indicator, background indicator, group member)
edp_core_tkey_spatial_ext	2	0	7	9	Table	This table contains information about spatial extent of the object (EU28, EU28+4).
edp_core_tkey_status	2	0	4	7	Table	tkey_status is the value table of object status. This status value is very important in the various workflows and in the behaviour of the interface according to the user roles. Possible values are published, unpublished, archived and deleted. Specific dataset workflow state is part of datset table.
edp_core_trel_data_item_method	0	2	3	733292	Table	This is the relation table between methods and data items.
edp_core_trel_data_item_source	0	2	3	3621263	Table	This is the relation table between sources and data items.
edp_core_trel_object_contact	0	3	4	1780	Table	This is the relation table between contacts and objects, the contact role type is defined here for two different contexts (data or metadata).
edp_core_trel_object_keyword	0	2	3	2475	Table	This is the relation table between keyword and objects.
edp_core_trel_object_method	0	2	3	264	Table	This is the relation table between methods and object
edp_core_trel_object_source	0	2	3	1270	Table	This is the relation table between sources and object.
edp_core_trel_relationship	0	0	4	679	Table	This is the relation table allowing to designate the genealogy between t-indicators.
edp_core_trel_set_indicator	0	3	4	463	Table	This is the relation table between set objects and their indicators objects.
edp_core_trel_spatial_ext_gis	0	2	3	527923	Table	This table establish the spatial extension for each country grouped according to a specific category: eg EU 28, EU 28+ 4 etc.
edp_core_trel_tunit_hierarchy	0	2	3	10337	Table	This table relates the different levels of hierarchy between the nomenclatures: e.g. a NUTS2 is a parent of NUTS3.
edp_core_trel_user_project	0	1	3	13	Table	This is the relation table between users and projects.
geography_columns	0	1	7	0	View
geometry_columns	0	1	7	0	View
raster_columns	0	1	17	0	View
raster_overviews	0	0	9	0	View
spatial_ref_sys	3	0	5	5536	Table	The spatial_ref_sys table is a PostGIS included and OGC compliant database table that lists over 5500 known spatial reference systems and details needed to transform/reproject between them.

Showing 1 to 46 of 46 entries