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

Rev	Line
[4455]	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">
[4381]	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" />
[4276]	3	<Table Name="dbo.AlgorithmClass" Member="AlgorithmClasses">
	4	<Type Name="AlgorithmClass">
[4381]	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" />
[4276]	8	<Association Name="AlgorithmClass_Algorithm" Member="Algorithms" ThisKey="Id" OtherKey="AlgorithmClassId" Type="Algorithm" />
	9	</Type>
	10	</Table>
[4381]	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" />
[4276]	17	</Type>
	18	</Table>
[4381]	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" />
[5360]	23	<Association Name="Algorithm_AlgorithmUser" Member="Algorithm" ThisKey="AlgorithmId" OtherKey="Id" Type="Algorithm" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
[4276]	24	</Type>
	25	</Table>
[4381]	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" />
[5360]	30	<Association Name="Problem_ProblemUser" Member="Problem" ThisKey="ProblemId" OtherKey="Id" Type="Problem" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
[4381]	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" />
[5378]	38	<Association Name="Platform_DataType" Member="DataTypes" ThisKey="Id" OtherKey="PlatformId" Type="DataType" />
[4381]	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>
[5378]	43	<Table Name="dbo.DataType" Member="DataTypes">
	44	<Type Name="DataType">
[4381]	45	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
[5378]	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" />
[5397]	52	<Association Name="DataType_CharacteristicValue" Member="CharacteristicValues" ThisKey="Id" OtherKey="DataTypeId" Type="CharacteristicValue" />
[5378]	53	<Association Name="Platform_DataType" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
[4276]	54	</Type>
	55	</Table>
[5378]	56	<Table Name="dbo.ValueName" Member="ValueNames">
	57	<Type Name="ValueName">
[4381]	58	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
[5378]	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" />
[4276]	63	</Type>
	64	</Table>
[5360]	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" />
[4407]	70	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
[5378]	71	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
[5360]	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" />
[5378]	75	<Association Name="Algorithm_Run" Member="Runs" ThisKey="Id" OtherKey="AlgorithmId" Type="Run" />
[5360]	76	<Association Name="AlgorithmClass_Algorithm" Member="AlgorithmClass" ThisKey="AlgorithmClassId" OtherKey="Id" Type="AlgorithmClass" IsForeignKey="true" />
[5378]	77	<Association Name="DataType_Algorithm" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
[5360]	78	<Association Name="Platform_Algorithm" Member="Platform" ThisKey="PlatformId" OtherKey="Id" Type="Platform" IsForeignKey="true" />
[5378]	79	<Association Name="BinaryData_Algorithm" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
[4407]	80	</Type>
	81	</Table>
[5360]	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" />
[4407]	87	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
[5378]	88	<Column Name="BinaryDataId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
[5360]	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" />
[5378]	92	<Association Name="Problem_Run" Member="Runs" ThisKey="Id" OtherKey="ProblemId" Type="Run" />
[5397]	93	<Association Name="Problem_CharacteristicValue" Member="CharacteristicValues" ThisKey="Id" OtherKey="ProblemId" Type="CharacteristicValue" />
[5378]	94	<Association Name="DataType_Problem" Member="DataType" ThisKey="DataTypeId" OtherKey="Id" Type="DataType" IsForeignKey="true" />
[5360]	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" />
[5378]	97	<Association Name="BinaryData_Problem" Member="BinaryData" ThisKey="BinaryDataId" OtherKey="Id" Type="BinaryData" IsForeignKey="true" />
[4407]	98	</Type>
	99	</Table>
[5378]	100	<Table Name="dbo.BinaryData" Member="BinaryDatas">
	101	<Type Name="BinaryData">
[5360]	102	<Column Name="Id" Type="System.Int64" DbType="BigInt NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
[5378]	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" />
[5360]	127	<Column Name="RunId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
[5378]	128	<Column Name="ValueNameId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
[4407]	129	<Column Name="DataTypeId" Type="System.Int64" DbType="BigInt NOT NULL" CanBeNull="false" />
[5360]	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" />
[5378]	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" />
[4407]	141	</Type>
	142	</Table>
[5397]	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>
[4276]	168	</Database>

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

Download in other formats:

Original Format