| 1 | <?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.Hive-3.3" Class="HiveDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
|
|---|
| 2 | <Connection Mode="AppSettings" ConnectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=HeuristicLab.Hive-3.3;Integrated Security=True" SettingsObjectName="HeuristicLab.Services.Hive.DataAccess.Settings" SettingsPropertyName="HeuristicLab_Hive_LinqConnectionString" Provider="System.Data.SqlClient" />
|
|---|
| 3 | <Table Name="dbo.AssignedResources" Member="AssignedResources">
|
|---|
| 4 | <Type Name="AssignedResource">
|
|---|
| 5 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 6 | <Column Name="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 7 | <Association Name="Resource_AssignedResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
|
|---|
| 8 | <Association Name="Task_AssignedResource" Member="Task" Storage="_Job" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" DeleteRule="CASCADE" />
|
|---|
| 9 | </Type>
|
|---|
| 10 | </Table>
|
|---|
| 11 | <Table Name="dbo.Plugin" Member="Plugins">
|
|---|
| 12 | <Type Name="Plugin">
|
|---|
| 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" />
|
|---|
| 16 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
|---|
| 17 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
|---|
| 18 | <Column Name="Hash" Type="System.Byte[]" DbType="VarBinary(20) NOT NULL" CanBeNull="false" />
|
|---|
| 19 | <Association Name="Plugin_RequiredPlugin" Member="RequiredPlugins" ThisKey="PluginId" OtherKey="PluginId" Type="RequiredPlugin" />
|
|---|
| 20 | <Association Name="Plugin_PluginData" Member="PluginData" ThisKey="PluginId" OtherKey="PluginId" Type="PluginData" />
|
|---|
| 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="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 27 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 28 | <Association Name="Plugin_RequiredPlugin" Member="Plugin" Storage="_PluginInfo" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" DeleteRule="CASCADE" />
|
|---|
| 29 | <Association Name="Task_RequiredPlugin" Member="Task" Storage="_Job" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
|
|---|
| 30 | </Type>
|
|---|
| 31 | </Table>
|
|---|
| 32 | <Table Name="dbo.Resource" Member="Resources">
|
|---|
| 33 | <Type Name="Resource" InheritanceCode="RESOURCE">
|
|---|
| 34 | <Column Name="ResourceId" AutoSync="OnInsert" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 35 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
|---|
| 36 | <Column Name="ResourceType" Type="System.String" CanBeNull="false" IsDiscriminator="true" />
|
|---|
| 37 | <Column Name="ParentResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 38 | <Column Name="HbInterval" Type="System.Int32" DbType="Int" CanBeNull="false" />
|
|---|
| 39 | <Column Name="OwnerUserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 40 | <Association Name="Resource_AssignedResource" Member="AssignedResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedResource" />
|
|---|
| 41 | <Association Name="Resource_Resource" Member="ChildResources" ThisKey="ResourceId" OtherKey="ParentResourceId" Type="Resource" />
|
|---|
| 42 | <Association Name="Resource_Downtime" Member="Downtimes" Storage="_UptimeCalendars" ThisKey="ResourceId" OtherKey="ResourceId" Type="Downtime" />
|
|---|
| 43 | <Association Name="Resource_StateLog" Member="StateLogs" ThisKey="ResourceId" OtherKey="SlaveId" Type="StateLog" />
|
|---|
| 44 | <Association Name="Resource_ResourcePermission" Member="ResourcePermissions" ThisKey="ResourceId" OtherKey="ResourceId" Type="ResourcePermission" />
|
|---|
| 45 | <Association Name="Resource_Resource" Member="ParentResource" ThisKey="ParentResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
|---|
| 46 | <Type Name="Slave" InheritanceCode="Slave" IsInheritanceDefault="true">
|
|---|
| 47 | <Column Name="CpuSpeed" Storage="_CPUSpeed" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 48 | <Column Name="Memory" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 49 | <Column Name="Login" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 50 | <Column Name="SlaveState" Storage="_Status" Type="global::HeuristicLab.Services.Hive.DataAccess.SlaveState" DbType="VarChar(15)" CanBeNull="true" />
|
|---|
| 51 | <Column Name="Cores" Storage="_NumberOfCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 52 | <Column Name="FreeCores" Storage="_NumberOfFreeCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 53 | <Column Name="FreeMemory" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 54 | <Column Name="IsAllowedToCalculate" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
|---|
| 55 | <Column Name="CpuArchitecture" Type="global::HeuristicLab.Services.Hive.DataAccess.CpuArchitecture" DbType="VarChar(3)" CanBeNull="false" />
|
|---|
| 56 | <Column Name="OperatingSystem" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 57 | <Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 58 | <Column Name="CpuUtilization" Type="System.Double" DbType="float" CanBeNull="false" />
|
|---|
| 59 | <Column Name="IsDisposable" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
|
|---|
| 60 | </Type>
|
|---|
| 61 | <Type Name="SlaveGroup" InheritanceCode="GROUP" />
|
|---|
| 62 | </Type>
|
|---|
| 63 | </Table>
|
|---|
| 64 | <Table Name="dbo.Task" Member="Tasks">
|
|---|
| 65 | <Type Name="Task">
|
|---|
| 66 | <Column Name="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 67 | <Column Name="TaskState" Member="State" Type="global::HeuristicLab.Services.Hive.DataAccess.TaskState" DbType="VarChar(30)" CanBeNull="false" />
|
|---|
| 68 | <Column Name="ExecutionTimeMs" Storage="_ExecutionTime" Type="System.Double" DbType="float" CanBeNull="false" />
|
|---|
| 69 | <Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 70 | <Column Name="ParentTaskId" Storage="_ParentJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 71 | <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 72 | <Column Name="CoresNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 73 | <Column Name="MemoryNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 74 | <Column Name="IsParentTask" Storage="_IsParentJob" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
|---|
| 75 | <Column Name="FinishWhenChildJobsFinished" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
|---|
| 76 | <Column Name="Command" Type="global::HeuristicLab.Services.Hive.DataAccess.Command?" DbType="VarChar(30)" CanBeNull="true" />
|
|---|
| 77 | <Column Name="JobId" Storage="_HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 78 | <Column Name="IsPrivileged" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
|---|
| 79 | <Association Name="Task_AssignedResource" Member="AssignedResources" ThisKey="TaskId" OtherKey="TaskId" Type="AssignedResource" />
|
|---|
| 80 | <Association Name="Task_RequiredPlugin" Member="RequiredPlugins" ThisKey="TaskId" OtherKey="TaskId" Type="RequiredPlugin" />
|
|---|
| 81 | <Association Name="Task_Task" Member="ChildJobs" Storage="_Jobs" ThisKey="TaskId" OtherKey="ParentTaskId" Type="Task" />
|
|---|
| 82 | <Association Name="Task_TaskData" Member="JobData" ThisKey="TaskId" OtherKey="TaskId" Type="TaskData" Cardinality="One" />
|
|---|
| 83 | <Association Name="Task_StateLog" Member="StateLogs" ThisKey="TaskId" OtherKey="TaskId" Type="StateLog" />
|
|---|
| 84 | <Association Name="Task_Task" Member="ParentJob" Storage="_Job1" ThisKey="ParentTaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
|
|---|
| 85 | <Association Name="Job_Task" Member="Job" Storage="_HiveExperiment" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
|---|
| 86 | </Type>
|
|---|
| 87 | </Table>
|
|---|
| 88 | <Table Name="dbo.Downtime" Member="Downtimes">
|
|---|
| 89 | <Type Name="Downtime">
|
|---|
| 90 | <Column Name="DowntimeId" Storage="_UptimeCalendarId" Type="System.Guid" DbType="UniqueIdentifier" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 91 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
|---|
| 92 | <Column Name="StartDate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
|---|
| 93 | <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
|---|
| 94 | <Column Name="AllDayEvent" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
|---|
| 95 | <Column Name="Recurring" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
|
|---|
| 96 | <Column Name="RecurringId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
|---|
| 97 | <Column Name="DowntimeType" Storage="_Type" Type="global::HeuristicLab.Services.Hive.DataAccess.DowntimeType" DbType="VarChar(MAX)" CanBeNull="false" />
|
|---|
| 98 | <Association Name="Resource_Downtime" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
|
|---|
| 99 | </Type>
|
|---|
| 100 | </Table>
|
|---|
| 101 | <Table Name="dbo.Job" Member="Jobs">
|
|---|
| 102 | <Type Name="Job">
|
|---|
| 103 | <Column Name="JobId" Storage="_HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 104 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
|---|
| 105 | <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 106 | <Column Name="ResourceIds" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 107 | <Column Name="OwnerUserId" Storage="_UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
|
|---|
| 108 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
|---|
| 109 | <Association Name="Job_Task" Member="Tasks" Storage="_Jobs" ThisKey="JobId" OtherKey="JobId" Type="Task" />
|
|---|
| 110 | <Association Name="Job_JobPermission" Member="JobPermissions" Storage="_HiveExperimentPermissions" ThisKey="JobId" OtherKey="JobId" Type="JobPermission" />
|
|---|
| 111 | </Type>
|
|---|
| 112 | </Table>
|
|---|
| 113 | <Table Name="dbo.TaskData" Member="TaskDatas">
|
|---|
| 114 | <Type Name="TaskData">
|
|---|
| 115 | <Column Name="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 116 | <Column Name="Data" Type="System.Byte[]" DbType="VarBinary(MAX)" CanBeNull="false" UpdateCheck="Never" IsDelayLoaded="true" />
|
|---|
| 117 | <Column Name="LastUpdate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
|---|
| 118 | <Association Name="Task_TaskData" Member="Task" Storage="_Job" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
|
|---|
| 119 | </Type>
|
|---|
| 120 | </Table>
|
|---|
| 121 | <Table Name="dbo.PluginData" Member="PluginDatas">
|
|---|
| 122 | <Type Name="PluginData">
|
|---|
| 123 | <Column Name="PluginDataId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 124 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 125 | <Column Name="Data" Type="System.Byte[]" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" IsDelayLoaded="true" />
|
|---|
| 126 | <Column Name="FileName" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
|---|
| 127 | <Association Name="Plugin_PluginData" Member="Plugin" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" />
|
|---|
| 128 | </Type>
|
|---|
| 129 | </Table>
|
|---|
| 130 | <Table Name="dbo.StateLog" Member="StateLogs">
|
|---|
| 131 | <Type Name="StateLog">
|
|---|
| 132 | <Column Name="StateLogId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 133 | <Column Name="State" Type="global::HeuristicLab.Services.Hive.DataAccess.TaskState" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
|
|---|
| 134 | <Column Name="DateTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 135 | <Column Name="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 136 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 137 | <Column Name="SlaveId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 138 | <Column Name="Exception" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
|
|---|
| 139 | <Association Name="Task_StateLog" Member="Task" Storage="_Job" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
|
|---|
| 140 | <Association Name="Resource_StateLog" Member="Resource" ThisKey="SlaveId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
|---|
| 141 | </Type>
|
|---|
| 142 | </Table>
|
|---|
| 143 | <Table Name="dbo.JobPermission" Member="JobPermissions">
|
|---|
| 144 | <Type Name="JobPermission">
|
|---|
| 145 | <Column Name="JobId" Storage="_HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 146 | <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 147 | <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 148 | <Column Name="Permission" Type="global::HeuristicLab.Services.Hive.DataAccess.Permission" DbType="VarChar(15) NOT NULL" CanBeNull="false" />
|
|---|
| 149 | <Association Name="Job_JobPermission" Member="Job" Storage="_HiveExperiment" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
|---|
| 150 | </Type>
|
|---|
| 151 | </Table>
|
|---|
| 152 | <Table Name="" Member="Lifecycles">
|
|---|
| 153 | <Type Name="Lifecycle">
|
|---|
| 154 | <Column Name="LifecycleId" Type="System.Int32" DbType="Int" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 155 | <Column Name="LastCleanup" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
|
|---|
| 156 | </Type>
|
|---|
| 157 | </Table>
|
|---|
| 158 | <Table Name="" Member="DeletedJobStatistics">
|
|---|
| 159 | <Type Name="DeletedJobStatistics">
|
|---|
| 160 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 161 | <Column Name="ExecutionTimeS" Storage="_ExecutionTime" Type="System.Double" DbType="float NOT NULL" CanBeNull="false" />
|
|---|
| 162 | <Column Name="ExecutionTimeSFinishedJobs" Storage="_ExecutionTimeFinishedJobs" Type="System.Double" DbType="float NOT NULL" CanBeNull="false" />
|
|---|
| 163 | <Column Name="StartToEndTimeS" Storage="_StartToEndTime" Type="System.Double" DbType="float NOT NULL" CanBeNull="false" />
|
|---|
| 164 | <Column Name="DeletedJobStatisticsId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 165 | </Type>
|
|---|
| 166 | </Table>
|
|---|
| 167 | <Table Name="" Member="UserStatistics">
|
|---|
| 168 | <Type Name="UserStatistics">
|
|---|
| 169 | <Column Name="StatisticsId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 170 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 171 | <Column Name="ExecutionTimeMs" Storage="_ExecutionTime" Type="System.Double" DbType="float NOT NULL" CanBeNull="false" />
|
|---|
| 172 | <Column Name="UsedCores" Storage="_CoresUsed" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 173 | <Column Name="ExecutionTimeMsFinishedJobs" Storage="_ExecutionTimeFinishedJobs" Type="System.Double" DbType="float NOT NULL" CanBeNull="false" />
|
|---|
| 174 | <Column Name="StartToEndTimeMs" Storage="_StartToEndTime" Type="System.Double" DbType="float NOT NULL" CanBeNull="false" />
|
|---|
| 175 | <Association Name="Statistics_UserStatistics" Member="Statistics" ThisKey="StatisticsId" OtherKey="StatisticsId" Type="Statistics" IsForeignKey="true" />
|
|---|
| 176 | </Type>
|
|---|
| 177 | </Table>
|
|---|
| 178 | <Table Name="" Member="SlaveStatistics">
|
|---|
| 179 | <Type Name="SlaveStatistics">
|
|---|
| 180 | <Column Name="StatisticsId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 181 | <Column Name="SlaveId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 182 | <Column Name="Cores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 183 | <Column Name="FreeCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 184 | <Column Name="CpuUtilization" Type="System.Double" DbType="float NOT NULL" CanBeNull="false" />
|
|---|
| 185 | <Column Name="Memory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 186 | <Column Name="FreeMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 187 | <Association Name="Statistics_SlaveStatistics" Member="Statistics" ThisKey="StatisticsId" OtherKey="StatisticsId" Type="Statistics" IsForeignKey="true" />
|
|---|
| 188 | </Type>
|
|---|
| 189 | </Table>
|
|---|
| 190 | <Table Name="" Member="Statistics">
|
|---|
| 191 | <Type Name="Statistics">
|
|---|
| 192 | <Column Name="StatisticsId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 193 | <Column Name="Timestamp" Type="System.DateTime" CanBeNull="false" />
|
|---|
| 194 | <Association Name="Statistics_UserStatistics" Member="UserStatistics" ThisKey="StatisticsId" OtherKey="StatisticsId" Type="UserStatistics" />
|
|---|
| 195 | <Association Name="Statistics_SlaveStatistics" Member="SlaveStatistics" ThisKey="StatisticsId" OtherKey="StatisticsId" Type="SlaveStatistics" />
|
|---|
| 196 | </Type>
|
|---|
| 197 | </Table>
|
|---|
| 198 | <Table Name="dbo.ResourcePermission" Member="ResourcePermissions">
|
|---|
| 199 | <Type Name="ResourcePermission">
|
|---|
| 200 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 201 | <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 202 | <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 203 | <Association Name="Resource_ResourcePermission" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
|---|
| 204 | </Type>
|
|---|
| 205 | </Table>
|
|---|
| 206 | <Table Name="" Member="UserPriorities">
|
|---|
| 207 | <Type Name="UserPriority">
|
|---|
| 208 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 209 | <Column Name="DateEnqueued" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 210 | </Type>
|
|---|
| 211 | </Table>
|
|---|
| 212 | <Table Name="[statistics].DimClient" Member="DimClients">
|
|---|
| 213 | <Type Name="DimClient">
|
|---|
| 214 | <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
|
|---|
| 215 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 216 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 217 | <Column Name="ExpirationTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 218 | <Column Name="ResourceGroupId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 219 | <Column Name="ResourceGroup2Id" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 220 | <Association Name="DimClient_FactTask" Member="FactTasks" ThisKey="Id" OtherKey="LastClientId" Type="FactTask" />
|
|---|
| 221 | <Association Name="DimClient_FactClientInfo" Member="FactClientInfos" ThisKey="Id" OtherKey="ClientId" Type="FactClientInfo" />
|
|---|
| 222 | </Type>
|
|---|
| 223 | </Table>
|
|---|
| 224 | <Table Name="[statistics].FactTask" Member="FactTasks">
|
|---|
| 225 | <Type Name="FactTask">
|
|---|
| 226 | <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 227 | <Column Name="TotalRuntime" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 228 | <Column Name="TotalWaitingTime" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 229 | <Column Name="TotalTransferTime" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 230 | <Column Name="NumCalculationRuns" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 231 | <Column Name="NumRetries" Storage="_NumFails" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 232 | <Column Name="CoresRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 233 | <Column Name="MemoryRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 234 | <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 235 | <Column Name="LastClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 236 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 237 | <Column Name="StartTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 238 | <Column Name="EndTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="true" />
|
|---|
| 239 | <Column Name="TaskState" Type="global::HeuristicLab.Services.Hive.DataAccess.TaskState" DbType="varchar(30)" CanBeNull="false" />
|
|---|
| 240 | <Column Name="Exception" Type="System.String" DbType="varchar(MAX)" CanBeNull="true" />
|
|---|
| 241 | <Association Name="DimClient_FactTask" Member="DimClient" ThisKey="LastClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" />
|
|---|
| 242 | <Association Name="DimJob_FactTask" Member="DimJob" ThisKey="JobId" OtherKey="JobId" Type="DimJob" IsForeignKey="true" />
|
|---|
| 243 | <Association Name="DimTime_FactTask" Member="DimTimeEnd" Storage="_DimTime" ThisKey="EndTime" OtherKey="Time" Type="DimTime" IsForeignKey="true" />
|
|---|
| 244 | <Association Name="DimTime_FactTask1" Member="DimTimeStart" Storage="_DimTime1" ThisKey="StartTime" OtherKey="Time" Type="DimTime" IsForeignKey="true" />
|
|---|
| 245 | </Type>
|
|---|
| 246 | </Table>
|
|---|
| 247 | <Table Name="[statistics].DimJob" Member="DimJobs">
|
|---|
| 248 | <Type Name="DimJob">
|
|---|
| 249 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 250 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 251 | <Column Name="JobName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 252 | <Column Name="UserName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 253 | <Association Name="DimJob_FactTask" Member="FactTasks" ThisKey="JobId" OtherKey="JobId" Type="FactTask" />
|
|---|
| 254 | </Type>
|
|---|
| 255 | </Table>
|
|---|
| 256 | <Table Name="[statistics].DimTime" Member="DimTimes">
|
|---|
| 257 | <Type Name="DimTime">
|
|---|
| 258 | <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 259 | <Column Name="Hour" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 260 | <Column Name="Day" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
|
|---|
| 261 | <Column Name="Month" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
|
|---|
| 262 | <Column Name="Year" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
|
|---|
| 263 | <Association Name="DimTime_FactTask" Member="FactTasks" ThisKey="Time" OtherKey="EndTime" Type="FactTask" />
|
|---|
| 264 | <Association Name="DimTime_FactTask1" Member="FactTasks1" ThisKey="Time" OtherKey="StartTime" Type="FactTask" />
|
|---|
| 265 | <Association Name="DimTime_FactClientInfo" Member="FactClientInfos" ThisKey="Time" OtherKey="Time" Type="FactClientInfo" />
|
|---|
| 266 | </Type>
|
|---|
| 267 | </Table>
|
|---|
| 268 | <Table Name="[statistics].DimUser" Member="DimUsers">
|
|---|
| 269 | <Type Name="DimUser">
|
|---|
| 270 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 271 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 272 | <Association Name="DimUser_FactClientInfo" Member="FactClientInfos" ThisKey="UserId" OtherKey="UserId" Type="FactClientInfo" />
|
|---|
| 273 | </Type>
|
|---|
| 274 | </Table>
|
|---|
| 275 | <Table Name="[statistics].FactClientInfo" Member="FactClientInfos">
|
|---|
| 276 | <Type Name="FactClientInfo">
|
|---|
| 277 | <Column Name="ClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 278 | <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 279 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 280 | <Column Name="NumUsedCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 281 | <Column Name="NumTotalCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 282 | <Column Name="UsedMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 283 | <Column Name="TotalMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 284 | <Column Name="CpuUtilization" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 285 | <Column Name="TotalTimeIdle" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 286 | <Column Name="TotalTimeCalculating" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 287 | <Column Name="TotalTimeTransferring" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 288 | <Column Name="TotalTimeOffline" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 289 | <Column Name="TotalTimeUnavailable" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| 290 | <Column Name="SlaveState" Type="global::HeuristicLab.Services.Hive.DataAccess.SlaveState" DbType="VarChar(15)" CanBeNull="false" />
|
|---|
| 291 | <Association Name="DimClient_FactClientInfo" Member="DimClient" ThisKey="ClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" />
|
|---|
| 292 | <Association Name="DimTime_FactClientInfo" Member="DimTime" ThisKey="Time" OtherKey="Time" Type="DimTime" IsForeignKey="true" />
|
|---|
| 293 | <Association Name="DimUser_FactClientInfo" Member="DimUser" ThisKey="UserId" OtherKey="UserId" Type="DimUser" IsForeignKey="true" />
|
|---|
| 294 | </Type>
|
|---|
| 295 | </Table>
|
|---|
| 296 | </Database> |
|---|
