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> |
---|