Context Navigation

Hive.dbml @ 3188

Visit:

Last change on this file since 3188 was 3022, checked in by kgrading, 15 years ago
added the calendar in the dal and the server console. Works on every Resource (Group / Client) (#908)
File size: 11.9 KB

Rev	Line
[2904]	1	<?xml version="1.0" encoding="utf-8"?>
	2	<Database Name="HeuristicLab.Hive.Linq" Class="HiveDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
	3	<Connection Mode="AppSettings" ConnectionString="Data Source=SEMTEX-PC;Initial Catalog=HeuristicLab.Hive.Linq;Integrated Security=True" SettingsObjectName="HeuristicLab.Hive.Server.LINQDataAccess.Properties.Settings" SettingsPropertyName="HeuristicLab_Hive_LinqConnectionString" Provider="System.Data.SqlClient" />
	4	<Table Name="dbo.AssignedResources" Member="AssignedResources">
	5	<Type Name="AssignedResource">
	6	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	7	<Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	8	<Column Name="AssignedRessourcesId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
[3018]	9	<Association Name="Resource_AssignedResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
[2904]	10	<Association Name="Job_AssignedResource" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
	11	</Type>
	12	</Table>
	13	<Table Name="dbo.UptimeStatistics" Member="UptimeStatistics">
	14	<Type Name="UptimeStatistic">
	15	<Column Name="UptimeStatisticsId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	16	<Column Name="Login" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	17	<Column Name="Logout" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	18	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	19	<Association Name="Client_UptimeStatistic" Member="Client" ThisKey="ResourceId" OtherKey="ResourceId" Type="Client" IsForeignKey="true" DeleteRule="SET NULL" />
	20	</Type>
	21	</Table>
	22	<Table Name="dbo.ClientConfig" Member="ClientConfigs">
	23	<Type Name="ClientConfig">
	24	<Column Name="ClientConfigId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	25	<Column Name="UpDownTimeCalendar" Type="System.Xml.Linq.XElement" DbType="Xml" CanBeNull="true" UpdateCheck="Never" />
	26	<Column Name="HeartBeatIntervall" Type="System.Int32" DbType="Int" CanBeNull="true" />
	27	<Association Name="ClientConfig_Client" Member="Clients" ThisKey="ClientConfigId" OtherKey="ClientConfigId" Type="Client" />
	28	</Type>
	29	</Table>
	30	<Table Name="dbo.ClientGroup" Member="ClientGroups">
	31	<Type Name="ClientGroup">
	32	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
	33	<Association Name="ClientGroup_ClientGroup_Resource" Member="ClientGroup_Resources" ThisKey="ResourceId" OtherKey="ClientGroupId" Type="ClientGroup_Resource" />
	34	<Association Name="Resource_ClientGroup" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
	35	</Type>
	36	</Table>
	37	<Table Name="dbo.ClientGroup_Resource" Member="ClientGroup_Resources">
	38	<Type Name="ClientGroup_Resource">
	39	<Column Name="ClientGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	40	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	41	<Column Name="ClientGroup_RessourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	42	<Association Name="ClientGroup_ClientGroup_Resource" Member="ClientGroup" ThisKey="ClientGroupId" OtherKey="ResourceId" Type="ClientGroup" IsForeignKey="true" />
	43	<Association Name="Resource_ClientGroup_Resource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
	44	</Type>
	45	</Table>
	46	<Table Name="dbo.PluginInfo" Member="PluginInfos">
	47	<Type Name="PluginInfo">
	48	<Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	49	<Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	50	<Column Name="Version" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	51	<Column Name="BuildDate" Type="System.String" DbType="VarChar(20)" CanBeNull="true" />
	52	<Association Name="PluginInfo_RequiredPlugin" Member="RequiredPlugins" ThisKey="PluginId" OtherKey="PluginId" Type="RequiredPlugin" />
	53	</Type>
	54	</Table>
	55	<Table Name="dbo.Project" Member="Projects">
	56	<Type Name="Project">
	57	<Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	58	<Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	59	<Association Name="Project_Job" Member="Jobs" ThisKey="ProjectId" OtherKey="ProjectId" Type="Job" />
	60	</Type>
	61	</Table>
	62	<Table Name="dbo.RequiredPlugins" Member="RequiredPlugins">
	63	<Type Name="RequiredPlugin">
	64	<Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	65	<Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
[3011]	66	<Column Name="RequiredPluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" UpdateCheck="Never" />
[3018]	67	<Association Name="PluginInfo_RequiredPlugin" Member="PluginInfo" ThisKey="PluginId" OtherKey="PluginId" Type="PluginInfo" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
[2904]	68	<Association Name="Job_RequiredPlugin" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
	69	</Type>
	70	</Table>
	71	<Table Name="dbo.Resource" Member="Resources">
	72	<Type Name="Resource">
[3011]	73	<Column Name="ResourceId" AutoSync="OnInsert" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
[2904]	74	<Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	75	<Association Name="Resource_AssignedResource" Member="AssignedResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedResource" />
	76	<Association Name="Resource_ClientGroup" Member="ClientGroup" ThisKey="ResourceId" OtherKey="ResourceId" Type="ClientGroup" Cardinality="One" />
	77	<Association Name="Resource_ClientGroup_Resource" Member="ClientGroup_Resources" ThisKey="ResourceId" OtherKey="ResourceId" Type="ClientGroup_Resource" />
	78	<Association Name="Resource_Client" Member="Client" ThisKey="ResourceId" OtherKey="ResourceId" Type="Client" Cardinality="One" />
[3022]	79	<Association Name="Resource_UptimeCalendar" Member="UptimeCalendars" ThisKey="ResourceId" OtherKey="ResourceId" Type="UptimeCalendar" />
[2904]	80	</Type>
	81	</Table>
	82	<Table Name="dbo.Client" Member="Clients">
	83	<Type Name="Client">
	84	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
	85	<Column Name="CPUSpeed" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	86	<Column Name="Memory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	87	<Column Name="Login" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
	88	<Column Name="Status" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	89	<Column Name="ClientConfigId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	90	<Column Name="NumberOfCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	91	<Column Name="NumberOfFreeCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	92	<Column Name="FreeMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	93	<Association Name="Client_UptimeStatistic" Member="UptimeStatistics" ThisKey="ResourceId" OtherKey="ResourceId" Type="UptimeStatistic" />
	94	<Association Name="Client_Job" Member="Jobs" ThisKey="ResourceId" OtherKey="ResourceId" Type="Job" />
	95	<Association Name="Resource_Client" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
	96	<Association Name="ClientConfig_Client" Member="ClientConfig" ThisKey="ClientConfigId" OtherKey="ClientConfigId" Type="ClientConfig" IsForeignKey="true" DeleteRule="SET NULL" />
	97	</Type>
	98	</Table>
[3018]	99	<Table Name="dbo.Job" Member="Jobs">
	100	<Type Name="Job">
	101	<Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	102	<Column Name="ParentJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	103	<Column Name="JobState" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
	104	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	105	<Column Name="Percentage" Type="System.Double" DbType="Float" CanBeNull="true" />
	106	<Column Name="SerializedJob" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" />
	107	<Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	108	<Column Name="DateCalculated" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	109	<Column Name="DateFinished" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
	110	<Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	111	<Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	112	<Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
	113	<Column Name="CoresNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	114	<Column Name="MemoryNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
	115	<Association Name="Job_AssignedResource" Member="AssignedResources" ThisKey="JobId" OtherKey="JobId" Type="AssignedResource" />
	116	<Association Name="Job_RequiredPlugin" Member="RequiredPlugins" ThisKey="JobId" OtherKey="JobId" Type="RequiredPlugin" />
	117	<Association Name="Job_Job" Member="Jobs" ThisKey="JobId" OtherKey="ParentJobId" Type="Job" />
	118	<Association Name="Client_Job" Member="Client" ThisKey="ResourceId" OtherKey="ResourceId" Type="Client" IsForeignKey="true" DeleteRule="SET NULL" />
	119	<Association Name="Job_Job" Member="Job1" ThisKey="ParentJobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
	120	<Association Name="Project_Job" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" DeleteRule="SET NULL" />
	121	</Type>
	122	</Table>
[3022]	123	<Table Name="dbo.UptimeCalendar" Member="UptimeCalendars">
	124	<Type Name="UptimeCalendar">
	125	<Column Name="UptimeCalendarId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
	126	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
	127	<Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
	128	<Column Name="EndDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
	129	<Column Name="AllDayEvent" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
	130	<Column Name="Recurring" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
	131	<Column Name="RecurringId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
	132	<Association Name="Resource_UptimeCalendar" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
	133	</Type>
	134	</Table>
[2904]	135	</Database>

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

Download in other formats:

Original Format