Context Navigation

HiveDataContext.dbml @ 5511

Visit:

Last change on this file since 5511 was 5179, checked in by cneumuel, 14 years ago

migrated to .NET 4.0
moved state-information about heartbeat timestamps into DB to reduce IIS-recycling issues
optimized memory usage of ExperimentManager when lots of large jobs are downloaded

File size: 12.2 KB

Rev	Line
[4423]	1	<?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.Hive" Class="HiveDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
	2	<Table Name="dbo.AssignedResources" Member="AssignedResources">
	3	<Type Name="AssignedResource">
	4	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	5	<Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	6	<Column Name="AssignedRessourcesId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	7	<Association Name="Resource_AssignedResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
	8	<Association Name="Job_AssignedResource" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" DeleteRule="CASCADE" />
	9	</Type>
	10	</Table>
	11	<Table Name="dbo.UptimeStatistics" Member="UptimeStatistics">
	12	<Type Name="UptimeStatistic">
	13	<Column Name="UptimeStatisticsId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	14	<Column Name="Login" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
	15	<Column Name="Logout" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
	16	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
	17	<Association Name="Slave_UptimeStatistic" Member="Slave" ThisKey="ResourceId" OtherKey="ResourceId" Type="Slave" IsForeignKey="true" DeleteRule="SET NULL" />
	18	</Type>
	19	</Table>
	20	<Table Name="dbo.SlaveConfig" Member="SlaveConfigs">
	21	<Type Name="SlaveConfig">
	22	<Column Name="SlaveConfigId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	23	<Column Name="UpDownTimeCalendar" Type="System.Xml.Linq.XElement" DbType="Xml" CanBeNull="false" UpdateCheck="Never" />
	24	<Column Name="HeartBeatIntervall" Type="System.Int32" DbType="Int" CanBeNull="true" />
	25	<Association Name="SlaveConfig_Slave" Member="Slaves" ThisKey="SlaveConfigId" OtherKey="SlaveConfigId" Type="Slave" />
	26	</Type>
	27	</Table>
	28	<Table Name="dbo.SlaveGroup_Resource" Member="SlaveGroup_Resources">
	29	<Type Name="SlaveGroup_Resource">
	30	<Column Name="SlaveGroup_RessourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	31	<Column Name="SlaveGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	32	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	33	<Association Name="SlaveGroup_SlaveGroup_Resource" Member="SlaveGroup" ThisKey="SlaveGroupId" OtherKey="ResourceId" Type="SlaveGroup" IsForeignKey="true" />
	34	<Association Name="Resource_SlaveGroup_Resource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
	35	</Type>
	36	</Table>
	37	<Table Name="dbo.PluginInfo" Member="PluginInfos">
	38	<Type Name="PluginInfo">
	39	<Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	40	<Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
	41	<Column Name="Version" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
	42	<Column Name="BuildDate" Type="System.String" DbType="VarChar(20)" CanBeNull="false" />
	43	<Association Name="PluginInfo_RequiredPlugin" Member="RequiredPlugins" ThisKey="PluginId" OtherKey="PluginId" Type="RequiredPlugin" />
	44	</Type>
	45	</Table>
	46	<Table Name="dbo.Project" Member="Projects">
	47	<Type Name="Project">
	48	<Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	49	<Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
	50	<Association Name="Project_Job" Member="Jobs" ThisKey="ProjectId" OtherKey="ProjectId" Type="Job" />
	51	</Type>
	52	</Table>
	53	<Table Name="dbo.RequiredPlugins" Member="RequiredPlugins">
	54	<Type Name="RequiredPlugin">
	55	<Column Name="RequiredPluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" UpdateCheck="Never" />
	56	<Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	57	<Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	58	<Association Name="PluginInfo_RequiredPlugin" Member="PluginInfo" ThisKey="PluginId" OtherKey="PluginId" Type="PluginInfo" IsForeignKey="true" DeleteRule="CASCADE" />
	59	<Association Name="Job_RequiredPlugin" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
	60	</Type>
	61	</Table>
	62	<Table Name="dbo.Resource" Member="Resources">
	63	<Type Name="Resource" InheritanceCode="RESOURCE">
	64	<Column Name="ResourceId" AutoSync="OnInsert" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
	65	<Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
	66	<Column Name="ResourceType" Type="System.String" CanBeNull="false" IsDiscriminator="true" />
	67	<Association Name="Resource_AssignedResource" Member="AssignedResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedResource" />
	68	<Association Name="Resource_SlaveGroup_Resource" Member="SlaveGroup_Resources_Parents" ThisKey="ResourceId" OtherKey="ResourceId" Type="SlaveGroup_Resource" />
	69	<Association Name="Resource_UptimeCalendar" Member="UptimeCalendars" ThisKey="ResourceId" OtherKey="ResourceId" Type="UptimeCalendar" />
	70	<Type Name="Slave" InheritanceCode="Slave" IsInheritanceDefault="true">
	71	<Column Name="CPUSpeed" Type="System.Int32" DbType="Int" CanBeNull="true" />
	72	<Column Name="Memory" Type="System.Int32" DbType="Int" CanBeNull="true" />
	73	<Column Name="Login" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	74	<Column Name="Status" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	75	<Column Name="CalendarSyncStatus" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	76	<Column Name="UseCalendarFromResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	77	<Column Name="SlaveConfigId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	78	<Column Name="NumberOfCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
	79	<Column Name="NumberOfFreeCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
	80	<Column Name="FreeMemory" Type="System.Int32" DbType="Int" CanBeNull="true" />
	81	<Column Name="IsAllowedToCalculate" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
[5179]	82	<Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
[4423]	83	<Association Name="Slave_UptimeStatistic" Member="UptimeStatistics" ThisKey="ResourceId" OtherKey="ResourceId" Type="UptimeStatistic" />
	84	<Association Name="Slave_Job" Member="Jobs" ThisKey="ResourceId" OtherKey="ResourceId" Type="Job" />
	85	<Association Name="SlaveConfig_Slave" Member="SlaveConfig" ThisKey="SlaveConfigId" OtherKey="SlaveConfigId" Type="SlaveConfig" IsForeignKey="true" DeleteRule="SET NULL" />
	86	</Type>
	87	<Type Name="SlaveGroup" InheritanceCode="GROUP">
	88	<Association Name="SlaveGroup_SlaveGroup_Resource" Member="SlaveGroup_Resources_Children" ThisKey="ResourceId" OtherKey="SlaveGroupId" Type="SlaveGroup_Resource" />
	89	</Type>
	90	</Type>
	91	</Table>
	92	<Table Name="dbo.Job" Member="Jobs">
	93	<Type Name="Job">
	94	<Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	95	<Column Name="ParentJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	96	<Column Name="JobState" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
	97	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
[5037]	98	<Column Name="ExecutionTime" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
[4423]	99	<Column Name="Exception" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	100	<Column Name="SerializedJob" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="false" UpdateCheck="Never" IsDelayLoaded="true" />
	101	<Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	102	<Column Name="DateCalculated" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	103	<Column Name="DateFinished" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	104	<Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	105	<Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	106	<Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
	107	<Column Name="CoresNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	108	<Column Name="MemoryNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
[5179]	109	<Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
[4423]	110	<Association Name="Job_AssignedResource" Member="AssignedResources" ThisKey="JobId" OtherKey="JobId" Type="AssignedResource" />
	111	<Association Name="Job_RequiredPlugin" Member="RequiredPlugins" ThisKey="JobId" OtherKey="JobId" Type="RequiredPlugin" />
	112	<Association Name="Job_Job" Member="Jobs" ThisKey="JobId" OtherKey="ParentJobId" Type="Job" />
	113	<Association Name="Job_Job" Member="Job1" ThisKey="ParentJobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
	114	<Association Name="Project_Job" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" DeleteRule="SET NULL" />
	115	<Association Name="Slave_Job" Member="Slave" ThisKey="ResourceId" OtherKey="ResourceId" Type="Slave" IsForeignKey="true" DeleteRule="SET NULL" />
	116	</Type>
	117	</Table>
	118	<Table Name="dbo.UptimeCalendar" Member="UptimeCalendars">
	119	<Type Name="UptimeCalendar">
	120	<Column Name="UptimeCalendarId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	121	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	122	<Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
	123	<Column Name="EndDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
	124	<Column Name="AllDayEvent" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
	125	<Column Name="Recurring" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
	126	<Column Name="RecurringId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
	127	<Association Name="Resource_UptimeCalendar" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
	128	</Type>
	129	</Table>
	130	<Table Name="dbo.HiveExperiment" Member="HiveExperiments">
	131	<Type Name="HiveExperiment">
	132	<Column Name="HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	133	<Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
	134	<Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	135	<Column Name="ResourceIds" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	136	<Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
	137	<Column Name="RootJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	138	<Association Name="Job_HiveExperiment" Member="RootJob" Storage="_Job" ThisKey="RootJobId" OtherKey="JobId" Type="Job" IsForeignKey="true" DeleteRule="CASCADE" />
	139	</Type>
	140	</Table>
	141	</Database>

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

Download in other formats:

Original Format