| [15523] | 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=HIVELAB;Initial Catalog=HeuristicLab.Hive-3.3;Integrated Security=True" SettingsObjectName="HeuristicLab.Services.Hive.DataAccess.Settings" SettingsPropertyName="HeuristicLab_Hive_3_3ConnectionString" Provider="System.Data.SqlClient" />
|
|---|
| 3 | <Table Name="dbo.AssignedJobResource" Member="AssignedJobResources">
|
|---|
| 4 | <Type Name="AssignedJobResource">
|
|---|
| 5 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 6 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 7 | <Association Name="Job_AssignedJobResource" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
|---|
| 8 | <Association Name="Resource_AssignedJobResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
|---|
| 9 | </Type>
|
|---|
| 10 | </Table>
|
|---|
| 11 | <Table Name="[statistics].FactTask" Member="FactTasks">
|
|---|
| 12 | <Type Name="FactTask">
|
|---|
| 13 | <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 14 | <Column Name="CalculatingTime" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 15 | <Column Name="WaitingTime" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 16 | <Column Name="TransferTime" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 17 | <Column Name="NumCalculationRuns" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 18 | <Column Name="NumRetries" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 19 | <Column Name="CoresRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 20 | <Column Name="MemoryRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 21 | <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 22 | <Column Name="LastClientId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 23 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 24 | <Column Name="StartTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 25 | <Column Name="EndTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 26 | <Column Name="TaskState" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
|
|---|
| 27 | <Column Name="Exception" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 28 | <Column Name="InitialWaitingTime" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 29 | <Association Name="DimClient_FactTask" Member="DimClient" ThisKey="LastClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" />
|
|---|
| 30 | <Association Name="DimJob_FactTask" Member="DimJob" ThisKey="JobId" OtherKey="JobId" Type="DimJob" IsForeignKey="true" />
|
|---|
| 31 | </Type>
|
|---|
| 32 | </Table>
|
|---|
| [15411] | 33 | <Table Name="dbo.AssignedProjectResource" Member="AssignedProjectResources">
|
|---|
| 34 | <Type Name="AssignedProjectResource">
|
|---|
| [6983] | 35 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| [15523] | 36 | <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 37 | <Association Name="Project_AssignedProjectResource" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 38 | <Association Name="Resource_AssignedProjectResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| [6983] | 39 | </Type>
|
|---|
| 40 | </Table>
|
|---|
| [15523] | 41 | <Table Name="dbo.Downtime" Member="Downtimes">
|
|---|
| 42 | <Type Name="Downtime">
|
|---|
| 43 | <Column Name="DowntimeId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 44 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 45 | <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 46 | <Column Name="EndDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 47 | <Column Name="AllDayEvent" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 48 | <Column Name="Recurring" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 49 | <Column Name="RecurringId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 50 | <Column Name="DowntimeType" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 51 | <Association Name="Resource_Downtime" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
|---|
| 52 | </Type>
|
|---|
| 53 | </Table>
|
|---|
| 54 | <Table Name="dbo.Job" Member="Jobs">
|
|---|
| 55 | <Type Name="Job">
|
|---|
| 56 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 57 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 58 | <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 59 | <Column Name="OwnerUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 60 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 61 | <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 62 | <Association Name="Job_AssignedJobResource" Member="AssignedJobResources" ThisKey="JobId" OtherKey="JobId" Type="AssignedJobResource" />
|
|---|
| 63 | <Association Name="Job_JobPermission" Member="JobPermissions" ThisKey="JobId" OtherKey="JobId" Type="JobPermission" />
|
|---|
| 64 | <Association Name="Job_Task" Member="Tasks" ThisKey="JobId" OtherKey="JobId" Type="Task" />
|
|---|
| 65 | <Association Name="Project_Job" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 66 | </Type>
|
|---|
| 67 | </Table>
|
|---|
| 68 | <Table Name="dbo.JobPermission" Member="JobPermissions">
|
|---|
| 69 | <Type Name="JobPermission">
|
|---|
| 70 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 71 | <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 72 | <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 73 | <Column Name="Permission" Type="System.String" DbType="VarChar(15) NOT NULL" CanBeNull="false" />
|
|---|
| 74 | <Association Name="Job_JobPermission" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 75 | </Type>
|
|---|
| 76 | </Table>
|
|---|
| 77 | <Table Name="dbo.Lifecycle" Member="Lifecycles">
|
|---|
| 78 | <Type Name="Lifecycle">
|
|---|
| 79 | <Column Name="LifecycleId" Type="System.Int32" DbType="Int NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 80 | <Column Name="LastCleanup" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 81 | </Type>
|
|---|
| 82 | </Table>
|
|---|
| [6983] | 83 | <Table Name="dbo.Plugin" Member="Plugins">
|
|---|
| 84 | <Type Name="Plugin">
|
|---|
| [15523] | 85 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 86 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 87 | <Column Name="Version" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 88 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 89 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 90 | <Column Name="Hash" Type="System.Data.Linq.Binary" DbType="VarBinary(20) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 91 | <Association Name="Plugin_PluginData" Member="PluginDatas" ThisKey="PluginId" OtherKey="PluginId" Type="PluginData" />
|
|---|
| [6983] | 92 | <Association Name="Plugin_RequiredPlugin" Member="RequiredPlugins" ThisKey="PluginId" OtherKey="PluginId" Type="RequiredPlugin" />
|
|---|
| 93 | </Type>
|
|---|
| 94 | </Table>
|
|---|
| [15523] | 95 | <Table Name="dbo.PluginData" Member="PluginDatas">
|
|---|
| 96 | <Type Name="PluginData">
|
|---|
| 97 | <Column Name="PluginDataId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 98 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 99 | <Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 100 | <Column Name="FileName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 101 | <Association Name="Plugin_PluginData" Member="Plugin" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 102 | </Type>
|
|---|
| 103 | </Table>
|
|---|
| 104 | <Table Name="dbo.Project" Member="Projects">
|
|---|
| 105 | <Type Name="Project">
|
|---|
| 106 | <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 107 | <Column Name="ParentProjectId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 108 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 109 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 110 | <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 111 | <Column Name="OwnerUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 112 | <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 113 | <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 114 | <Association Name="Project_AssignedProjectResource" Member="AssignedProjectResources" ThisKey="ProjectId" OtherKey="ProjectId" Type="AssignedProjectResource" />
|
|---|
| 115 | <Association Name="Project_Job" Member="Jobs" ThisKey="ProjectId" OtherKey="ProjectId" Type="Job" />
|
|---|
| 116 | <Association Name="Project_Project" Member="Projects" ThisKey="ProjectId" OtherKey="ParentProjectId" Type="Project" />
|
|---|
| 117 | <Association Name="Project_ProjectPermission" Member="ProjectPermissions" ThisKey="ProjectId" OtherKey="ProjectId" Type="ProjectPermission" />
|
|---|
| 118 | <Association Name="Project_Project" Member="Project1" ThisKey="ParentProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" />
|
|---|
| 119 | </Type>
|
|---|
| 120 | </Table>
|
|---|
| 121 | <Table Name="dbo.ProjectPermission" Member="ProjectPermissions">
|
|---|
| 122 | <Type Name="ProjectPermission">
|
|---|
| 123 | <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 124 | <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 125 | <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 126 | <Association Name="Project_ProjectPermission" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 127 | </Type>
|
|---|
| 128 | </Table>
|
|---|
| [6983] | 129 | <Table Name="dbo.RequiredPlugins" Member="RequiredPlugins">
|
|---|
| 130 | <Type Name="RequiredPlugin">
|
|---|
| [15523] | 131 | <Column Name="RequiredPluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 132 | <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| [6983] | 133 | <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| [15523] | 134 | <Association Name="Plugin_RequiredPlugin" Member="Plugin" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 135 | <Association Name="Task_RequiredPlugin" Member="Task" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| [6983] | 136 | </Type>
|
|---|
| 137 | </Table>
|
|---|
| 138 | <Table Name="dbo.Resource" Member="Resources">
|
|---|
| [15523] | 139 | <Type Name="Resource">
|
|---|
| 140 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 141 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 142 | <Column Name="ResourceType" Type="System.String" DbType="NVarChar(4000) NOT NULL" CanBeNull="false" />
|
|---|
| [6983] | 143 | <Column Name="ParentResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| [15523] | 144 | <Column Name="CpuSpeed" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 145 | <Column Name="Memory" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 146 | <Column Name="Login" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 147 | <Column Name="SlaveState" Type="System.String" DbType="VarChar(15)" CanBeNull="true" />
|
|---|
| 148 | <Column Name="Cores" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 149 | <Column Name="FreeCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 150 | <Column Name="FreeMemory" Type="System.Int32" DbType="Int" CanBeNull="true" />
|
|---|
| 151 | <Column Name="IsAllowedToCalculate" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
|
|---|
| 152 | <Column Name="CpuArchitecture" Type="System.String" DbType="VarChar(3)" CanBeNull="true" />
|
|---|
| 153 | <Column Name="OperatingSystem" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 154 | <Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 155 | <Column Name="CpuUtilization" Type="System.Double" DbType="Float" CanBeNull="true" />
|
|---|
| 156 | <Column Name="HbInterval" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 157 | <Column Name="IsDisposable" Type="System.Boolean" DbType="Bit" CanBeNull="true" />
|
|---|
| [7916] | 158 | <Column Name="OwnerUserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| [15523] | 159 | <Association Name="Resource_AssignedJobResource" Member="AssignedJobResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedJobResource" />
|
|---|
| 160 | <Association Name="Resource_AssignedProjectResource" Member="AssignedProjectResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedProjectResource" />
|
|---|
| 161 | <Association Name="Resource_Downtime" Member="Downtimes" ThisKey="ResourceId" OtherKey="ResourceId" Type="Downtime" />
|
|---|
| 162 | <Association Name="Resource_Resource" Member="Resources" ThisKey="ResourceId" OtherKey="ParentResourceId" Type="Resource" />
|
|---|
| [6983] | 163 | <Association Name="Resource_StateLog" Member="StateLogs" ThisKey="ResourceId" OtherKey="SlaveId" Type="StateLog" />
|
|---|
| [15523] | 164 | <Association Name="Resource_Resource" Member="Resource1" ThisKey="ParentResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
|
|---|
| [6983] | 165 | </Type>
|
|---|
| 166 | </Table>
|
|---|
| [15523] | 167 | <Table Name="dbo.StateLog" Member="StateLogs">
|
|---|
| 168 | <Type Name="StateLog">
|
|---|
| 169 | <Column Name="StateLogId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 170 | <Column Name="State" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
|
|---|
| 171 | <Column Name="DateTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 172 | <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 173 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 174 | <Column Name="SlaveId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 175 | <Column Name="Exception" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 176 | <Association Name="Resource_StateLog" Member="Resource" ThisKey="SlaveId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="SET NULL" />
|
|---|
| 177 | <Association Name="Task_StateLog" Member="Task" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" DeleteRule="CASCADE" DeleteOnNull="true" />
|
|---|
| 178 | </Type>
|
|---|
| 179 | </Table>
|
|---|
| [6983] | 180 | <Table Name="dbo.Task" Member="Tasks">
|
|---|
| 181 | <Type Name="Task">
|
|---|
| [15523] | 182 | <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 183 | <Column Name="TaskState" Type="System.String" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
|
|---|
| 184 | <Column Name="ExecutionTimeMs" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| [6983] | 185 | <Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| [15523] | 186 | <Column Name="ParentTaskId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| [6983] | 187 | <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 188 | <Column Name="CoresNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 189 | <Column Name="MemoryNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| [15523] | 190 | <Column Name="IsParentTask" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 191 | <Column Name="FinishWhenChildJobsFinished" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| 192 | <Column Name="Command" Type="System.String" DbType="VarChar(30)" CanBeNull="true" />
|
|---|
| 193 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| [6983] | 194 | <Association Name="Task_RequiredPlugin" Member="RequiredPlugins" ThisKey="TaskId" OtherKey="TaskId" Type="RequiredPlugin" />
|
|---|
| 195 | <Association Name="Task_StateLog" Member="StateLogs" ThisKey="TaskId" OtherKey="TaskId" Type="StateLog" />
|
|---|
| [15523] | 196 | <Association Name="Task_Task" Member="Tasks" ThisKey="TaskId" OtherKey="ParentTaskId" Type="Task" />
|
|---|
| 197 | <Association Name="Task_TaskData" Member="TaskData" ThisKey="TaskId" OtherKey="TaskId" Type="TaskData" Cardinality="One" />
|
|---|
| 198 | <Association Name="Job_Task" Member="Job" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
|
|---|
| 199 | <Association Name="Task_Task" Member="Task1" ThisKey="ParentTaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
|
|---|
| [6983] | 200 | </Type>
|
|---|
| 201 | </Table>
|
|---|
| 202 | <Table Name="dbo.TaskData" Member="TaskDatas">
|
|---|
| 203 | <Type Name="TaskData">
|
|---|
| [15523] | 204 | <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 205 | <Column Name="Data" Type="System.Data.Linq.Binary" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" />
|
|---|
| 206 | <Column Name="LastUpdate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 207 | <Association Name="Task_TaskData" Member="Task" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
|
|---|
| [6983] | 208 | </Type>
|
|---|
| 209 | </Table>
|
|---|
| [15523] | 210 | <Table Name="dbo.UserPriority" Member="UserPriorities">
|
|---|
| [9123] | 211 | <Type Name="UserPriority">
|
|---|
| 212 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 213 | <Column Name="DateEnqueued" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 214 | </Type>
|
|---|
| 215 | </Table>
|
|---|
| [12878] | 216 | <Table Name="[statistics].DimClient" Member="DimClients">
|
|---|
| 217 | <Type Name="DimClient">
|
|---|
| [15523] | 218 | <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| [12878] | 219 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 220 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 221 | <Column Name="ExpirationTime" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| 222 | <Column Name="ResourceGroupId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| 223 | <Column Name="ResourceGroup2Id" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
|---|
| [15523] | 224 | <Column Name="GroupName" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| 225 | <Column Name="GroupName2" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
|
|---|
| [12878] | 226 | <Association Name="DimClient_FactTask" Member="FactTasks" ThisKey="Id" OtherKey="LastClientId" Type="FactTask" />
|
|---|
| 227 | <Association Name="DimClient_FactClientInfo" Member="FactClientInfos" ThisKey="Id" OtherKey="ClientId" Type="FactClientInfo" />
|
|---|
| 228 | </Type>
|
|---|
| 229 | </Table>
|
|---|
| 230 | <Table Name="[statistics].DimJob" Member="DimJobs">
|
|---|
| 231 | <Type Name="DimJob">
|
|---|
| 232 | <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 233 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
|
|---|
| 234 | <Column Name="JobName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 235 | <Column Name="UserName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 236 | <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| [15523] | 237 | <Column Name="TotalTasks" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 238 | <Column Name="CompletedTasks" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 239 | <Column Name="DateCompleted" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
|
|---|
| [12878] | 240 | <Association Name="DimJob_FactTask" Member="FactTasks" ThisKey="JobId" OtherKey="JobId" Type="FactTask" />
|
|---|
| 241 | </Type>
|
|---|
| 242 | </Table>
|
|---|
| 243 | <Table Name="[statistics].DimTime" Member="DimTimes">
|
|---|
| 244 | <Type Name="DimTime">
|
|---|
| 245 | <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| [15523] | 246 | <Column Name="Minute" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| [12878] | 247 | <Column Name="Hour" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
|
|---|
| 248 | <Column Name="Day" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
|
|---|
| 249 | <Column Name="Month" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
|
|---|
| 250 | <Column Name="Year" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
|
|---|
| 251 | <Association Name="DimTime_FactClientInfo" Member="FactClientInfos" ThisKey="Time" OtherKey="Time" Type="FactClientInfo" />
|
|---|
| 252 | </Type>
|
|---|
| 253 | </Table>
|
|---|
| 254 | <Table Name="[statistics].DimUser" Member="DimUsers">
|
|---|
| 255 | <Type Name="DimUser">
|
|---|
| 256 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 257 | <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
|
|---|
| 258 | <Association Name="DimUser_FactClientInfo" Member="FactClientInfos" ThisKey="UserId" OtherKey="UserId" Type="FactClientInfo" />
|
|---|
| 259 | </Type>
|
|---|
| 260 | </Table>
|
|---|
| 261 | <Table Name="[statistics].FactClientInfo" Member="FactClientInfos">
|
|---|
| 262 | <Type Name="FactClientInfo">
|
|---|
| 263 | <Column Name="ClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| 264 | <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| [15378] | 265 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
|---|
| [12878] | 266 | <Column Name="NumUsedCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 267 | <Column Name="NumTotalCores" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 268 | <Column Name="UsedMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 269 | <Column Name="TotalMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 270 | <Column Name="CpuUtilization" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
|
|---|
| [15523] | 271 | <Column Name="SlaveState" Type="System.String" DbType="VarChar(15) NOT NULL" CanBeNull="false" />
|
|---|
| 272 | <Column Name="IdleTime" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 273 | <Column Name="OfflineTime" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 274 | <Column Name="UnavailableTime" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
|
|---|
| 275 | <Column Name="IsAllowedToCalculate" Type="System.Boolean" DbType="Bit NOT NULL" CanBeNull="false" />
|
|---|
| [12878] | 276 | <Association Name="DimClient_FactClientInfo" Member="DimClient" ThisKey="ClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" />
|
|---|
| 277 | <Association Name="DimTime_FactClientInfo" Member="DimTime" ThisKey="Time" OtherKey="Time" Type="DimTime" IsForeignKey="true" />
|
|---|
| 278 | <Association Name="DimUser_FactClientInfo" Member="DimUser" ThisKey="UserId" OtherKey="UserId" Type="DimUser" IsForeignKey="true" />
|
|---|
| 279 | </Type>
|
|---|
| 280 | </Table>
|
|---|
| [6983] | 281 | </Database> |
|---|
