espon_schemaspy_april19 Database

Columns

Search:

Table	Type	Column	Type	Size	Nulls	Auto	Default	Comments
edp_core_tdta_project	Table	abstract	text	2147483647	√		null	ESPON project description
edp_core_tdta_object	Table	abstract	text	2147483647	√		null	Summary describing the object - mandatory, p.1.3.1.3 of the Specification
edp_core_tdta_project	Table	acronym	varchar	20	√		null	ESPON project acronym when existing
edp_core_tdta_datafile	Table	analysis	jsonb	2147483647	√		null
spatial_ref_sys	Table	auth_name	varchar	256	√		null
spatial_ref_sys	Table	auth_srid	int4	10	√		null
raster_columns	View	blocksize_x	int4	10	√		null
raster_columns	View	blocksize_y	int4	10	√		null
edp_core_tdta_indicator	Table	calculation_date	date	13	√		null	Date of the indicator calculation
edp_core_tdta_media	Table	category_id	int4	10	√		null
edp_core_trel_relationship	Table	child_id	int4	10	√		null	Relation to an t-indicator objects
edp_core_trel_tunit_hierarchy	Table	child_tunit_id	int4	10	√		null	Relation to hierarchically lower nomenclature
edp_core_tdta_indicator	Table	code	varchar	100	√		null	Indicator code - Mandatory, p.1.5.1-3 of the Specification
edp_core_tdta_gis	Table	conformity_degree	varchar	255	√		null
edp_core_tdta_gis	Table	conformity_pub_date	timestamptz	35	√		null
edp_core_tdta_gis	Table	conformity_title	varchar	255	√		null
edp_core_tdta_object	Table	constraint_access	varchar	255	√		null	Access constraint
edp_core_tdta_object	Table	constraint_class_id	int4	10	√		null	classification constraint - Most common value, p.1.3.1.15.4 of the Specification
edp_core_tdta_object	Table	constraint_other	varchar	255	√		null	Other constraint
edp_core_tdta_object	Table	constraint_use_id	int4	10	√		null	use contraint (copyright) - Mandatory, p.1.3.1.15 of the Specification
edp_core_trel_object_contact	Table	contact_id	int4	10	√		null	Relation to contact
edp_core_tkey_contact_role	Table	contact_role	varchar	120	√		null	Contact role value - Mandatory, p.1.7.1.4 of the Specification
edp_core_trel_object_contact	Table	contact_role_id	int4	10	√		null	Relation to contact role - Mandatory, p.1.7.1.4 of the Specification
edp_core_tkey_contact_role	Table	context	varchar	20	√		null	Is this role used for data or metadata
geography_columns	View	coord_dimension	int4	10	√		null
geometry_columns	View	coord_dimension	int4	10	√		null
edp_core_tkey_spatial_ext	Table	coord_x1	numeric	15	√		null	Coordinate of bounding box
edp_core_tkey_spatial_ext	Table	coord_x2	numeric	15	√		null	Coordinate of bounding box
edp_core_tkey_spatial_ext	Table	coord_y1	numeric	15	√		null	Coordinate of bounding box
edp_core_tkey_spatial_ext	Table	coord_y2	numeric	15	√		null	Coordinate of bounding box
edp_core_tdta_indicator	Table	core_type_id	int4	10	√		null	relation to core indicator type defined in M4D - Mandatory, p.TODO of the Specification
edp_core_tdta_datafile	Table	created	timestamptz	35			null	Creation date (upload date of the data file)
edp_core_tdta_project	Table	created	timestamptz	35			null	ESPON project
edp_core_tdta_media	Table	created	timestamptz	35			null
edp_core_tdta_method	Table	created	timestamptz	35			null
edp_core_tdta_object	Table	created	timestamptz	35			null	Automatical creation date of the object (Date of metadata creation (YYYY-MM-DD) - Mandatory, p.1.3.1.9 of the Specification
edp_core_tdta_source	Table	created	timestamptz	35			null
edp_core_trel_data_item_method	Table	data_item_id	int4	10	√		null	Relation to data items
edp_core_trel_data_item_source	Table	data_item_id	int4	10	√		null	Relation to data items
edp_core_tdta_indicator	Table	dataitem_type_id	int4	10	√		null	Relation to data item type (type identifier) - See p.3.4.3 of the specification!
edp_core_tdta_datafile	Table	dataset_id	int4	10			null	Relation to the set object table (to the dataset)
edp_core_tdta_data_item	Table	decimal_value	numeric	40	√		null	values related to the indicator (numerical with decimal)
edp_core_tdta_method	Table	description	text	2147483647	√		null	Method description
edp_core_tkey_status	Table	description	text	2147483647	√		null
edp_core_tkey_dataitem_type	Table	description	text	2147483647	√		null	Free text to describe the identifier type
edp_core_tdta_label	Table	description	text	2147483647	√		null	Label description
edp_core_tdta_source	Table	description	text	2147483647	√		null	Source description
edp_core_tdta_contact	Table	email	varchar	254			null	Email address of contact - Mandatory, p.1.7.1.6 of the Specification
raster_columns	View	extent	geometry	2147483647	√		null
geography_columns	View	f_geography_column	name	2147483647	√		null
geometry_columns	View	f_geometry_column	name	2147483647	√		null
geometry_columns	View	f_table_catalog	varchar	256	√		null
geography_columns	View	f_table_catalog	name	2147483647	√		null
geography_columns	View	f_table_name	name	2147483647	√		null
geometry_columns	View	f_table_name	name	2147483647	√		null
geography_columns	View	f_table_schema	name	2147483647	√		null
geometry_columns	View	f_table_schema	name	2147483647	√		null
edp_core_tdta_datafile	Table	file	varchar	100			null	Internal link to the uploaded XLS data file
edp_core_tdta_media	Table	file	varchar	100	√		null
edp_core_tdta_contact	Table	firstname	varchar	255	√		null	First name of contact - p.1.7.1.1 of the Specification
edp_core_tdta_method	Table	flag	varchar	255			null	A letter (a, b, …)
edp_core_tdta_source	Table	flag	varchar	255			null	An integer (1….)
edp_core_tdta_resource	Table	format	varchar	255			null	Format of file
edp_core_tkey_nomenclature	Table	fullname	varchar	120	√		null	Complete name
edp_core_tdta_gis	Table	geom	geometry	2147483647	√		null	The geometry in PostGis (binary) format: the coordinates of polygons
edp_core_tdta_data_item	Table	gid_id	int4	10	√		null	Relation to the common GIS table (tta_gis)
edp_core_trel_spatial_ext_gis	Table	gis_id	int4	10			null	ID related to nomenclatures IDs
edp_core_tdta_datafile	Table	id	serial	10		√	nextval('edp_core_datafile_id_seq'::regclass)	Unique identifier for data file
edp_core_trel_data_item_source	Table	id	serial	10		√	nextval('edp_core_trel_data_item_source_id_seq'::regclass)	Relation to the object
edp_core_trel_spatial_ext_gis	Table	id	serial	10		√	nextval('edp_core_trel_spatial_ext_gis_id_seq'::regclass)
edp_core_tdta_label	Table	id	serial	10		√	nextval('edp_core_tdta_label_id_seq'::regclass)	Unique identifier for value label
edp_core_tkey_spatial_ext	Table	id	serial	10		√	nextval('edp_core_tkey_spatial_ext_id_seq'::regclass)	Unique identifier for spatial extent
edp_core_tkey_dataitem_type	Table	id	serial	10		√	nextval('edp_core_tkey_dataitem_type_id_seq'::regclass)	Unique identifier for data item type
edp_core_tkey_constraint_class	Table	id	serial	10		√	nextval('edp_core_tkey_constraint_class_id_seq'::regclass)	unique identifier for class constraint -
edp_core_tkey_keyword_set	Table	id	serial	10		√	nextval('edp_core_tkey_keyword_set_id_seq'::regclass)	Unique identifier for keyword type set
edp_core_tkey_resource_type	Table	id	serial	10		√	nextval('edp_core_tkey_resource_type_id_seq'::regclass)	Unique identifier for resource type
edp_core_trel_tunit_hierarchy	Table	id	serial	10		√	nextval('edp_core_trel_tunit_hierarchy_id_seq'::regclass)	Unique identifier for relation
edp_core_tkey_media_category	Table	id	serial	10		√	nextval('edp_core_tkey_media_category_id_seq'::regclass)
edp_core_tkey_core_type	Table	id	serial	10		√	nextval('edp_core_tkey_core_type_id_seq'::regclass)	Unique identifier for core indicator type
edp_core_trel_set_indicator	Table	id	serial	10		√	nextval('edp_core_trel_dataset_indicator_id_seq'::regclass)	Unique identifier for relation
edp_core_tkey_nattype	Table	id	serial	10		√	nextval('edp_core_tkey_nattype_id_seq'::regclass)	Unique identifier for keyword
edp_core_tkey_indicator_year	Table	id	serial	10		√	nextval('edp_core_tkey_indicator_year_id_seq'::regclass)
edp_core_tkey_keyword	Table	id	serial	10		√	nextval('edp_core_tkey_keyword_id_seq'::regclass)	Unique identifier for keyword
edp_core_trel_data_item_method	Table	id	serial	10		√	nextval('edp_core_trel_data_item_method_id_seq'::regclass)	Relation to an indicator objects
edp_core_tdta_project	Table	id	serial	10		√	nextval('edp_core_tdta_project_id_seq'::regclass)	Unique project identifier
edp_core_tkey_indicator_type	Table	id	serial	10		√	nextval('edp_core_trel_indicator_type_id_seq'::regclass)	Unique identifier for indicator type
edp_core_tdta_contact	Table	id	serial	10		√	nextval('edp_core_tdta_contact_id_seq'::regclass)	Unique identifier for contact
edp_core_tdta_media	Table	id	serial	10		√	nextval('edp_core_tdta_media_id_seq'::regclass)
edp_core_trel_relationship	Table	id	serial	10		√	nextval('edp_core_trel_genealogy_id_seq'::regclass)	Unique identifier of genealogy
edp_core_tdta_source	Table	id	serial	10		√	nextval('edp_core_tdta_source_id_seq'::regclass)	Unique identifier for source
edp_core_tkey_nomenclature	Table	id	serial	10		√	nextval('edp_core_tkey_nomenclature_id_seq'::regclass)	Relation to the common GIS table (tta_gis) - Mandatory, p.1.4.2 of the Specification
edp_core_trel_object_keyword	Table	id	serial	10		√	nextval('edp_core_trel_object_keyword_id_seq'::regclass)	Unique identifier for relation
edp_core_tkey_constraint_use	Table	id	serial	10		√	nextval('edp_core_tkey_constraint_use_id_seq'::regclass)	unique identifier for use constraint
edp_core_tdta_object	Table	id	serial	10		√	nextval('edp_core_tdta_object_id_seq'::regclass)	unique identifier of object
edp_core_trel_object_method	Table	id	serial	10		√	nextval('edp_core_trel_object_method_id_seq'::regclass)	Unique identifier for relation
edp_core_tkey_contact_role	Table	id	serial	10		√	nextval('edp_core_tkey_contact_role_id_seq'::regclass)	Unique identifier for contact role
edp_core_trel_object_contact	Table	id	serial	10		√	nextval('edp_core_trel_object_contact_id_seq'::regclass)	Unique identifier for relation
edp_core_trel_object_source	Table	id	serial	10		√	nextval('edp_core_trel_object_source_id_seq'::regclass)	Unique identifier for relation
edp_core_tkey_set_ind_type	Table	id	serial	10		√	nextval('edp_core_tkey_dataset_ind_type_id_seq'::regclass)	Unique identifier of indicator role in a set
edp_core_trel_user_project	Table	id	serial	10		√	nextval('edp_core_trel_user_project_id_seq'::regclass)	Unique identifier for relation
edp_core_tdta_gis	Table	id	serial	10		√	nextval('edp_core_tdta_gis_id_seq'::regclass)	Id used for manage geometries
edp_core_tdta_data_item	Table	id	serial	10		√	nextval('edp_core_tdta_data_item_id_seq'::regclass)	Unique identifier for data items
edp_core_tkey_gis_level	Table	id	serial	10		√	nextval('edp_core_tkey_gis_level_id_seq'::regclass)
edp_core_tdta_method	Table	id	serial	10		√	nextval('edp_core_tdta_method_id_seq'::regclass)	Unique identifier for method
edp_core_tkey_status	Table	id	serial	10		√	nextval('edp_core_tkey_status_id_seq'::regclass)	Unique identifier for object status
edp_core_tdta_project	Table	id_olddb	int4	10	√		null	ESPON Database 2013 project identity
edp_core_trel_set_indicator	Table	Indicator_id	int4	10			null	Relation to indicator
edp_core_tkey_indicator_year	Table	indicator_id	int4	10			null	id of indicator
edp_core_tdta_label	Table	indicator_id	int4	10	√		null
edp_core_tdta_indicator	Table	insertion_date	date	13	√		null	Date of the data insertion
edp_core_tdta_data_item	Table	int_value	int4	10	√		null	values related to the indicator (numerical integer)
edp_core_tdta_set	Table	is_dataset	bool	1			null	Flag identifying if the set is a dataset
edp_core_tdta_set	Table	is_group	bool	1			null	Flag identifying if the set is a group (light grouping)
edp_core_tdta_indicator	Table	is_standard_data	bool	1			null	Identification flag true = standard data related to an internal nomenclature, false = non standard data
edp_core_trel_object_keyword	Table	keyword_id	int4	10	√		null	Relation to Keywords
edp_core_tkey_keyword	Table	keyword_set_id	int4	10	√		null	Relation to keyword set
edp_core_tdta_project	Table	leader	varchar	255	√		null	ESPON responsible person name
edp_core_tdta_set	Table	level	varchar	120	√		null	List of nomenclature levels used in a dataset
edp_core_tdta_gis	Table	level	varchar	10	√		null	Nomenclature level (1,2,3,4, eg.)
edp_core_tkey_gis_level	Table	level_id	varchar	10			null	ID of the level
edp_core_tkey_gis_level	Table	level_name	text	2147483647			null	Name of the level
edp_core_tdta_set	Table	lineage	varchar	255	√		null	Origin of the dataset - Mandatory, p.1.3.1.13 of the Specification
edp_core_tdta_indicator	Table	measure_nd_name	varchar	255	√		null	Numerator / Denominator Name - Mandatory (for numeric data, otherwise inexistent, p.1.5.4.1-2 of the Specification)
edp_core_tdta_indicator	Table	measure_nd_scale	varchar	255	√		null	Numerator / Denominator Scale - Mandatory (for numeric data, otherwise inexistent, p.1.5.4.3-4 of the Specification)
edp_core_tdta_indicator	Table	measure_ranking	bool	1			null	Ranking - Mandatory (for numeric as well as enumerated data)
edp_core_tdta_indicator	Table	method_description	text	2147483647	√		null	Description of the calculation method used
edp_core_trel_data_item_method	Table	method_id	int4	10	√		null	Relation to methods
edp_core_trel_object_method	Table	method_id	int4	10	√		null	Relation to Methods
edp_core_tdta_contact	Table	name	varchar	255			null	Last name of contact - Mandatory, p.1.7.1.1 of the Specification
edp_core_tdta_project	Table	name	varchar	255			null	ESPON Project title - Mandatory, p.1.3.1.2 of the Specification
edp_core_tkey_set_ind_type	Table	name	varchar	120	√		null	Relation type (key indicator, background indicator, group member)
edp_core_tdta_media	Table	name	varchar	100	√		null
edp_core_tkey_core_type	Table	name	varchar	50			null	Core indicator type (used in M4D: in list, downloaded, etc.)
edp_core_tkey_spatial_ext	Table	name	varchar	120	√		null	Spatial extent
edp_core_tkey_keyword_set	Table	name	varchar	120	√		null	keyword type set (ESPON indicator Thems, Dataset Topics, GEMET keywords, ESPON policies, etc.) - For example p.1.5.6 of the Specification
edp_core_tkey_constraint_use	Table	name	varchar	120	√		null	Access constraint - Mandatory, p.1.3.1.15.2 of the Specification
edp_core_tdta_object	Table	name	varchar	255			null	Object title
edp_core_tkey_resource_type	Table	name	varchar	255			null	Resource type name (Mapkit, report, tool, e.g.)
edp_core_tkey_keyword	Table	name	varchar	255	√		null	Keyword, Theme, Policy and topic
edp_core_tkey_dataitem_type	Table	name	varchar	120	√		null	Type identifier of data stored in data base (float, integer, text, etc.) - See p.3.4.3 of the specification!
edp_core_tkey_indicator_type	Table	name	varchar	20			null	Indicator type (single, multi, dimension, class)
edp_core_tkey_media_category	Table	name	varchar	100			null	name of the media
edp_core_tkey_constraint_class	Table	name	varchar	120	√		null	classification constraint - Most common value, p.1.3.1.15.4 of the Specification
edp_core_tkey_status	Table	name	varchar	255			null	Status of the object in the workflow from open until the publication
edp_core_tkey_nattype	Table	name	varchar	120	√		null	NAT type (Stock, Ratio, etc.) - Mandatory, one of NAT type identifiers: CF, CS, IR, IC, IA, TG, TP, TS
edp_core_tdta_label	Table	name	varchar	120	√		null	Value label
edp_core_trel_set_indicator	Table	name_id	int4	10	√		null	Relation to a indicator role in set (tkey_set_ind_type)
edp_core_tdta_indicator	Table	nattype_id	int4	10	√		null	Relation to NAT type - Mandatory, one of NAT type identifiers: CF, CS, IR, IC, IA, TG, TP, TS
raster_columns	View	nodata_values	_float8	17	√		null
edp_core_tkey_nomenclature	Table	nomenclature	varchar	120	√		null	Official name for NUTS and LAU as provided by Eurostat - Mandatory, p.1.4.2 of the Specification
edp_core_tdta_set	Table	nomenclature_id	int4	10	√		null	Nomenclature used in a dataset
edp_core_tdta_gis	Table	nomenclature_id	int4	10	√		null	Relation to nomenclature type (NUTS, LAU, eg.)
raster_columns	View	num_bands	int4	10	√		null
raster_overviews	View	o_raster_column	name	2147483647	√		null
raster_overviews	View	o_table_catalog	name	2147483647	√		null
raster_overviews	View	o_table_name	name	2147483647	√		null
raster_overviews	View	o_table_schema	name	2147483647	√		null
edp_core_trel_object_contact	Table	obj_id	int4	10	√		null	relation to object
edp_core_tdta_data_item	Table	obj_id	int4	10	√		null	Relation to the common object table
edp_core_trel_object_source	Table	obj_id	int4	10	√		null	Relation to objects
edp_core_trel_object_keyword	Table	obj_id	int4	10	√		null	Relation to objects
edp_core_trel_object_method	Table	obj_id	int4	10	√		null	Relation to objects
edp_core_tdta_contact	Table	organisation	varchar	255	√		null	Organisation name of contact - Mandatory, p.1.7.1.2 of the Specification
raster_columns	View	out_db	_bool	1	√		null
raster_overviews	View	overview_factor	int4	10	√		null
edp_core_trel_relationship	Table	parent_id	int4	10	√		null	Relation to an t-indicator objects
edp_core_trel_tunit_hierarchy	Table	parent_tunit_id	int4	10	√		null	Relation to hierarchically superior nomenclature
edp_core_tdta_object	Table	period_from	date	13	√		null	temporal cover of the object (begining)
edp_core_tdta_object	Table	period_to	date	13	√		null	temporal cover of the object (end)
edp_core_tdta_contact	Table	phone	varchar	255			null	Phone number with international prefix - Optional, p.1.7.1.5 of the Specification
raster_columns	View	pixel_types	_text	2147483647	√		null
edp_core_tdta_contact	Table	position	varchar	120	√		null	Job position in the organisation - Optional, p.1.7.1.3 of the Specification
spatial_ref_sys	Table	proj4text	varchar	2048	√		null
edp_core_trel_user_project	Table	project_id	int4	10			null	Relation to project id
edp_core_tdta_object	Table	project_id	int4	10	√		null	Relation to the project - Mandatory, p.1.3.1.2 of the Specification
edp_core_tkey_keyword_set	Table	pub_date	timestamptz	35			null	Keyword set Publication date
edp_core_tdta_object	Table	publication_date	timestamptz	35	√		null
raster_columns	View	r_raster_column	name	2147483647	√		null
raster_overviews	View	r_raster_column	name	2147483647	√		null
raster_overviews	View	r_table_catalog	name	2147483647	√		null
raster_columns	View	r_table_catalog	name	2147483647	√		null
raster_columns	View	r_table_name	name	2147483647	√		null
raster_overviews	View	r_table_name	name	2147483647	√		null
raster_overviews	View	r_table_schema	name	2147483647	√		null
raster_columns	View	r_table_schema	name	2147483647	√		null
raster_columns	View	regular_blocking	bool	1	√		null
edp_core_tdta_object	Table	resource_uuid	varchar	255	√		null	Unique resource identifier - Mandatory, p.1.3.1.6 of the Specification
raster_columns	View	same_alignment	bool	1	√		null
raster_columns	View	scale_x	float8	17	√		null
raster_columns	View	scale_y	float8	17	√		null
edp_core_tkey_contact_role	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_constraint_use	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_spatial_ext	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_keyword	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_nomenclature	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tdta_object	Table	sequence	int4	10			null
edp_core_tdta_label	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_dataitem_type	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_constraint_class	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_status	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_keyword_set	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_core_type	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_tkey_nattype	Table	sequence	int4	10			null	Number allowing tailored order
edp_core_trel_set_indicator	Table	Set_id	int4	10			null	Relation to set
edp_core_tdta_source	Table	source_date	timestamptz	35			null	Date of source - Publication date
edp_core_trel_data_item_source	Table	source_id	int4	10	√		null	Relation to sources
edp_core_trel_object_source	Table	source_id	int4	10	√		null	Relation to sources
edp_core_tdta_source	Table	source_url	varchar	255	√		null	in most case the URL of the providers website
edp_core_tdta_object	Table	spatial_ext_id	int4	10	√		null	Relation to spatial extent (EU28, EU28+4) -
edp_core_trel_spatial_ext_gis	Table	spatial_ext_id	int4	10			null	ID related to spatial extents
raster_columns	View	spatial_index	bool	1	√		null
edp_core_tdta_object	Table	spatial_resolution	varchar	255	√		null	Free text to describe spatial resolution of the object
raster_columns	View	srid	int4	10	√		null
spatial_ref_sys	Table	srid	int4	10			null
geometry_columns	View	srid	int4	10	√		null
geography_columns	View	srid	int4	10	√		null
spatial_ref_sys	Table	srtext	varchar	2048	√		null
edp_core_tdta_object	Table	status_comment	text	2147483647	√		null
edp_core_tdta_object	Table	status_id	int4	10	√		null	Status of the object (published, unpublished, archived, deleted) related to tkey_status value list
edp_core_tdta_project	Table	status_id	int4	10	√		null
edp_core_tdta_media	Table	tdta_object_id	int4	10			null
edp_core_tdta_set	Table	tdta_object_ptr_id	int4	10			null	Relation to the common object table
edp_core_tdta_indicator	Table	tdta_object_ptr_id	int4	10			null	Relation to the common object table
edp_core_tdta_resource	Table	tdta_object_ptr_id	int4	10			null	Relation to common object table
edp_core_tdta_gis	Table	tunit_code	varchar	255	√		null	Id of each geometric object
edp_core_tdta_gis	Table	tunit_name	varchar	255	√		null	Official geometric name in english
edp_core_tdta_data_item	Table	txt_value	varchar	255	√		null	values related to the indicator (text format)
geometry_columns	View	type	varchar	30	√		null
edp_core_trel_relationship	Table	type	varchar	20			null	Genealogy type (lineage or dimension)
geography_columns	View	type	text	2147483647	√		null
edp_core_tdta_indicator	Table	type_id	int4	10			null	Indicator type id linked to the value list indicator type (single, multi, dimension, class)
edp_core_tdta_resource	Table	type_id	int4	10			null	Resource type id linked to tkey_resource_type (MapKit, Report, e.g.)
edp_core_tdta_indicator	Table	update_date	date	13	√		null	Date of the last indicator update
edp_core_tdta_media	Table	updated	timestamptz	35			null
edp_core_tdta_project	Table	updated	timestamptz	35			null	ESPON project last update date
edp_core_tdta_method	Table	updated	timestamptz	35			null
edp_core_tdta_datafile	Table	updated	timestamptz	35			null	Update date
edp_core_tdta_source	Table	updated	timestamptz	35			null
edp_core_tdta_object	Table	updated	timestamptz	35			null	Automatical update date of the object (YYYY-MM-DD)
edp_core_tdta_set	Table	uri	varchar	100	√		null	Unique identifier of the dataset
edp_core_tdta_media	Table	url	text	2147483647	√		null
edp_core_tdta_project	Table	url	varchar	200	√		null
edp_core_trel_user_project	Table	user_id	int4	10			null	Relation to project members
edp_core_tkey_indicator_year	Table	value	int4	10			null	the year containing the value
edp_core_tdta_set	Table	version	varchar	120	√		null	List of nomenclature versions used in a dataset
edp_core_tdta_gis	Table	version	int4	10	√		null	Nomenclature version (year)
edp_core_tdta_project	Table	workflow_state	varchar	20			null
edp_core_tdta_set	Table	workflow_state	varchar	20			null	State of the object in the workflow from open until the publication
edp_core_tdta_data_item	Table	year_end	int4	10	√		null	End year (4 digits) of data coverage
edp_core_tdta_data_item	Table	year_start	int4	10	√		null	Starting year (4 digits) of data coverage
edp_core_tdta_indicator	Table	years	varchar	255	√		null	List of years covered by the indicator

Showing 1 to 251 of 251 entries