   OIDS=FALSE
 );
 
+COMMENT ON TABLE  calc_ego_hv_powerflow.transformer IS
+'{
+"Name": "Transformer in hv powerflow",
+"Source": [{
+                  "Name": "open_eGo data-processing",
+                  "URL":  "https://github.com/openego/data_processing" }],
+"Reference date": "...",
+"Date of collection": "...",
+"Original file": "calc_ego_hv_powerflow.sql",
+"Spatial resolution": ["Germany"],
+"Description": ["Transformer converts from one AC voltage level to another"],
+"Column": [
+                   {"Name": "scn_name",
+                    "Description": "scenario name",
+                    "Unit": "" },
+                   {"Name": "trafo_id",
+                    "Description": "unique id",
+                    "Unit": "" },
+                   {"Name": "bus0",
+                    "Description": "Name of first bus to which branch is attached",
+                    "Unit": "" },
+                   {"Name": "bus1",
+                    "Description": "Name of second bus to which branch is attached",
+                    "Unit": "" },
+                   {"Name": "x",
+                    "Description": "Series reactance",
+                    "Unit": "Ohm" },
+                   {"Name": "r",
+                    "Description": "Series resistance",
+                    "Unit": "Ohm" },
+                   {"Name": "g",
+                    "Description": "Shunt conductivity",
+                    "Unit": "Siemens" }, 
+                   {"Name": "b",
+                    "Description": "Shunt susceptance",
+                    "Unit": "Siemens" }, 
+                   {"Name": "s_nom",
+                    "Description": "Limit of apparent power which can pass through branch",
+                    "Unit": "MVA" }, 
+                   {"Name": "s_nom_extendable",
+                    "Description": "Switch to allow capacity s_nom to be extended",
+                    "Unit": "" }, 
+                   {"Name": "s_nom_min",
+                    "Description": "If s_nom is extendable, set its minimum value",
+                    "Unit": "MVA" }, 
+                   {"Name": "s_nom_max",
+                    "Description": "If s_nom is extendable in OPF, set its maximum value",
+                    "Unit": "MVA" }, 
+                   {"Name": "tap_ratio",
+                    "Description": "Ratio of per unit voltages at each bus",
+                    "Unit": "" },
+                   {"Name": "phase_shift",
+                    "Description": "Voltage phase angle shift",
+                    "Unit": "degrees" },
+                   {"Name": "capital_cost",
+                    "Description": "Capital cost of extending s_nom by 1 MVA",
+                    "Unit": "€/MVA" },
+                   {"Name": "geom",
+                    "Description": "geometry",
+                    "Unit": "" },
+                   {"Name": "topo",
+                    "Description": "topology",
+                    "Unit": "" }],
+"Changes":[
+                   {"Name": "Mario Kropshofer",
+                    "Mail": "mario.kropshofer2@stud.fh-flensburg.de",
+                    "Date":  "04.10.2016",
+                    "Comment": "..." }, 
+
+                   {"Name": "Ilka Cussmann",
+                    "Mail": "ilka.cussmann@hs-flensburg.de",
+                    "Date":  "26.10.2016",
+                    "Comment": "completed json-string" }
+                  ],
+"ToDo": ["Add licence"],
+"Licence": ["..."],
+"Instructions for proper use": ["..."]
+}';
+
+
 --------------------------------------------------------------------
 ---------------------- Time series tables --------------------------
 --------------------------------------------------------------------

  OIDS=FALSE
);



CREATE TABLE calc_ego_hv_powerflow.storage
(

  OIDS=FALSE
);

COMMENT ON TABLE  calc_ego_hv_powerflow.storage_pq_set IS
'{
"Name": "Storage time series hv powerflow",
"Source": [{
                  "Name": "open_eGo data-processing",
                  "URL":  "https://github.com/openego/data_processing" }],
"Reference date": "...",
"Date of collection": "...",
"Original file": "...",
"Spatial resolution": ["Germany"],
"Description": ["Times series for storage units considered in hv powerflow"],
"Column": [
                   {"Name": "scn_name",
                    "Description": "scenario name",
                    "Unit": "" },
                   {"Name": "storage_id",
                    "Description": "unique storage id",
                    "Unit": "" },
                   {"Name": "temp_id",
                    "Description": "id for temporal resolution",
                    "Unit": "" },
                   {"Name": "p_set",
                    "Description": "active power set point",
                    "Unit": "MW" },
                   {"Name": "q_set",
                    "Description": "reactive power set point",
                    "Unit": "MVar" }],
                   {"Name": "p_min_pu",
                    "Description": "If control=”variable” this gives the minimum output for each snapshot per unit of p_nom for the OPF",
                    "Unit": "per unit" },
                   {"Name": "p_max_pu",
                    "Description": "If control=”variable” this gives the maximum output for each snapshot per unit of p_nom for the OPF",
                    "Unit": "per unit" }],
                   {"Name": "soc_set",
                    "Description": "State of charge set points for snapshots in the OPF",
                    "Unit": "MWh" },
                   {"Name": "inflow",
                    "Description": "Inflow to the state of charge, e.g. due to river inflow in hydro reservoir",
                    "Unit": "MW" }],
"Changes":[
                   {"Name": "Mario Kropshofer",
                    "Mail": "mario.kropshofer2@stud.fh-flensburg.de",
                    "Date":  "04.10.2016",
                    "Comment": "..." }, 
                    "Name": "Ilka Cussmann",
                    "Mail": "ilka.cussmann@hs-flensburg.de",
                    "Date":  "26.10.2016",
                    "Comment": "completed json-string" }
                  ],
"ToDo": ["Add licence"],
"Licence": ["..."],
"Instructions for proper use": ["..."]
}';

-------------------------------------------------------------------
--------------------------- Grant rights --------------------------
