Context Navigation

OKB.dbml @ 17982

Visit:

Last change on this file since 17982 was 17059, checked in by mkommend, 5 years ago
#2839: Merged 16117, 16122, 16173, 16184, 16185, 16186, 16187, 16202, 16203, 16204, 16205, 16208, 16211, 16209, 16211, 16219, 16257, 16247 into stable.
File size: 16.0 KB

Line
1	<?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.OKB" EntityNamespace="HeuristicLab.Services.OKB.DataAccess" ContextNamespace="HeuristicLab.Services.OKB.DataAccess" Class="OKBDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
2	<Connection Mode="AppSettings" ConnectionString="Data Source=localhost;Integrated Security=SSPI;Initial Catalog=HeuristicLab.OKB" SettingsObjectName="HeuristicLab.Services.OKB.DataAccess.Properties.Settings" SettingsPropertyName="OKBConnectionString" Provider="System.Data.SqlClient" />
3	<Table Name="dbo.AlgorithmClass" Member="AlgorithmClasses">
4	<Type Name="AlgorithmClass">
5	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
6	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
7	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
8	<Association Name="AlgorithmClass_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="AlgorithmClassId" Type="Algorithm" />
9	</Type>
10	</Table>
11	<Table Name="dbo.ProblemClass" Member="ProblemClasses">
12	<Type Name="ProblemClass">
13	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
14	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
15	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
16	<Association Name="ProblemClass_Problem" Member="Problems" ThisKey="Id" OtherKey="ProblemClassId" Type="Problem" />
17	</Type>
18	</Table>
19	<Table Name="dbo.AlgorithmUser" Member="AlgorithmUsers">
20	<Type Name="AlgorithmUser">
21	<Column Name="AlgorithmId" Type="System.Int64" DbType="BigInt NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
22	<Column Name="UserGroupId" Storage="_UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
23	<Association Name="Algorithm_AlgorithmUser" Member="Algorithm" ThisKey="AlgorithmId" OtherKey="Id" Type="Algorithm" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
24	</Type>
25	</Table>
26	<Table Name="dbo.ProblemUser" Member="ProblemUsers">
27	<Type Name="ProblemUser">
28	<Column Name="ProblemId" Type="System.Int64" DbType="BigInt NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
29	<Column Name="UserGroupId" Storage="_UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
30	<Association Name="Problem_ProblemUser" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
31	</Type>
32	</Table>
33	<Table Name="dbo.Platform" Member="Platforms">
34	<Type Name="Platform">
35	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
36	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
37	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
38	<Association Name="Platform_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="PlatformId" Type="Algorithm" />
39	<Association Name="Platform_Problem" Member="Problems" ThisKey="Id" OtherKey="PlatformId" Type="Problem" />
40	</Type>
41	</Table>
42	<Table Name="dbo.DataType" Member="DataTypes">
43	<Type Name="DataType">
44	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
45	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
46	<Column Name="TypeName" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
47	<Association Name="DataType_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="DataTypeId" Type="Algorithm" />
48	<Association Name="DataType_Problem" Member="Problems" ThisKey="Id" OtherKey="DataTypeId" Type="Problem" />
49	<Association Name="DataType_Value" Member="Values" ThisKey="Id" OtherKey="DataTypeId" Type="Value" />
50	<Association Name="DataType_CharacteristicValue" Member="CharacteristicValues" ThisKey="Id" OtherKey="DataTypeId" Type="CharacteristicValue" />
51	<Association Name="DataType_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="DataTypeId" Type="SingleObjectiveSolution" />
52	</Type>
53	</Table>
54	<Table Name="dbo.ValueName" Member="ValueNames">
55	<Type Name="ValueName">
56	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
57	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
58	<Column Name="Category" Type="ValueNameCategory" DbType="TinyInt NOT NULL" CanBeNull="false" />
59	<Column Name="Type" Type="ValueNameType" DbType="TinyInt NOT NULL" CanBeNull="false" />
60	<Association Name="ValueName_Value" Member="Values" ThisKey="Id" OtherKey="ValueNameId" Type="Value" />
61	</Type>
62	</Table>
63	<Table Name="dbo.Algorithm" Member="Algorithms">
64	<Type Name="Algorithm">
65	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
66	<Column Name="AlgorithmClassId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
67	<Column Name="PlatformId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
68	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
69	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
70	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
71	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
72	<Association Name="Algorithm_AlgorithmUser" Member="AlgorithmUsers" ThisKey="Id" OtherKey="AlgorithmId" Type="AlgorithmUser" />
73	<Association Name="Algorithm_Run" Member="Runs" ThisKey="Id" OtherKey="AlgorithmId" Type="Run" />
74	<Association Name="AlgorithmClass_Algorithm" Member="AlgorithmClass" ThisKey="AlgorithmClassId" OtherKey="Id" Type="AlgorithmClass" IsForeignKey="true" />
75	<Association Name="DataType_Algorithm" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
76	<Association Name="Platform_Algorithm" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
77	<Association Name="BinaryData_Algorithm" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
78	</Type>
79	</Table>
80	<Table Name="dbo.Problem" Member="Problems">
81	<Type Name="Problem">
82	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
83	<Column Name="ProblemClassId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
84	<Column Name="PlatformId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
85	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
86	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
87	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
88	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
89	<Association Name="Problem_ProblemUser" Member="ProblemUsers" ThisKey="Id" OtherKey="ProblemId" Type="ProblemUser" />
90	<Association Name="Problem_Run" Member="Runs" ThisKey="Id" OtherKey="ProblemId" Type="Run" />
91	<Association Name="Problem_CharacteristicValue" Member="CharacteristicValues" ThisKey="Id" OtherKey="ProblemId" Type="CharacteristicValue" />
92	<Association Name="Problem_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="ProblemId" Type="SingleObjectiveSolution" />
93	<Association Name="DataType_Problem" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
94	<Association Name="Platform_Problem" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
95	<Association Name="ProblemClass_Problem" Member="ProblemClass" ThisKey="ProblemClassId" OtherKey="Id" Type="ProblemClass" IsForeignKey="true" />
96	<Association Name="BinaryData_Problem" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
97	</Type>
98	</Table>
99	<Table Name="dbo.BinaryData" Member="BinaryDatas">
100	<Type Name="BinaryData">
101	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
102	<Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
103	<Column Name="Hash" Type="System.Byte[]" DbType="VarBinary(20) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
104	<Association Name="BinaryData_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="BinaryDataId" Type="Algorithm" />
105	<Association Name="BinaryData_Problem" Member="Problems" ThisKey="Id" OtherKey="BinaryDataId" Type="Problem" />
106	<Association Name="BinaryData_Value" Member="Values" ThisKey="Id" OtherKey="BinaryDataId" Type="Value" />
107	<Association Name="BinaryData_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="BinaryDataId" Type="SingleObjectiveSolution" />
108	</Type>
109	</Table>
110	<Table Name="dbo.Run" Member="Runs">
111	<Type Name="Run">
112	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
113	<Column Name="AlgorithmId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
114	<Column Name="ProblemId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
115	<Column Name="CreatedDate" Type="System.DateTime" DbType="DateTime2 NOT NULL" CanBeNull="false" />
116	<Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
117	<Column Name="ClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
118	<Association Name="Run_Value" Member="Values" ThisKey="Id" OtherKey="RunId" Type="Value" />
119	<Association Name="Run_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="RunId" Type="SingleObjectiveSolution" />
120	<Association Name="Algorithm_Run" Member="Algorithm" ThisKey="AlgorithmId" OtherKey="Id" Type="Algorithm" IsForeignKey="true" />
121	<Association Name="Problem_Run" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" />
122	</Type>
123	</Table>
124	<Table Name="dbo.Value" Member="Values">
125	<Type Name="Value">
126	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
127	<Column Name="RunId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
128	<Column Name="ValueNameId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
129	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
130	<Column Name="BoolValue" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
131	<Column Name="IntValue" Type="System.Int32" DbType="Int" CanBeNull="true" />
132	<Column Name="LongValue" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
133	<Column Name="FloatValue" Type="System.Single" DbType="Real" CanBeNull="true" />
134	<Column Name="DoubleValue" Type="System.Double" DbType="Float" CanBeNull="true" />
135	<Column Name="StringValue" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
136	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
137	<Association Name="BinaryData_Value" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
138	<Association Name="DataType_Value" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
139	<Association Name="Run_Value" Member="Run" ThisKey="RunId" OtherKey="Id" Type="Run" IsForeignKey="true" />
140	<Association Name="ValueName_Value" Member="ValueName" ThisKey="ValueNameId" OtherKey="Id" Type="ValueName" IsForeignKey="true" />
141	</Type>
142	</Table>
143	<Table Name="dbo.Characteristic" Member="Characteristics">
144	<Type Name="Characteristic">
145	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
146	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
147	<Column Name="Type" Type="CharacteristicType" DbType="TinyInt NOT NULL" CanBeNull="false" />
148	<Association Name="Characteristic_CharacteristicValue" Member="CharacteristicValues" ThisKey="Id" OtherKey="CharacteristicId" Type="CharacteristicValue" />
149	</Type>
150	</Table>
151	<Table Name="dbo.CharacteristicValue" Member="CharacteristicValues">
152	<Type Name="CharacteristicValue">
153	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
154	<Column Name="ProblemId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
155	<Column Name="CharacteristicId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
156	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
157	<Column Name="BoolValue" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
158	<Column Name="IntValue" Type="System.Int32" DbType="Int" CanBeNull="true" />
159	<Column Name="LongValue" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
160	<Column Name="FloatValue" Type="System.Single" DbType="Real" CanBeNull="true" />
161	<Column Name="DoubleValue" Type="System.Double" DbType="Float" CanBeNull="true" />
162	<Column Name="StringValue" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
163	<Association Name="Characteristic_CharacteristicValue" Member="Characteristic" ThisKey="CharacteristicId" OtherKey="Id" Type="Characteristic" IsForeignKey="true" />
164	<Association Name="DataType_CharacteristicValue" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
165	<Association Name="Problem_CharacteristicValue" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" />
166	</Type>
167	</Table>
168	<Table Name="dbo.SingleObjectiveSolution" Member="SingleObjectiveSolutions">
169	<Type Name="SingleObjectiveSolution">
170	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
171	<Column Name="ProblemId" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
172	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
173	<Column Name="RunId" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
174	<Column Name="Quality" Type="System.Double" DbType="Float" CanBeNull="false" />
175	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt" CanBeNull="true" />
176	<Association Name="Problem_SingleObjectiveSolution" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" />
177	<Association Name="BinaryData_SingleObjectiveSolution" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
178	<Association Name="Run_SingleObjectiveSolution" Member="Run" ThisKey="RunId" OtherKey="Id" Type="Run" IsForeignKey="true" />
179	<Association Name="DataType_SingleObjectiveSolution" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
180	</Type>
181	</Table>
182	</Database>

Note: See TracBrowser for help on using the repository browser.

Download in other formats:

Original Format