Context Navigation

OKB.dbml @ 5477

Visit:

Last change on this file since 5477 was 5397, checked in by swagner, 14 years ago
Worked on OKB (#1174)
File size: 14.5 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=.\SQLEXPRESS;Initial Catalog=HeuristicLab.OKB;Integrated Security=True" 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="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="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_DataType" Member="DataTypes" ThisKey="Id" OtherKey="PlatformId" Type="DataType" />
39	<Association Name="Platform_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="PlatformId" Type="Algorithm" />
40	<Association Name="Platform_Problem" Member="Problems" ThisKey="Id" OtherKey="PlatformId" Type="Problem" />
41	</Type>
42	</Table>
43	<Table Name="dbo.DataType" Member="DataTypes">
44	<Type Name="DataType">
45	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
46	<Column Name="PlatformId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
47	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
48	<Column Name="TypeName" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
49	<Association Name="DataType_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="DataTypeId" Type="Algorithm" />
50	<Association Name="DataType_Problem" Member="Problems" ThisKey="Id" OtherKey="DataTypeId" Type="Problem" />
51	<Association Name="DataType_Value" Member="Values" ThisKey="Id" OtherKey="DataTypeId" Type="Value" />
52	<Association Name="DataType_CharacteristicValue" Member="CharacteristicValues" ThisKey="Id" OtherKey="DataTypeId" Type="CharacteristicValue" />
53	<Association Name="Platform_DataType" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
54	</Type>
55	</Table>
56	<Table Name="dbo.ValueName" Member="ValueNames">
57	<Type Name="ValueName">
58	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
59	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
60	<Column Name="Category" Type="ValueNameCategory" DbType="TinyInt NOT NULL" CanBeNull="false" />
61	<Column Name="Type" Type="ValueNameType" DbType="TinyInt NOT NULL" CanBeNull="false" />
62	<Association Name="ValueName_Value" Member="Values" ThisKey="Id" OtherKey="ValueNameId" Type="Value" />
63	</Type>
64	</Table>
65	<Table Name="dbo.Algorithm" Member="Algorithms">
66	<Type Name="Algorithm">
67	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
68	<Column Name="AlgorithmClassId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
69	<Column Name="PlatformId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
70	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
71	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
72	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
73	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
74	<Association Name="Algorithm_AlgorithmUser" Member="AlgorithmUsers" ThisKey="Id" OtherKey="AlgorithmId" Type="AlgorithmUser" />
75	<Association Name="Algorithm_Run" Member="Runs" ThisKey="Id" OtherKey="AlgorithmId" Type="Run" />
76	<Association Name="AlgorithmClass_Algorithm" Member="AlgorithmClass" ThisKey="AlgorithmClassId" OtherKey="Id" Type="AlgorithmClass" IsForeignKey="true" />
77	<Association Name="DataType_Algorithm" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
78	<Association Name="Platform_Algorithm" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
79	<Association Name="BinaryData_Algorithm" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
80	</Type>
81	</Table>
82	<Table Name="dbo.Problem" Member="Problems">
83	<Type Name="Problem">
84	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
85	<Column Name="ProblemClassId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
86	<Column Name="PlatformId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
87	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
88	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
89	<Column Name="Name" Type="System.String" DbType="NVarChar(200) NOT NULL" CanBeNull="false" />
90	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
91	<Association Name="Problem_ProblemUser" Member="ProblemUsers" ThisKey="Id" OtherKey="ProblemId" Type="ProblemUser" />
92	<Association Name="Problem_Run" Member="Runs" ThisKey="Id" OtherKey="ProblemId" Type="Run" />
93	<Association Name="Problem_CharacteristicValue" Member="CharacteristicValues" ThisKey="Id" OtherKey="ProblemId" Type="CharacteristicValue" />
94	<Association Name="DataType_Problem" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
95	<Association Name="Platform_Problem" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
96	<Association Name="ProblemClass_Problem" Member="ProblemClass" ThisKey="ProblemClassId" OtherKey="Id" Type="ProblemClass" IsForeignKey="true" />
97	<Association Name="BinaryData_Problem" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
98	</Type>
99	</Table>
100	<Table Name="dbo.BinaryData" Member="BinaryDatas">
101	<Type Name="BinaryData">
102	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
103	<Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
104	<Column Name="Hash" Type="System.Data.Linq.Binary" DbType="VarBinary(20)" IsDbGenerated="true" CanBeNull="true" UpdateCheck="Never" />
105	<Association Name="BinaryData_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="BinaryDataId" Type="Algorithm" />
106	<Association Name="BinaryData_Problem" Member="Problems" ThisKey="Id" OtherKey="BinaryDataId" Type="Problem" />
107	<Association Name="BinaryData_Value" Member="Values" ThisKey="Id" OtherKey="BinaryDataId" Type="Value" />
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="RandomSeed" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
116	<Column Name="CreatedDate" Type="System.DateTime" DbType="DateTime2 NOT NULL" CanBeNull="false" />
117	<Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
118	<Column Name="ClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
119	<Association Name="Run_Value" Member="Values" ThisKey="Id" OtherKey="RunId" Type="Value" />
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="System.Byte" 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	</Database>

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

Download in other formats:

Original Format