Revision as of 08:10, 10 October 2016

The following database rules explain the usage of the database called oedb, which will become a part of the openmod internet presence. For further details see also here.

Data Documentation

All data included in the databases has be documented! On this wiki page you learn, how to do so.
All abreviations have to be documentated in the

Naming of Data

The data in the database is organised in schemata and tables, which names are important to find around.

Database Name

The name of the database is oedb.

Database Schema

The structure of the database is realised via the naming of the schemata, which follows the following rules:

always lower case
no points, no commas
no spaces
no dates
use underscores

The schema is categorized into the the type of the schema:
- demand
- economic
- emission
- environmental
- grid
- political_boundary
- social
- supply
- scenario
- weather
- model_draft
- reference

Further schema categories or change can be discussed under Discussion.

Database Table

always lower case
no points, no commas
no spaces
no dates
use underscores

The table name consists of

name starts with the source or model name (e.g. zensus, ego)
main value (e.g. population)
if separated by [attribute] (e.g. by_gender)
with resolution [tupel] (e.g. per_mun)

Example: zensus_population_by_gender_per_mun

Data Integrity

"Data integrity refers to maintaining and assuring the accuracy and consistency of data over its entire life-cycle." (Wikipedia) These two aspects belong to the data quality criteria, the data in the oedb should meet.

General

Each table should have a single auto-incremented integer column as Primary Key with the corresponding table constraint.
Grant all privilegs to oeuser (automatically done by the system)

Geografic Data

Attribut name is geom.
Data type is geometry (or raster).
One of the Geometric Types is defined (https://www.postgresql.org/docs/current/static/datatype-geometric.html)
The CRS is defined as EPSG (http://spatialreference.org/ref/epsg/)
- Original data stays with the original CRS!
- Prefered CRS of the oedb are:

WGS84 - EPSG: 4326 (http://spatialreference.org/ref/epsg/4326/)
ETRS89 / ETRS-LAEA - EPSG: 3035 (http://spatialreference.org/ref/epsg/3035/)

Spacial index GIST

Data Referencing

There are several useful attributes on a table users have to know in order to work with the contained data efficiently. Therefore, ensuring the quality of these meta data is as important as ensuring the quality of the data itself (see also here).

For these meta data the documentation open-standard Json is used (Wiki and Json.org). The documentation is separated in two major categories:

Comments on schema: Contains metadata that define several aspects for the database schema
Comments on tables: Contains metadata that define several aspects for the whole table
Comments on rows: Store important informations on a specific row and the stored data

Comments on Schema

Schemata are used in the database in order to structure tables, functions, assign assignment of permissions and much more. For the documentation purpose a string in json format is set as comment on schema. The attribute names begins with an upper case and are given by the following definition for schemata.

Metadata Documentation of schemata
Attribute (level 1)	Attribute (level 2)	Description
Name		Original name of the data set
Description		Short description of the data set.
Changes		Information of changes and user
	Name	Name of Person created or changed dataset
	Mail	E-mail Address
	Date	Date of changes
	Comment	Comment of changes
Note		Field for notes or ToDo which are not done yet

SQL Json Example

Comments on Tables

Comments on a table are json-dictionary as strings that describe the overall structure of the corresponding table. For every field the corresponding unit (in case of numerical values) and a description that specifies the contained data should be attached. The attribute names begins with an upper case and are given by the following definition of Database Tables. The Json meta documentation string is stored as table comment on the database table.

Meta Documentation of Tables

Original Data (orig) are defined as data from one source which are not further processed (see: Database Schema). The metadata Documentation for those data sets are set as a comment on the table. Following meta data are proposed:

Metadata Documentation of original data on table
Attribute (level 1)	Attribute (level 2)	Description
Name		Original name of the data set
Source
	Name	Source Name
	URL	URL string
Reference date		Reference date of the data set.
Date of collection		Date of data collection into the database.
Original file		Name of the original data file with file extension (e.g. .xls,.shp, .pdf, etc.)
Spatial resolution		Spatial resolution of the data set
Description		Short description of the data set.
Column		Metadata of all table fields / columns
	Name	Name of Column 1
	Description	English description of Column 1
	Unit	Unit if exist e.g. (€, MWh, etc.)
	…	...
	Name	Name of Column N
	Description	English description of Column N
	Unit	Unit if exist e.g. (€, MWh, etc.)
Changes		Information of changes and user
	Name	Name of Person created or changed dataset
	Mail	E-mail Address
	Date	Date of changes
	Comment	Comment of changes
Note		Comment of ToDo which are not done yet
Licence		Licence of the data set
	Name	Name of Licence
	URL	URL of Licence
Instructions for proper use		Instructions for proper use of Licences.

Json Example:

{
"Name": "Original name of the data set",
"Source":[{
 "Name": "Website of data",
 "URL": "www.website.com" }],
"Reference date": ["2013"],
"Date of collection": ["01.08.2013"],
"Original file": ["346-22-5.xls"],
"Spatial resolution": ["Germany"],
"Description": ["Example Data (annual totals)", "Regional level: national"],

"Column": [
 {"Name":"id",
 "Description":"Unique identifier",
 "Unit":"" },

 {"Name":"year",
 "Description":"Reference Year",
 "Unit":"" },

 {"Name":"example_value",
 "Description": "Some important value",
 "Unit":"EUR" }],

"Changes":[
 {"Name":"Joe Nobody",
 "Mail":"joe.nobody@gmail.com (fake)",
 "Date":"16.06.2014",
 "Comment":"Created table" },

 {"Name":"Joana Anybody",
 "Mail":"joana.anybody@gmail.com (fake)",
 "Date":"17.07.2014",
 "Comment":"Translated field names"}],

"Note": ["Some datasets are odd -> Check numbers against another data"],
"Licence": [{"Name":"Licence – Version 2.0 (dl-de/by-2-0",
 "URL": "http://www.govdata.de/dl-de/by-2-0]"],
"Instructions for proper use": ["Always state licence"]
}

Meta Documentation of data collections from several sources:

This section is still work in progress! Please contribute to the discussion to improve the implementation.

In addition to the meta documentation described above, data tables (blue table in figure) which include data from several sources get a ref_id column. The ref_id links each row with a json documentation string (ref_data_json) in the database table public.reference_to_entries (green table in figure).This table also includes the ref_data_json column which links to all sources of the row to be referenced (blue). The ref_data_json string includes one jabref_entries_id for each source used. The jabref_entries_id is matched by one entries_id belonging to a source stored in the public.entries table (orange table).

Example: ER-Model

ERM references example

reference_to_entries table structure:

ref_id	ref_data_json	schema_name	tbl_name	changed_by	lastmodified
Reference ID	Json Documentation string	Name of the schema which includes the table “tbl_name”	Name of table with the data to be referenced	Name of user changing or creating this reference entry. (Automaticdefault setting)	Date of entry modification. (Automatic default setting)

Each row in the reference_to_entries table (green) contains a ref_data_json documentation string which links to the meta data in the Jabref table public.entries (orange).

Json documentation string structure on row:

Metadata Documentation of data on rows
Attribute (level 1)	Attribute (level 2)	Attribute (level 3)	Description
Name			Name of the table to be referenced
Discription			Short description of the table
Column			Columns which need to be referenced
	<column name 1>		Column name 1, (original column name and spelling)
		jabref_entries_id	Jabref entries id of Literature entry
		Description	Short description
	<columnname2>		Column name 2, (original column name and spelling)
		jabref_entries_id	Jabref entries id of Literature entry
		Description	Short description
Note			Note or comment to this entry

Example:

Database table: ref_test.parameter_electrical_power_plant

fuel	type_of_generation	effnetto_el	...	opex_var	ref_id
coal	st	0.35	...	2	1
...

Database table: reference_to_entries table structure:

ref_id	ref_data_json	schema_name	tbl_name	changed_by	lastmodified
1	{ "Name": "Collection of electrical power plant parameter", "Discription": "Technical parameter of confentional electrical power plants …	ref_test	parameter_electrical_power_plant	user_1	2016-03-17 15:37:24.538213

JsonExample:

{
"Name": ["Collection of electrical power plant parameter"],
"Description":["Technical parameter of conventional electrical power plants "],
"Column": [{
 "effnetto_el":{"jabref_entries_id": 1,
 "Description":"Electrical net efficiency},
 
 "opex_var": {"jabref_entries_id": 2,
 "Description":"Variable operational expenditure"} }],

"Note":["Short note or comment to this entry"]
 }

Note: The general meta information like units are given meta documentation of the table.

The metadata BibTeX standard from JabRef is used for the Data Referencing in the table public.entries.

Comments on Rows

The comments on a row aim to enhance the reproducabilty of data that is present in the database by stating the underlying data that was used to compute this row as well as the applied computational methods.

During these processes some kinds of uncertainities might occur as well as the decissions (assumtions) that were made to deal with them. Examplatory, some values might be missing amid this row and a linear development during this period was assumed to fix this gap. Each row has to be annotated by a json dictionary that must contain the following fields:

origin: Link or textual description of the data set this row origins from.
method: Method used to calculate this row from above origin (e.g. Link to a python script)
assumption: A list of dictionaries. Each dictionary describes an assumption and annotates the affected rows.
- begin: First column affected by the assumption
- end: Last column affected by the assumption
- type: Type of the problem that had to be solved. Each type requires one or more additional keys in this dictionary. Possible types and their required additional keys are:
  - gap: A not all fields could be calculated and/or filled
    - solution: Method that was used to generate date to fill this gap (e.g. linear interpolation)

multiplicity: A field could be filled by several values
solution: Method that was used to select one value (e.g. Minimum)
values: Possible Values that could have been used

An examplatory dictionary:

{
"origin":"https://data.openmod-initiative.org/data/oedb/orig_db/table
"method":"https://github.com/openego/data_processing/blob/master/calc_ego_substation/Voronoi_ehv.sql"
"assumptions":
 [
 {
 "type": "gap"
 "begin": "step_15"
 "end": "step_34"
 "solution": "linear_interpolation"
 } 
 ]
}

@@ Line 351: / Line 351: @@
 <br/>
@@ Line 356: / Line 357: @@
 === Meta Documentation of data collections from several sources: ===
+'''This section is still work in progress! Please contribute to the discussion to improve the implementation.'''
 In addition to the meta documentation described above, data tables (blue table in figure) which include data from several sources get a ref_id column. The ref_id links each row with a json documentation string (ref_data_json) in the database table public.reference_to_entries (green table in figure).This table also includes the ref_data_json column which links to all sources of the row to be referenced (blue). The ref_data_json string includes one jabref_entries_id for each source used. The jabref_entries_id is matched by one entries_id belonging to a source stored in the public.entries table (orange table).
@@ Line 367: / Line 372: @@
 ''<u>reference_to_entries table structure:</u>''<br/>
-{| cellspacing="0" cellpadding="4" style="width: 100%"
+{| style="width: 100%" cellspacing="0" cellpadding="4"
 |- valign="top"
-| style="width: 14%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''ref_id'''</font></font><br/></div>
+| style="width: 14%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''ref_id'''</font></font><br/></div>
-| style="width: 18%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''ref_data_json'''</font></font></div>
+| style="width: 18%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''ref_data_json'''</font></font></div>
-| style="width: 20%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''schema_name'''</font></font></div>
+| style="width: 20%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''schema_name'''</font></font></div>
-| style="width: 15%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''tbl_name'''</font></font></div>
+| style="width: 15%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''tbl_name'''</font></font></div>
-| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''changed_by'''</font></font></div>
+| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''changed_by'''</font></font></div>
-| style="width: 17%;  border: 1px solid #000000;  padding: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''lastmodified'''</font></font></div>
+| style="width: 17%;  border: 1px solid #000000;  padding: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''lastmodified'''</font></font></div>
 |- valign="top"
-| style="width: 14%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Reference ID</font></font></div>
+| style="width: 14%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Reference ID</font></font></div>
-| style="width: 18%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Json Documentation string</font></font></div>
+| style="width: 18%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Json Documentation string</font></font></div>
-| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Name of the schema which includes the table “tbl_name”</font></font></div>
+| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Name of the schema which includes the table “tbl_name”</font></font></div>
-| style="width: 15%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Name of table with the data to be referenced</font></font></div>
+| style="width: 15%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Name of table with the data to be referenced</font></font></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Name of user changing or creating this reference entry. (Automatic</font></font>default setting)<br/></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Name of user changing or creating this reference entry. (Automatic</font></font>default setting)<br/></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Date of entry modification.&nbsp;(Automatic</font></font> default setting)<br/></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Date of entry modification.&nbsp;(Automatic</font></font> default setting)<br/></div>
 &nbsp;<br/>
@@ Line 390: / Line 395: @@
 ''<u>Json documentation string structure on row:</u>''<br/>
-{| cellspacing="0" cellpadding="4" style="width: 100%"
+{| style="width: 100%" cellspacing="0" cellpadding="4"
 |+ Metadata Documentation of data on rows
 |- valign="top"
-| style="width: 22%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''Attribute (level 1)'''</font></font><br/></div>
+| style="width: 22%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''Attribute (level 1)'''</font></font><br/></div>
-| style="width: 20%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''Attribute (level 2)'''</font></font><br/></div>
+| style="width: 20%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''Attribute (level 2)'''</font></font><br/></div>
-| style="width: 19%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''Attribute (level 3)'''</font></font></div>
+| style="width: 19%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''Attribute (level 3)'''</font></font></div>
-| style="width: 39%;  border: 1px solid #000000;  padding: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''Description'''</font></font></div>
+| style="width: 39%;  border: 1px solid #000000;  padding: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''Description'''</font></font></div>
 |- valign="top"
-| style="height: 15px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Name</font></font></div>
+| style="height: 15px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Name</font></font></div>
 | style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"></div>
 | style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Name of the table to be referenced</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Name of the table to be referenced</font></font></div>
 |- valign="top"
-| style="height: 15px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Discription</font></font></div>
+| style="height: 15px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Discription</font></font></div>
 | style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"></div>
 | style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Short description of the table</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Short description of the table</font></font></div>
 |- valign="top"
-| style="height: 15px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt"><span style="background: transparent">Column</span></font></font></div>
+| style="height: 15px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2"><span style="background: transparent">Column</span></font></font></div>
 | style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div class="western"></div>
 | style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Columns which need to be referenced</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Columns which need to be referenced</font></font></div>
 |- valign="top"
 | style="height: 15px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" rowspan="6" | <div style="text-align: center" class="western"></div>
-| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">&lt;column name 1&gt;</font></font></div>
+| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">&lt;column name 1&gt;</font></font></div>
 | style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Column name 1, (original column name and spelling)</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Column name 1, (original column name and spelling)</font></font></div>
 |- valign="top"
 | style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" rowspan="2" | <div style="text-align: center" class="western"></div>
-| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">jabref_entries_id</font></font></div>
+| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">jabref_entries_id</font></font></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Jabref entries id of Literature entry</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Jabref entries id of Literature entry</font></font></div>
 |- valign="top"
-| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Description</font></font></div>
+| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Description</font></font></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Short description</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Short description</font></font></div>
 |- valign="top"
-| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt"><</font></font><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">column</font></font><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">name</font></font><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">2</font></font><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">></font></font></div>
+| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2"><</font></font><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">column</font></font><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">name</font></font><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">2</font></font><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">></font></font></div>
 | style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Column name 2, (original column name and spelling)</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Column name 2, (original column name and spelling)</font></font></div>
 |- valign="top"
 | style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" rowspan="2" | <div style="text-align: center" class="western"></div>
-| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">jabref_entries_id</font></font></div>
+| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">jabref_entries_id</font></font></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Jabref entries id of Literature entry</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Jabref entries id of Literature entry</font></font></div>
 |- valign="top"
-| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Description</font></font></div>
+| style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Description</font></font></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Short description</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Short description</font></font></div>
 |- valign="top"
-| style="height: 14px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Note</font></font></div>
+| style="height: 14px;  width: 22%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: left" class="western"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Note</font></font></div>
 | style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: left" class="western"></div>
 | style="width: 19%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
-| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">Note or comment to this entry</font></font></div>
+| style="width: 39%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">Note or comment to this entry</font></font></div>
 |}
@@ Line 450: / Line 455: @@
 '''Database table: '''ref_test.parameter_electrical_power_plant
-{| cellspacing="0" cellpadding="4" style="width: 100%"
+{| style="width: 100%" cellspacing="0" cellpadding="4"
 |- valign="top"
-| style="width: 8%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">fuel</font></font></div>
+| style="width: 8%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">fuel</font></font></div>
-| style="width: 25%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">type_of_generation</font></font></div>
+| style="width: 25%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">type_of_generation</font></font></div>
-| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">effnetto_el</font></font></div>
+| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">effnetto_el</font></font></div>
-| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">...</font></font></div>
+| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">...</font></font></div>
-| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">opex_var</font></font></div>
+| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">opex_var</font></font></div>
-| style="width: 17%;  border: 1px solid #000000;  padding: 0.1cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">ref_id</font></font></div>
+| style="width: 17%;  border: 1px solid #000000;  padding: 0.1cm" | <div style="text-align: justify"><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">ref_id</font></font></div>
 |- valign="top"
-| style="width: 8%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">coal</font></font></div>
+| style="width: 8%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">coal</font></font></div>
-| style="width: 25%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">st</font></font></div>
+| style="width: 25%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">st</font></font></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''0.35'''</font></font></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''0.35'''</font></font></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">...</font></font></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">...</font></font></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''2'''</font></font></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''2'''</font></font></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">1</font></font></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">1</font></font></div>
 |- valign="top"
-| style="width: 8%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">...</font></font></div>
+| style="width: 8%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">...</font></font></div>
 | style="width: 25%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
 | style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><br/></div>
@@ Line 478: / Line 483: @@
 '''''Database table: '''<u>reference_to_entries table structure:</u>''
-{| cellspacing="0" cellpadding="4" style="width: 100%"
+{| style="width: 100%" cellspacing="0" cellpadding="4"
 |- valign="top"
-| style="width: 14%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''ref_id'''</font></font></div>
+| style="width: 14%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''ref_id'''</font></font></div>
-| style="width: 18%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''ref_data_json'''</font></font></div>
+| style="width: 18%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''ref_data_json'''</font></font></div>
-| style="width: 20%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''schema_name'''</font></font></div>
+| style="width: 20%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''schema_name'''</font></font></div>
-| style="width: 15%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''tbl_name'''</font></font></div>
+| style="width: 15%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''tbl_name'''</font></font></div>
-| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''changed_by'''</font></font></div>
+| style="width: 17%;  border-top: 1px solid #000000;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0.1cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''changed_by'''</font></font></div>
-| style="width: 17%;  border: 1px solid #000000;  padding: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">'''lastmodified'''</font></font></div>
+| style="width: 17%;  border: 1px solid #000000;  padding: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">'''lastmodified'''</font></font></div>
 |- valign="top"
-| style="width: 14%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">1</font></font></div>
+| style="width: 14%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">1</font></font></div>
-| style="width: 18%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="margin-bottom: 0cm"><font face="Arial, sans-serif"><font size="1" style="font-size: 8pt">{</font></font></div><div style="margin-bottom: 0cm"><font face="Arial, sans-serif"><font size="1" style="font-size: 8pt">"Name": "Collection of electrical power plant parameter",</font></font></div><div><font face="Arial, sans-serif"><font size="1" style="font-size: 8pt">"Discription": "Technical parameter of confentional electrical power plants '''…'''</font></font></div>
+| style="width: 18%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div style="margin-bottom: 0cm"><font face="Arial, sans-serif"><font style="font-size: 8pt" size="1">{</font></font></div><div style="margin-bottom: 0cm"><font face="Arial, sans-serif"><font style="font-size: 8pt" size="1">"Name": "Collection of electrical power plant parameter",</font></font></div><div><font face="Arial, sans-serif"><font style="font-size: 8pt" size="1">"Discription": "Technical parameter of confentional electrical power plants '''…'''</font></font></div>
-| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">ref_test</font></font></div>
+| style="width: 20%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">ref_test</font></font></div>
-| style="width: 15%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">parameter_electrical_power_plant</font></font></div>
+| style="width: 15%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">parameter_electrical_power_plant</font></font></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">user_1</font></font></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: none;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">user_1</font></font></div>
-| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font size="2" style="font-size: 10pt">2016-03-17 15:37:24.538213</font></font></div>
+| style="width: 17%;  border-top: none;  border-bottom: 1px solid #000000;  border-left: 1px solid #000000;  border-right: 1px solid #000000;  padding-top: 0cm;  padding-bottom: 0.1cm;  padding-left: 0.1cm;  padding-right: 0.1cm" | <div><font face="Arial, sans-serif"><font style="font-size: 10pt" size="2">2016-03-17 15:37:24.538213</font></font></div>
 |}
 <u>'''Json'''</u>''<u><span style="font-weight: normal"></span></u>''<u>'''Example:'''</u>
-{| cellspacing="0" cellpadding="0" border="0" style="width: 100%"
+{| style="width: 100%" cellspacing="0" cellpadding="0" border="0"
 |-
 |

About

Help

Search

Navigation

Search

Interaction

Toolbox

Namespaces

Variants

Views

Actions

DatabaseRules

Revision as of 08:10, 10 October 2016

Contents

Data Documentation

Naming of Data

Database Name

Database Schema

Database Table

Data Integrity

General

Geografic Data

Data Referencing

Comments on Schema

Comments on Tables

Meta Documentation of Tables

Meta Documentation of data collections from several sources:

Comments on Rows

Log in / create account

About

Help

Search

Navigation

Search

Interaction

Toolbox

Namespaces

Variants

Views

Actions

DatabaseRules

Revision as of 08:10, 10 October 2016

Contents

Data Documentation

Naming of Data

Database Name

Database Schema

Database Table

Data Integrity

General

Geografic Data

Data Referencing

Comments on Schema

Comments on Tables

Meta Documentation of Tables

Meta Documentation of data collections from several sources:

Comments on Rows