| 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" />
|
|---|
| 9 | <Association Name="Resource_AssignedResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 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" />
|
|---|
| 66 | <Column Name="RequiredPluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 67 | <Association Name="PluginInfo_RequiredPlugin" Member="PluginInfo" ThisKey="PluginId" OtherKey="PluginId" Type="PluginInfo" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 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">
|
|---|
| 73 | <Column Name="ResourceId" AutoSync="OnInsert" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 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_UptimeCalendar" Member="UptimeCalendars" ThisKey="ResourceId" OtherKey="ResourceId" Type="UptimeCalendar" />
|
|---|
| 79 | <Association Name="Resource_Client" Member="Client" ThisKey="ResourceId" OtherKey="ResourceId" Type="Client" Cardinality="One" />
|
|---|
| 80 | <Association Name="Resource_Client1" Member="Client1" ThisKey="ResourceId" OtherKey="ResourceId" Type="Client" Cardinality="One" />
|
|---|
| 81 | </Type>
|
|---|
| 82 | </Table>
|
|---|
| 83 | <Table Name="dbo.Job" Member="Jobs">
|
|---|
| 84 | <Type Name="Job">
|
|---|
| 85 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 86 | <Column Name="ParentJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 87 | <Column Name="JobState" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 88 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 89 | <Column Name="Percentage" Type="System.Double" DbType="Float" CanBeNull="true" />
|
|---|
| 90 | <Column Name="SerializedJob" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="true" UpdateCheck="Never" IsDelayLoaded="true" />
|
|---|
| 91 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 92 | <Column Name="DateCalculated" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 93 | <Column Name="DateFinished" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 94 | <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 95 | <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 96 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 97 | <Column Name="CoresNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 98 | <Column Name="MemoryNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 99 | <Association Name="Job_AssignedResource" Member="AssignedResources" ThisKey="JobId" OtherKey="JobId" Type="AssignedResource" />
|
|---|
| 100 | <Association Name="Job_RequiredPlugin" Member="RequiredPlugins" ThisKey="JobId" OtherKey="JobId" Type="RequiredPlugin" />
|
|---|
| 101 | <Association Name="Job_Job" Member="Jobs" ThisKey="JobId" OtherKey="ParentJobId" Type="Job" />
|
|---|
| 102 | <Association Name="Job_Job" Member="Job1" ThisKey="ParentJobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
|---|
| 103 | <Association Name="Project_Job" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" DeleteRule="SET NULL" />
|
|---|
| 104 | <Association Name="Client_Job" Member="Client" ThisKey="ResourceId" OtherKey="ResourceId" Type="Client" IsForeignKey="true" DeleteRule="SET NULL" />
|
|---|
| 105 | </Type>
|
|---|
| 106 | </Table>
|
|---|
| 107 | <Table Name="dbo.UptimeCalendar" Member="UptimeCalendars">
|
|---|
| 108 | <Type Name="UptimeCalendar">
|
|---|
| 109 | <Column Name="UptimeCalendarId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 110 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 111 | <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 112 | <Column Name="EndDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 113 | <Column Name="AllDayEvent" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 114 | <Column Name="Recurring" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 115 | <Column Name="RecurringId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
|---|
| 116 | <Association Name="Resource_UptimeCalendar" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 117 | </Type>
|
|---|
| 118 | </Table>
|
|---|
| 119 | <Table Name="dbo.Client" Member="Clients">
|
|---|
| 120 | <Type Name="Client">
|
|---|
| 121 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 122 | <Column Name="CPUSpeed" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 123 | <Column Name="Memory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 124 | <Column Name="Login" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 125 | <Column Name="Status" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 126 | <Column Name="CalendarSyncStatus" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 127 | <Column Name="UseCalendarFromResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 128 | <Column Name="ClientConfigId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 129 | <Column Name="NumberOfCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 130 | <Column Name="NumberOfFreeCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 131 | <Column Name="FreeMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 132 | <Association Name="Client_UptimeStatistic" Member="UptimeStatistics" ThisKey="ResourceId" OtherKey="ResourceId" Type="UptimeStatistic" />
|
|---|
| 133 | <Association Name="Client_Job" Member="Jobs" ThisKey="ResourceId" OtherKey="ResourceId" Type="Job" />
|
|---|
| 134 | <Association Name="Resource_Client" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 135 | <Association Name="Resource_Client1" Member="Resource1" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
|---|
| 136 | <Association Name="ClientConfig_Client" Member="ClientConfig" ThisKey="ClientConfigId" OtherKey="ClientConfigId" Type="ClientConfig" IsForeignKey="true" DeleteRule="SET NULL" />
|
|---|
| 137 | </Type>
|
|---|
| 138 | </Table>
|
|---|
| 139 | </Database> |
|---|
