[4593] | 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>
|
---|
[4598] | 11 | <Table Name="dbo.Plugin" Member="Plugins">
|
---|
| 12 | <Type Name="Plugin">
|
---|
[4593] | 13 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
---|
| 14 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
---|
| 15 | <Column Name="Version" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
---|
[5402] | 16 | <Column Name="IsLocal" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
---|
| 17 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
---|
| 18 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
---|
[4615] | 19 | <Association Name="Plugin_RequiredPlugin" Member="RequiredPlugins" ThisKey="PluginId" OtherKey="PluginId" Type="RequiredPlugin" />
|
---|
[5375] | 20 | <Association Name="Plugin_PluginData" Member="PluginData" ThisKey="PluginId" OtherKey="PluginId" Type="PluginData" />
|
---|
[4593] | 21 | </Type>
|
---|
| 22 | </Table>
|
---|
| 23 | <Table Name="dbo.RequiredPlugins" Member="RequiredPlugins">
|
---|
| 24 | <Type Name="RequiredPlugin">
|
---|
| 25 | <Column Name="RequiredPluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" UpdateCheck="Never" />
|
---|
| 26 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
---|
| 27 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
---|
[4615] | 28 | <Association Name="Plugin_RequiredPlugin" Member="Plugin" Storage="_PluginInfo" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" DeleteRule="CASCADE" />
|
---|
[4593] | 29 | <Association Name="Job_RequiredPlugin" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
---|
| 30 | </Type>
|
---|
| 31 | </Table>
|
---|
| 32 | <Table Name="dbo.Resource" Member="Resources">
|
---|
| 33 | <Type Name="Resource" InheritanceCode="RESOURCE">
|
---|
[5375] | 34 | <Column Name="ResourceId" AutoSync="OnInsert" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
[4593] | 35 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
---|
| 36 | <Column Name="ResourceType" Type="System.String" CanBeNull="false" IsDiscriminator="true" />
|
---|
[5106] | 37 | <Column Name="ParentResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
---|
[4593] | 38 | <Association Name="Resource_AssignedResource" Member="AssignedResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedResource" />
|
---|
[5266] | 39 | <Association Name="Resource_Resource" Member="ChildResources" ThisKey="ResourceId" OtherKey="ParentResourceId" Type="Resource" />
|
---|
[4593] | 40 | <Association Name="Resource_UptimeCalendar" Member="UptimeCalendars" ThisKey="ResourceId" OtherKey="ResourceId" Type="UptimeCalendar" />
|
---|
[5511] | 41 | <Association Name="Resource_StateLog" Member="StateLogs" ThisKey="ResourceId" OtherKey="SlaveId" Type="StateLog" />
|
---|
[5106] | 42 | <Association Name="Resource_Resource" Member="ParentResource" ThisKey="ParentResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
---|
[4593] | 43 | <Type Name="Slave" InheritanceCode="Slave" IsInheritanceDefault="true">
|
---|
[4649] | 44 | <Column Name="CpuSpeed" Storage="_CPUSpeed" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
---|
[4593] | 45 | <Column Name="Memory" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
---|
| 46 | <Column Name="Login" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
---|
[4649] | 47 | <Column Name="SlaveState" Storage="_Status" Type="global::HeuristicLab.Services.Hive.Common.DataTransfer.SlaveState" DbType="VarChar(15)" CanBeNull="true" />
|
---|
| 48 | <Column Name="Cores" Storage="_NumberOfCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
---|
| 49 | <Column Name="FreeCores" Storage="_NumberOfFreeCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
---|
[4593] | 50 | <Column Name="FreeMemory" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
---|
| 51 | <Column Name="IsAllowedToCalculate" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
---|
[5404] | 52 | <Column Name="CpuArchitecture" Type="global::HeuristicLab.Services.Hive.Common.DataTransfer.CpuArchitecture" DbType="VarChar(3)" CanBeNull="false" />
|
---|
[5405] | 53 | <Column Name="OperatingSystem" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" UpdateCheck="Never" />
|
---|
| 54 | <Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
---|
[4593] | 55 | </Type>
|
---|
[5106] | 56 | <Type Name="SlaveGroup" InheritanceCode="GROUP" />
|
---|
[4593] | 57 | </Type>
|
---|
| 58 | </Table>
|
---|
| 59 | <Table Name="dbo.Job" Member="Jobs">
|
---|
| 60 | <Type Name="Job">
|
---|
| 61 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
---|
[5526] | 62 | <Column Name="JobState" Member="State" Type="global::HeuristicLab.Services.Hive.Common.DataTransfer.JobState" DbType="VarChar(30)" CanBeNull="false" />
|
---|
| 63 | <Column Name="ExecutionTime" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
|
---|
| 64 | <Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
---|
[4593] | 65 | <Column Name="ParentJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
---|
| 66 | <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
---|
| 67 | <Column Name="CoresNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
---|
| 68 | <Column Name="MemoryNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
---|
[5526] | 69 | <Column Name="IsParentJob" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
---|
| 70 | <Column Name="FinishWhenChildJobsFinished" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
---|
[5779] | 71 | <Column Name="Command" Type="global::HeuristicLab.Services.Hive.Common.DataTransfer.Command?" DbType="VarChar(30)" CanBeNull="true" />
|
---|
[4593] | 72 | <Association Name="Job_AssignedResource" Member="AssignedResources" ThisKey="JobId" OtherKey="JobId" Type="AssignedResource" />
|
---|
| 73 | <Association Name="Job_RequiredPlugin" Member="RequiredPlugins" ThisKey="JobId" OtherKey="JobId" Type="RequiredPlugin" />
|
---|
[5106] | 74 | <Association Name="Job_Job" Member="ChildJobs" Storage="_Jobs" ThisKey="JobId" OtherKey="ParentJobId" Type="Job" />
|
---|
[4598] | 75 | <Association Name="Job_JobData" Member="JobData" ThisKey="JobId" OtherKey="JobId" Type="JobData" Cardinality="One" />
|
---|
[5511] | 76 | <Association Name="Job_StateLog" Member="StateLogs" ThisKey="JobId" OtherKey="JobId" Type="StateLog" />
|
---|
[5106] | 77 | <Association Name="Job_Job" Member="ParentJob" Storage="_Job1" ThisKey="ParentJobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
---|
[4593] | 78 | </Type>
|
---|
| 79 | </Table>
|
---|
| 80 | <Table Name="dbo.UptimeCalendar" Member="UptimeCalendars">
|
---|
| 81 | <Type Name="UptimeCalendar">
|
---|
[5402] | 82 | <Column Name="UptimeCalendarId" Type="System.Guid" DbType="UniqueIdentifier" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
---|
| 83 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
---|
| 84 | <Column Name="StartDate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
---|
| 85 | <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
---|
| 86 | <Column Name="AllDayEvent" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
---|
| 87 | <Column Name="Recurring" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
---|
[4593] | 88 | <Column Name="RecurringId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
---|
| 89 | <Association Name="Resource_UptimeCalendar" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
|
---|
| 90 | </Type>
|
---|
| 91 | </Table>
|
---|
| 92 | <Table Name="dbo.HiveExperiment" Member="HiveExperiments">
|
---|
| 93 | <Type Name="HiveExperiment">
|
---|
| 94 | <Column Name="HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
---|
| 95 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
---|
| 96 | <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
---|
| 97 | <Column Name="ResourceIds" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
---|
[5511] | 98 | <Column Name="OwnerUserId" Storage="_UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
---|
[5106] | 99 | <Column Name="RootJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
---|
| 100 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
---|
[5511] | 101 | <Column Name="LastAccessed" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
---|
| 102 | <Column Name="IsHiveEngine" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
---|
| 103 | <Association Name="HiveExperiment_HiveExperimentPermission" Member="HiveExperimentPermissions" ThisKey="HiveExperimentId" OtherKey="HiveExperimentId" Type="HiveExperimentPermission" />
|
---|
[4593] | 104 | <Association Name="Job_HiveExperiment" Member="RootJob" Storage="_Job" ThisKey="RootJobId" OtherKey="JobId" Type="Job" IsForeignKey="true" DeleteRule="CASCADE" />
|
---|
| 105 | </Type>
|
---|
| 106 | </Table>
|
---|
[5511] | 107 | <Table Name="dbo.JobData" Member="JobDatas">
|
---|
[4598] | 108 | <Type Name="JobData">
|
---|
| 109 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
[4615] | 110 | <Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX)" CanBeNull="false" UpdateCheck="Never" />
|
---|
[5106] | 111 | <Column Name="LastUpdate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
---|
[4598] | 112 | <Association Name="Job_JobData" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
---|
| 113 | </Type>
|
---|
| 114 | </Table>
|
---|
[5511] | 115 | <Table Name="dbo.PluginData" Member="PluginDatas">
|
---|
[4598] | 116 | <Type Name="PluginData">
|
---|
[5402] | 117 | <Column Name="PluginDataId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
---|
[4615] | 118 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
---|
[4598] | 119 | <Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
---|
[5266] | 120 | <Column Name="FileName" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
---|
[4598] | 121 | <Association Name="Plugin_PluginData" Member="Plugin" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" />
|
---|
| 122 | </Type>
|
---|
| 123 | </Table>
|
---|
[5511] | 124 | <Table Name="dbo.StateLog" Member="StateLogs">
|
---|
| 125 | <Type Name="StateLog">
|
---|
| 126 | <Column Name="StateLogId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
---|
| 127 | <Column Name="State" Type="global::HeuristicLab.Services.Hive.Common.DataTransfer.JobState" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
|
---|
| 128 | <Column Name="DateTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
---|
| 129 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
---|
| 130 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
---|
| 131 | <Column Name="SlaveId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
---|
| 132 | <Column Name="Exception" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
---|
| 133 | <Association Name="Job_StateLog" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
---|
| 134 | <Association Name="Resource_StateLog" Member="Resource" ThisKey="SlaveId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
---|
| 135 | </Type>
|
---|
| 136 | </Table>
|
---|
| 137 | <Table Name="dbo.HiveExperimentPermission" Member="HiveExperimentPermissions">
|
---|
| 138 | <Type Name="HiveExperimentPermission">
|
---|
| 139 | <Column Name="HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
| 140 | <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
| 141 | <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
---|
| 142 | <Column Name="Permission" Type="global::HeuristicLab.Services.Hive.Common.DataTransfer.Permission" DbType="VarChar(15) NOT NULL" CanBeNull="false" />
|
---|
| 143 | <Association Name="HiveExperiment_HiveExperimentPermission" Member="HiveExperiment" ThisKey="HiveExperimentId" OtherKey="HiveExperimentId" Type="HiveExperiment" IsForeignKey="true" />
|
---|
| 144 | </Type>
|
---|
| 145 | </Table>
|
---|
[5593] | 146 | <Table Name="" Member="Lifecycles">
|
---|
| 147 | <Type Name="Lifecycle">
|
---|
| 148 | <Column Name="LifecycleId" Type="System.Int32" DbType="Int" IsPrimaryKey="true" CanBeNull="false" />
|
---|
| 149 | <Column Name="LastCleanup" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
---|
| 150 | </Type>
|
---|
| 151 | </Table>
|
---|
[4593] | 152 | </Database> |
---|