Free cookie consent management tool by TermsFeed Policy Generator

source: trunk/sources/HeuristicLab.Services.OKB.DataAccess/3.3/OKB.dbml @ 4276

Last change on this file since 4276 was 4276, checked in by swagner, 14 years ago

Integrated OKB data access layer (#1166)
File size: 29.6 KB
Line 
1<?xml version="1.0" encoding="utf-8"?><Database Name="OKB" EntityNamespace="HeuristicLab.Services.OKB.DataAccess" ContextNamespace="HeuristicLab.Services.OKB.DataAccess" Class="OKBDataContext" Serialization="Unidirectional" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
2  <Connection Mode="AppSettings" ConnectionString="Data Source=localhost;Initial Catalog=OKB;Integrated Security=True" SettingsObjectName="HeuristicLab.Services.OKB.DataAccess.Properties.Settings" SettingsPropertyName="OKBConnectionString" Provider="System.Data.SqlClient" />
3  <Table Name="dbo.[User]" Member="Users">
4    <Type Name="User">
5      <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
6      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
7      <Association Name="User_ExperimentCreator" Member="ExperimentCreators" ThisKey="Id" OtherKey="UserId" Type="ExperimentCreator" />
8      <Association Name="User_Run" Member="Runs" ThisKey="Id" OtherKey="UserId" Type="Run" />
9    </Type>
10  </Table>
11  <Table Name="dbo.Algorithm_Parameter" Member="Algorithm_Parameters">
12    <Type Name="Algorithm_Parameter">
13      <Column Name="AlgorithmId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
14      <Column Name="ParameterId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
15      <Association Name="Parameter_Algorithm_Parameter" Member="Parameter" ThisKey="ParameterId" OtherKey="Id" Type="Parameter" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
16      <Association Name="Algorithm_Algorithm_Parameter" Member="Algorithm" ThisKey="AlgorithmId" OtherKey="Id" Type="Algorithm" IsForeignKey="true" />
17    </Type>
18  </Table>
19  <Table Name="dbo.AlgorithmClass" Member="AlgorithmClasses">
20    <Type Name="AlgorithmClass">
21      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
22      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
23      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
24      <Association Name="AlgorithmClass_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="AlgorithmClassId" Type="Algorithm" />
25    </Type>
26  </Table>
27  <Table Name="dbo.AlgorithmData" Member="AlgorithmDatas">
28    <Type Name="AlgorithmData">
29      <Column Name="AlgorithmId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
30      <Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
31      <Association Name="Algorithm_AlgorithmData" Member="Algorithm" ThisKey="AlgorithmId" OtherKey="Id" Type="Algorithm" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
32    </Type>
33  </Table>
34  <Table Name="dbo.BlobResultValue" Member="BlobResultValues">
35    <Type Name="BlobResultValue">
36      <Column Name="ResultId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
37      <Column Name="RunId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
38      <Column Name="Value" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
39      <Association Name="Run_BlobResultValue" Member="Run" ThisKey="RunId" OtherKey="Id" Type="Run" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
40      <Association Name="Result_BlobResultValue" Member="Result" ThisKey="ResultId" OtherKey="Id" Type="Result" IsForeignKey="true" />
41    </Type>
42  </Table>
43  <Table Name="dbo.CharParameterValue" Member="CharParameterValues">
44    <Type Name="CharParameterValue">
45      <Column Name="ParameterId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
46      <Column Name="ExperimentId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
47      <Column Name="Value" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
48      <Association Name="Experiment_CharParameterValue" Member="Experiment" ThisKey="ExperimentId" OtherKey="Id" Type="Experiment" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
49      <Association Name="Parameter_CharParameterValue" Member="Parameter" ThisKey="ParameterId" OtherKey="Id" Type="Parameter" IsForeignKey="true" />
50    </Type>
51  </Table>
52  <Table Name="dbo.CharProblemCharacteristicValue" Member="CharProblemCharacteristicValues">
53    <Type Name="CharProblemCharacteristicValue">
54      <Column Name="ProblemCharacteristicId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
55      <Column Name="ProblemId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
56      <Column Name="Value" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
57      <Association Name="Problem_CharProblemCharacteristicValue" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
58      <Association Name="ProblemCharacteristic_CharProblemCharacteristicValue" Member="ProblemCharacteristic" ThisKey="ProblemCharacteristicId" OtherKey="Id" Type="ProblemCharacteristic" IsForeignKey="true" />
59    </Type>
60  </Table>
61  <Table Name="dbo.CharResultValue" Member="CharResultValues">
62    <Type Name="CharResultValue">
63      <Column Name="ResultId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
64      <Column Name="RunId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
65      <Column Name="Value" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
66      <Association Name="Run_CharResultValue" Member="Run" ThisKey="RunId" OtherKey="Id" Type="Run" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
67      <Association Name="Result_CharResultValue" Member="Result" ThisKey="ResultId" OtherKey="Id" Type="Result" IsForeignKey="true" />
68    </Type>
69  </Table>
70  <Table Name="dbo.Client" Member="Clients">
71    <Type Name="Client">
72      <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
73      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
74      <Association Name="Client_Run" Member="Runs" ThisKey="Id" OtherKey="ClientId" Type="Run" />
75    </Type>
76  </Table>
77  <Table Name="dbo.DataType" Member="DataTypes">
78    <Type Name="DataType">
79      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
80      <Column Name="SqlName" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
81      <Column Name="ClrName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
82      <Association Name="DataType_ProblemCharacteristic" Member="ProblemCharacteristics" ThisKey="Id" OtherKey="DataTypeId" Type="ProblemCharacteristic" />
83      <Association Name="DataType_Result" Member="Results" ThisKey="Id" OtherKey="DataTypeId" Type="Result" />
84      <Association Name="DataType_OperatorParameterValue" Member="OperatorParameterValues" ThisKey="Id" OtherKey="DataTypeId" Type="OperatorParameterValue" />
85      <Association Name="DataType_Parameter" Member="Parameters" ThisKey="Id" OtherKey="DataTypeId" Type="Parameter" />
86    </Type>
87  </Table>
88  <Table Name="dbo.Experiment" Member="Experiments">
89    <Type Name="Experiment">
90      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
91      <Column Name="ProjectId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
92      <Column Name="AlgorithmId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
93      <Column Name="ProblemId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
94      <Association Name="Experiment_CharParameterValue" Member="CharParameterValues" ThisKey="Id" OtherKey="ExperimentId" Type="CharParameterValue" />
95      <Association Name="Experiment_ExperimentCreator" Member="ExperimentCreators" ThisKey="Id" OtherKey="ExperimentId" Type="ExperimentCreator" />
96      <Association Name="Experiment_FloatParameterValue" Member="FloatParameterValues" ThisKey="Id" OtherKey="ExperimentId" Type="FloatParameterValue" />
97      <Association Name="Experiment_IntParameterValue" Member="IntParameterValues" ThisKey="Id" OtherKey="ExperimentId" Type="IntParameterValue" />
98      <Association Name="Experiment_Run" Member="Runs" ThisKey="Id" OtherKey="ExperimentId" Type="Run" />
99      <Association Name="Experiment_OperatorParameterValue" Member="OperatorParameterValues" ThisKey="Id" OtherKey="ExperimentId" Type="OperatorParameterValue" />
100      <Association Name="Problem_Experiment" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
101      <Association Name="Project_Experiment" Member="Project" ThisKey="ProjectId" OtherKey="Id" Type="Project" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
102      <Association Name="Algorithm_Experiment" Member="Algorithm" ThisKey="AlgorithmId" OtherKey="Id" Type="Algorithm" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
103    </Type>
104  </Table>
105  <Table Name="dbo.ExperimentCreator" Member="ExperimentCreators">
106    <Type Name="ExperimentCreator">
107      <Column Name="ExperimentId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
108      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
109      <Association Name="Experiment_ExperimentCreator" Member="Experiment" ThisKey="ExperimentId" OtherKey="Id" Type="Experiment" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
110      <Association Name="User_ExperimentCreator" Member="User" ThisKey="UserId" OtherKey="Id" Type="User" IsForeignKey="true" />
111    </Type>
112  </Table>
113  <Table Name="dbo.FloatParameterValue" Member="FloatParameterValues">
114    <Type Name="FloatParameterValue">
115      <Column Name="ParameterId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
116      <Column Name="ExperimentId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
117      <Column Name="Value" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
118      <Association Name="Experiment_FloatParameterValue" Member="Experiment" ThisKey="ExperimentId" OtherKey="Id" Type="Experiment" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
119      <Association Name="Parameter_FloatParameterValue" Member="Parameter" ThisKey="ParameterId" OtherKey="Id" Type="Parameter" IsForeignKey="true" />
120    </Type>
121  </Table>
122  <Table Name="dbo.FloatProblemCharacteristicValue" Member="FloatProblemCharacteristicValues">
123    <Type Name="FloatProblemCharacteristicValue">
124      <Column Name="ProblemCharacteristicId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
125      <Column Name="ProblemId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
126      <Column Name="Value" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
127      <Association Name="Problem_FloatProblemCharacteristicValue" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
128      <Association Name="ProblemCharacteristic_FloatProblemCharacteristicValue" Member="ProblemCharacteristic" ThisKey="ProblemCharacteristicId" OtherKey="Id" Type="ProblemCharacteristic" IsForeignKey="true" />
129    </Type>
130  </Table>
131  <Table Name="dbo.FloatResultValue" Member="FloatResultValues">
132    <Type Name="FloatResultValue">
133      <Column Name="ResultId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
134      <Column Name="RunId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
135      <Column Name="Value" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
136      <Association Name="Run_FloatResultValue" Member="Run" ThisKey="RunId" OtherKey="Id" Type="Run" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
137      <Association Name="Result_FloatResultValue" Member="Result" ThisKey="ResultId" OtherKey="Id" Type="Result" IsForeignKey="true" />
138    </Type>
139  </Table>
140  <Table Name="dbo.IntParameterValue" Member="IntParameterValues">
141    <Type Name="IntParameterValue">
142      <Column Name="ParameterId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
143      <Column Name="ExperimentId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
144      <Column Name="Value" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
145      <Association Name="Experiment_IntParameterValue" Member="Experiment" ThisKey="ExperimentId" OtherKey="Id" Type="Experiment" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
146      <Association Name="Parameter_IntParameterValue" Member="Parameter" ThisKey="ParameterId" OtherKey="Id" Type="Parameter" IsForeignKey="true" />
147    </Type>
148  </Table>
149  <Table Name="dbo.IntProblemCharacteristicValue" Member="IntProblemCharacteristicValues">
150    <Type Name="IntProblemCharacteristicValue">
151      <Column Name="ProblemCharacteristicId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
152      <Column Name="ProblemId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
153      <Column Name="Value" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
154      <Association Name="Problem_IntProblemCharacteristicValue" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
155      <Association Name="ProblemCharacteristic_IntProblemCharacteristicValue" Member="ProblemCharacteristic" ThisKey="ProblemCharacteristicId" OtherKey="Id" Type="ProblemCharacteristic" IsForeignKey="true" />
156    </Type>
157  </Table>
158  <Table Name="dbo.IntResultValue" Member="IntResultValues">
159    <Type Name="IntResultValue">
160      <Column Name="ResultId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
161      <Column Name="RunId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
162      <Column Name="Value" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
163      <Association Name="Run_IntResultValue" Member="Run" ThisKey="RunId" OtherKey="Id" Type="Run" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
164      <Association Name="Result_IntResultValue" Member="Result" ThisKey="ResultId" OtherKey="Id" Type="Result" IsForeignKey="true" />
165    </Type>
166  </Table>
167  <Table Name="dbo.Platform" Member="Platforms">
168    <Type Name="Platform">
169      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
170      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
171      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
172      <Association Name="Platform_Problem" Member="Problems" ThisKey="Id" OtherKey="PlatformId" Type="Problem" />
173      <Association Name="Platform_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="PlatformId" Type="Algorithm" />
174    </Type>
175  </Table>
176  <Table Name="dbo.Problem" Member="Problems">
177    <Type Name="Problem">
178      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
179      <Column Name="ProblemClassId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
180      <Column Name="PlatformId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
181      <Column Name="SolutionRepresentationId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
182      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
183      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
184      <Association Name="Problem_CharProblemCharacteristicValue" Member="CharProblemCharacteristicValues" ThisKey="Id" OtherKey="ProblemId" Type="CharProblemCharacteristicValue" />
185      <Association Name="Problem_Experiment" Member="Experiments" ThisKey="Id" OtherKey="ProblemId" Type="Experiment" />
186      <Association Name="Problem_FloatProblemCharacteristicValue" Member="FloatProblemCharacteristicValues" ThisKey="Id" OtherKey="ProblemId" Type="FloatProblemCharacteristicValue" />
187      <Association Name="Problem_IntProblemCharacteristicValue" Member="IntProblemCharacteristicValues" ThisKey="Id" OtherKey="ProblemId" Type="IntProblemCharacteristicValue" />
188      <Association Name="Problem_Problem_Parameter" Member="Problem_Parameters" ThisKey="Id" OtherKey="ProblemId" Type="Problem_Parameter" />
189      <Association Name="Problem_ProblemData" Member="ProblemData" ThisKey="Id" OtherKey="ProblemId" Type="ProblemData" Cardinality="One" />
190      <Association Name="Platform_Problem" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
191      <Association Name="ProblemClass_Problem" Member="ProblemClass" ThisKey="ProblemClassId" OtherKey="Id" Type="ProblemClass" IsForeignKey="true" />
192      <Association Name="SolutionRepresentation_Problem" Member="SolutionRepresentation" ThisKey="SolutionRepresentationId" OtherKey="Id" Type="SolutionRepresentation" IsForeignKey="true" />
193    </Type>
194  </Table>
195  <Table Name="dbo.Problem_Parameter" Member="Problem_Parameters">
196    <Type Name="Problem_Parameter">
197      <Column Name="ProblemId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
198      <Column Name="ParameterId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
199      <Association Name="Parameter_Problem_Parameter" Member="Parameter" ThisKey="ParameterId" OtherKey="Id" Type="Parameter" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
200      <Association Name="Problem_Problem_Parameter" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" />
201    </Type>
202  </Table>
203  <Table Name="dbo.ProblemCharacteristic" Member="ProblemCharacteristics">
204    <Type Name="ProblemCharacteristic">
205      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
206      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
207      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
208      <Column Name="DataTypeId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
209      <Association Name="ProblemCharacteristic_CharProblemCharacteristicValue" Member="CharProblemCharacteristicValues" ThisKey="Id" OtherKey="ProblemCharacteristicId" Type="CharProblemCharacteristicValue" />
210      <Association Name="ProblemCharacteristic_FloatProblemCharacteristicValue" Member="FloatProblemCharacteristicValues" ThisKey="Id" OtherKey="ProblemCharacteristicId" Type="FloatProblemCharacteristicValue" />
211      <Association Name="ProblemCharacteristic_IntProblemCharacteristicValue" Member="IntProblemCharacteristicValues" ThisKey="Id" OtherKey="ProblemCharacteristicId" Type="IntProblemCharacteristicValue" />
212      <Association Name="DataType_ProblemCharacteristic" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
213    </Type>
214  </Table>
215  <Table Name="dbo.ProblemClass" Member="ProblemClasses">
216    <Type Name="ProblemClass">
217      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
218      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
219      <Column Name="Description" Type="System.String" DbType="VarChar(100)" CanBeNull="true" />
220      <Association Name="ProblemClass_Problem" Member="Problems" ThisKey="Id" OtherKey="ProblemClassId" Type="Problem" />
221    </Type>
222  </Table>
223  <Table Name="dbo.ProblemData" Member="ProblemDatas">
224    <Type Name="ProblemData">
225      <Column Name="ProblemId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
226      <Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
227      <Association Name="Problem_ProblemData" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
228    </Type>
229  </Table>
230  <Table Name="dbo.Project" Member="Projects">
231    <Type Name="Project">
232      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
233      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
234      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
235      <Association Name="Project_Experiment" Member="Experiments" ThisKey="Id" OtherKey="ProjectId" Type="Experiment" />
236    </Type>
237  </Table>
238  <Table Name="dbo.Run" Member="Runs">
239    <Type Name="Run">
240      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
241      <Column Name="ExperimentId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
242      <Column Name="FinishedDate" Type="System.DateTime" DbType="DateTime2" CanBeNull="true" />
243      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
244      <Column Name="ClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
245      <Association Name="Run_BlobResultValue" Member="BlobResultValues" ThisKey="Id" OtherKey="RunId" Type="BlobResultValue" />
246      <Association Name="Run_CharResultValue" Member="CharResultValues" ThisKey="Id" OtherKey="RunId" Type="CharResultValue" />
247      <Association Name="Run_FloatResultValue" Member="FloatResultValues" ThisKey="Id" OtherKey="RunId" Type="FloatResultValue" />
248      <Association Name="Run_IntResultValue" Member="IntResultValues" ThisKey="Id" OtherKey="RunId" Type="IntResultValue" />
249      <Association Name="Client_Run" Member="Client" ThisKey="ClientId" OtherKey="Id" Type="Client" IsForeignKey="true" />
250      <Association Name="Experiment_Run" Member="Experiment" ThisKey="ExperimentId" OtherKey="Id" Type="Experiment" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
251      <Association Name="User_Run" Member="User" ThisKey="UserId" OtherKey="Id" Type="User" IsForeignKey="true" />
252    </Type>
253  </Table>
254  <Table Name="dbo.SolutionRepresentation" Member="SolutionRepresentations">
255    <Type Name="SolutionRepresentation">
256      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
257      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
258      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
259      <Association Name="SolutionRepresentation_Problem" Member="Problems" ThisKey="Id" OtherKey="SolutionRepresentationId" Type="Problem" />
260    </Type>
261  </Table>
262  <Table Name="dbo.Algorithm" Member="Algorithms">
263    <Type Name="Algorithm">
264      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
265      <Column Name="AlgorithmClassId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
266      <Column Name="PlatformId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
267      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
268      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
269      <Association Name="Algorithm_Algorithm_Parameter" Member="Algorithm_Parameters" ThisKey="Id" OtherKey="AlgorithmId" Type="Algorithm_Parameter" />
270      <Association Name="Algorithm_AlgorithmData" Member="AlgorithmData" ThisKey="Id" OtherKey="AlgorithmId" Type="AlgorithmData" Cardinality="One" />
271      <Association Name="Algorithm_Experiment" Member="Experiments" ThisKey="Id" OtherKey="AlgorithmId" Type="Experiment" />
272      <Association Name="Algorithm_Algorithm_Result" Member="Algorithm_Results" ThisKey="Id" OtherKey="AlgorithmId" Type="Algorithm_Result" />
273      <Association Name="AlgorithmClass_Algorithm" Member="AlgorithmClass" ThisKey="AlgorithmClassId" OtherKey="Id" Type="AlgorithmClass" IsForeignKey="true" />
274      <Association Name="Platform_Algorithm" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
275    </Type>
276  </Table>
277  <Table Name="dbo.Algorithm_Result" Member="Algorithm_Results">
278    <Type Name="Algorithm_Result">
279      <Column Name="AlgorithmId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
280      <Column Name="ResultId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
281      <Association Name="Algorithm_Algorithm_Result" Member="Algorithm" ThisKey="AlgorithmId" OtherKey="Id" Type="Algorithm" IsForeignKey="true" />
282      <Association Name="Result_Algorithm_Result" Member="Result" ThisKey="ResultId" OtherKey="Id" Type="Result" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
283    </Type>
284  </Table>
285  <Table Name="dbo.Result" Member="Results">
286    <Type Name="Result">
287      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
288      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
289      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
290      <Column Name="DataTypeId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
291      <Association Name="Result_BlobResultValue" Member="BlobResultValues" ThisKey="Id" OtherKey="ResultId" Type="BlobResultValue" />
292      <Association Name="Result_CharResultValue" Member="CharResultValues" ThisKey="Id" OtherKey="ResultId" Type="CharResultValue" />
293      <Association Name="Result_FloatResultValue" Member="FloatResultValues" ThisKey="Id" OtherKey="ResultId" Type="FloatResultValue" />
294      <Association Name="Result_IntResultValue" Member="IntResultValues" ThisKey="Id" OtherKey="ResultId" Type="IntResultValue" />
295      <Association Name="Result_Algorithm_Result" Member="Algorithm_Results" ThisKey="Id" OtherKey="ResultId" Type="Algorithm_Result" />
296      <Association Name="DataType_Result" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
297    </Type>
298  </Table>
299  <Table Name="dbo.OperatorParameterValue" Member="OperatorParameterValues">
300    <Type Name="OperatorParameterValue">
301      <Column Name="ParameterId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
302      <Column Name="ExperimentId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
303      <Column Name="Value" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
304      <Column Name="DataTypeId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
305      <Association Name="DataType_OperatorParameterValue" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
306      <Association Name="Experiment_OperatorParameterValue" Member="Experiment" ThisKey="ExperimentId" OtherKey="Id" Type="Experiment" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
307      <Association Name="Parameter_OperatorParameterValue" Member="Parameter" ThisKey="ParameterId" OtherKey="Id" Type="Parameter" IsForeignKey="true" />
308    </Type>
309  </Table>
310  <Table Name="dbo.Parameter" Member="Parameters">
311    <Type Name="Parameter">
312      <Column Name="Id" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
313      <Column Name="Name" Type="System.String" DbType="VarChar(200) NOT NULL" CanBeNull="false" />
314      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
315      <Column Name="DataTypeId" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
316      <Association Name="Parameter_Algorithm_Parameter" Member="Algorithm_Parameters" ThisKey="Id" OtherKey="ParameterId" Type="Algorithm_Parameter" />
317      <Association Name="Parameter_CharParameterValue" Member="CharParameterValues" ThisKey="Id" OtherKey="ParameterId" Type="CharParameterValue" />
318      <Association Name="Parameter_FloatParameterValue" Member="FloatParameterValues" ThisKey="Id" OtherKey="ParameterId" Type="FloatParameterValue" />
319      <Association Name="Parameter_IntParameterValue" Member="IntParameterValues" ThisKey="Id" OtherKey="ParameterId" Type="IntParameterValue" />
320      <Association Name="Parameter_Problem_Parameter" Member="Problem_Parameters" ThisKey="Id" OtherKey="ParameterId" Type="Problem_Parameter" />
321      <Association Name="Parameter_OperatorParameterValue" Member="OperatorParameterValues" ThisKey="Id" OtherKey="ParameterId" Type="OperatorParameterValue" />
322      <Association Name="DataType_Parameter" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
323    </Type>
324  </Table>
325</Database>
Note: See TracBrowser for help on using the repository browser.