Context Navigation

OKB.dbml @ 14534

Visit:

Last change on this file since 14534 was 13682, checked in by abeham, 9 years ago

Added table, FK constraints, and FK indexes to database
Updated Linq2Sql mapping
Added service methods and dtos for downloading

File size: 16.0 KB

Rev	Line
[8049]	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="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" />
[13682]	51	<Association Name="DataType_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="DataTypeId" Type="SingleObjectiveSolution" />
[8049]	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" />
[13682]	92	<Association Name="Problem_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="ProblemId" Type="SingleObjectiveSolution" />
[8049]	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" />
[13682]	107	<Association Name="BinaryData_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="BinaryDataId" Type="SingleObjectiveSolution" />
[8049]	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" />
[13682]	119	<Association Name="Run_SingleObjectiveSolution" Member="SingleObjectiveSolutions" ThisKey="Id" OtherKey="RunId" Type="SingleObjectiveSolution" />
[8049]	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" />
[13501]	147	<Column Name="Type" Type="CharacteristicType" DbType="TinyInt NOT NULL" CanBeNull="false" />
[8049]	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>
[13682]	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>
[8049]	182	</Database>

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

Download in other formats:

Original Format