1. A database schema of a database system is its structure described in a formal language supported by the database management system.
2. The formal definition of a database schema is a set of formulas (sentences) called integrity constraints imposed on a database. These integrity constraints ensure compatibility between parts of the schema. All constraints are expressible in the same language.
Database schema of the oedb
v0.2 (current version)
| ISO 19115
| Schema name
|| legal land descriptions. examples: political and administrative boundaries|
|| processes and phenomena of the atmosphere. examples: cloud cover, weather, climate, atmospheric conditions, climate change, precipitation|
|| economic activities, conditions and employment. examples: production, labour, revenue, commerce, industry, tourism and ecotourism, forestry, fisheries, commercial or subsistence hunting, exploration and exploitation of resources such as minerals, oil and gas|
|| consumption and use of energy. examples: peak loads, load curves|
| energy transmission infrastructure. examples: power lines, substation, pipelines|
| conversion (generation) of energy. examples: power stations, renewables|
| environmental resources, protection and conservation. examples: environmental pollution, waste storage and treatment, environmental impact assessment, monitoring environmental risk, nature reserves, landscape|
| characteristics of society and cultures. examples: settlements, anthropology, archaeology, education, traditional beliefs, manners and customs, demographic data, recreational areas and activities, social impact assessments, crime and justice, census information|
| modelling sandbox, temp tables. examples: ego_grid_loadareas. !no version control!|
|| scenario data
| sources, literature|
| emissions, generally means the emission of particles, substances, (sound) waves or radiation into the environment. examples: Annual CO² emissions of Fossil fuel power station|
| OpenStreetMap is a open project that collects and structures freely usable geodata and keeps them in a database for use by anyone. This data is available under a free license, the Open Database License.|
Based on the ISO 19115 B.5.27 TopicCategoryCode:
WARNING: The case and spacing on these terms is controlled and will be invalid if altered.
(also see NOAA ISO Topic Categories)