heritage_site - Table definition

Privacy & Cookies
We request your permission to obtain statistical data of your navigation in this web.
If you continue browsing we consider that you accept the use of cookies.

Review Cookies Policy

table heritage_site

General information

Table: heritage_site

Description: heritage site

Type: Master

Rows: 78,633

columns: 14

Data: 600,458

columns

field	description	Type	Unit	foreign table
id	Unique identifier	Integer
name	name	Text
image	image	Text
id_heritage_designation	heritage designation	foreign key		heritage designation
Area	Area	Real	m²
date_completed	date completed	Date
id_Country	Country	foreign key		country
id_continent	continent	foreign key		continent
latitude	latitude	Coordinate	°
longitude	longitude	Coordinate	°
id_style	style	foreign key		style of construction
website	Website	Text
id_city	city	foreign key		city
id_division_1	administrative división	foreign key		administrative division

Relations

description	related table	relationship table
heritage site/entity	entity	HeritageSite_entity

Table in which FK is located

table	field
heritage site/entity	id_HeritageSite