annotate gnv-artifacts/doc/schema/externalinterface_testdata.sql @ 490:be53566c1640

Added Comments and further Informations to the external Interface Schema gnv-artifacts/trunk@566 c6561f87-3c4e-4783-a992-168aeb5c3f6f
author Tim Englich <tim.englich@intevation.de>
date Mon, 18 Jan 2010 15:14:22 +0000
parents 3784cf498ab7
children 292f0c8d356c
rev   line source
489
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
1 INSERT INTO fis_has_mapservice (id_fis,id_mapservice) VALUES
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
2 ('modeldata','BSH_IMS_Prediction_Model_Salinity'),
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
3 ('marnet','BSH_IMS_Marine_Environment_Monitoring_Network');
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
4
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
5 INSERT INTO mapservice_has_parameter(id_mapservice,id_parameter) VALUES
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
6 ('BSH_IMS_Prediction_Model_Salinity',2);
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
7
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
8 INSERT INTO layer_has_parameter(id_mapservice,id_layer,id_group,id_parameter) VALUES
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
9 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Sealevel', null, ?),
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
10 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Temperature', null, 1),
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
11 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Salinity', null, 2),
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
12 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'OxygenSaturation', null, 31),
3784cf498ab7 Added Database-Schema and Testdata for the MapViewer-Interface
Tim Englich <tim.englich@intevation.de>
parents:
diff changeset
13 ('BSH_IMS_Marine_Environment_Monitoring_Network', 'Current', null, ?);

http://dive4elements.wald.intevation.org