Ignore:
Timestamp:
12/14/17 15:04:56 (3 years ago)
Author:
jzenisek
Message:

#2839 reverted changes from last revision (r15523)

File:
1 edited

Legend:

Unmodified
Added
Removed
  • branches/HiveProjectManagement/HeuristicLab.Services.Hive.DataAccess/3.3/HiveDataContext.dbml

    r15523 r15526  
    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>
     1<?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.Hive" Class="HiveDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
    332  <Table Name="dbo.AssignedProjectResource" Member="AssignedProjectResources">
    343    <Type Name="AssignedProjectResource">
    354      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
    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" />
    39     </Type>
    40   </Table>
    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" />
     5      <Column Name="ProjectId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     6      <Association Name="Resource_AssignedResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
     7      <Association Name="Project_AssignedResource" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" DeleteRule="CASCADE" />
    818    </Type>
    829  </Table>
    8310  <Table Name="dbo.Plugin" Member="Plugins">
    8411    <Type Name="Plugin">
    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" />
     12      <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
     13      <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
     14      <Column Name="Version" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
     15      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
     16      <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
     17      <Column Name="Hash" Type="System.Byte[]" DbType="VarBinary(20) NOT NULL" CanBeNull="false" />
    9218      <Association Name="Plugin_RequiredPlugin" Member="RequiredPlugins" ThisKey="PluginId" OtherKey="PluginId" Type="RequiredPlugin" />
    93     </Type>
    94   </Table>
    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" />
     19      <Association Name="Plugin_PluginData" Member="PluginData" ThisKey="PluginId" OtherKey="PluginId" Type="PluginData" />
    12720    </Type>
    12821  </Table>
    12922  <Table Name="dbo.RequiredPlugins" Member="RequiredPlugins">
    13023    <Type Name="RequiredPlugin">
    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" />
     24      <Column Name="RequiredPluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" UpdateCheck="Never" />
     25      <Column Name="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
    13326      <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
    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" />
     27      <Association Name="Plugin_RequiredPlugin" Member="Plugin" Storage="_PluginInfo" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" DeleteRule="CASCADE" />
     28      <Association Name="Task_RequiredPlugin" Member="Task" Storage="_Job" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
    13629    </Type>
    13730  </Table>
    13831  <Table Name="dbo.Resource" Member="Resources">
    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" />
     32    <Type Name="Resource" InheritanceCode="RESOURCE">
     33      <Column Name="ResourceId" AutoSync="OnInsert" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     34      <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
     35      <Column Name="ResourceType" Type="System.String" CanBeNull="false" IsDiscriminator="true" />
    14336      <Column Name="ParentResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
    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" />
     37      <Column Name="HbInterval" Type="System.Int32" DbType="Int" CanBeNull="false" />
    15838      <Column Name="OwnerUserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
    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" />
     39      <Association Name="Resource_AssignedResource" Member="AssignedProjectResources" Storage="_AssignedResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedProjectResource" />
     40      <Association Name="Resource_Resource" Member="ChildResources" ThisKey="ResourceId" OtherKey="ParentResourceId" Type="Resource" />
     41      <Association Name="Resource_Downtime" Member="Downtimes" Storage="_UptimeCalendars" ThisKey="ResourceId" OtherKey="ResourceId" Type="Downtime" />
    16342      <Association Name="Resource_StateLog" Member="StateLogs" ThisKey="ResourceId" OtherKey="SlaveId" Type="StateLog" />
    164       <Association Name="Resource_Resource" Member="Resource1" ThisKey="ParentResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
    165     </Type>
    166   </Table>
    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" />
     43      <Association Name="Resource_ResourcePermission" Member="ResourcePermissions" ThisKey="ResourceId" OtherKey="ResourceId" Type="ResourcePermission" />
     44      <Association Name="Resource_AssignedTaskResource" Member="AssignedTaskResources" ThisKey="ResourceId" OtherKey="ResourceId" Type="AssignedTaskResource" />
     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" />
    17862    </Type>
    17963  </Table>
    18064  <Table Name="dbo.Task" Member="Tasks">
    18165    <Type Name="Task">
    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" />
     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" />
    18569      <Column Name="LastHeartbeat" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
    186       <Column Name="ParentTaskId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
     70      <Column Name="ParentTaskId" Storage="_ParentJobId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
    18771      <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
    18872      <Column Name="CoresNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
    18973      <Column Name="MemoryNeeded" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
    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" />
     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" />
    19478      <Association Name="Task_RequiredPlugin" Member="RequiredPlugins" ThisKey="TaskId" OtherKey="TaskId" Type="RequiredPlugin" />
     79      <Association Name="Task_Task" Member="ChildJobs" Storage="_Jobs" ThisKey="TaskId" OtherKey="ParentTaskId" Type="Task" />
     80      <Association Name="Task_TaskData" Member="JobData" ThisKey="TaskId" OtherKey="TaskId" Type="TaskData" Cardinality="One" />
    19581      <Association Name="Task_StateLog" Member="StateLogs" ThisKey="TaskId" OtherKey="TaskId" Type="StateLog" />
    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" />
     82      <Association Name="Task_AssignedTaskResource" Member="AssignedTaskResources" ThisKey="TaskId" OtherKey="TaskId" Type="AssignedTaskResource" />
     83      <Association Name="Task_Task" Member="ParentJob" Storage="_Job1" ThisKey="ParentTaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
     84      <Association Name="Job_Task" Member="Job" Storage="_HiveExperiment" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
     85    </Type>
     86  </Table>
     87  <Table Name="dbo.Downtime" Member="Downtimes">
     88    <Type Name="Downtime">
     89      <Column Name="DowntimeId" Storage="_UptimeCalendarId" Type="System.Guid" DbType="UniqueIdentifier" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
     90      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
     91      <Column Name="StartDate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
     92      <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
     93      <Column Name="AllDayEvent" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
     94      <Column Name="Recurring" Type="System.Boolean" DbType="Bit" CanBeNull="false" />
     95      <Column Name="RecurringId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
     96      <Column Name="DowntimeType" Storage="_Type" Type="global::HeuristicLab.Services.Hive.DataAccess.DowntimeType" DbType="VarChar(MAX)" CanBeNull="false" />
     97      <Association Name="Resource_Downtime" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" DeleteRule="CASCADE" />
     98    </Type>
     99  </Table>
     100  <Table Name="dbo.Job" Member="Jobs">
     101    <Type Name="Job">
     102      <Column Name="JobId" Storage="_HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
     103      <Column Name="Name" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
     104      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
     105      <Column Name="ResourceIds" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
     106      <Column Name="OwnerUserId" Storage="_UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
     107      <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
     108      <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" 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      <Association Name="Project_Job" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" />
    200112    </Type>
    201113  </Table>
    202114  <Table Name="dbo.TaskData" Member="TaskDatas">
    203115    <Type Name="TaskData">
    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" />
    208     </Type>
    209   </Table>
    210   <Table Name="dbo.UserPriority" Member="UserPriorities">
     116      <Column Name="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     117      <Column Name="Data" Type="System.Byte[]" DbType="VarBinary(MAX)" CanBeNull="false" UpdateCheck="Never" IsDelayLoaded="true" />
     118      <Column Name="LastUpdate" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
     119      <Association Name="Task_TaskData" Member="Task" Storage="_Job" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
     120    </Type>
     121  </Table>
     122  <Table Name="dbo.PluginData" Member="PluginDatas">
     123    <Type Name="PluginData">
     124      <Column Name="PluginDataId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
     125      <Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     126      <Column Name="Data" Type="System.Byte[]" DbType="VarBinary(MAX) NOT NULL" CanBeNull="false" UpdateCheck="Never" IsDelayLoaded="true" />
     127      <Column Name="FileName" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
     128      <Association Name="Plugin_PluginData" Member="Plugin" ThisKey="PluginId" OtherKey="PluginId" Type="Plugin" IsForeignKey="true" />
     129    </Type>
     130  </Table>
     131  <Table Name="dbo.StateLog" Member="StateLogs">
     132    <Type Name="StateLog">
     133      <Column Name="StateLogId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
     134      <Column Name="State" Type="global::HeuristicLab.Services.Hive.DataAccess.TaskState" DbType="VarChar(30) NOT NULL" CanBeNull="false" />
     135      <Column Name="DateTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
     136      <Column Name="TaskId" Storage="_JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     137      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
     138      <Column Name="SlaveId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
     139      <Column Name="Exception" Type="System.String" DbType="VarChar(MAX)" CanBeNull="false" />
     140      <Association Name="Task_StateLog" Member="Task" Storage="_Job" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
     141      <Association Name="Resource_StateLog" Member="Resource" ThisKey="SlaveId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
     142    </Type>
     143  </Table>
     144  <Table Name="dbo.JobPermission" Member="JobPermissions">
     145    <Type Name="JobPermission">
     146      <Column Name="JobId" Storage="_HiveExperimentId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     147      <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     148      <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     149      <Column Name="Permission" Type="global::HeuristicLab.Services.Hive.DataAccess.Permission" DbType="VarChar(15) NOT NULL" CanBeNull="false" />
     150      <Association Name="Job_JobPermission" Member="Job" Storage="_HiveExperiment" ThisKey="JobId" OtherKey="JobId" Type="Job" IsForeignKey="true" />
     151    </Type>
     152  </Table>
     153  <Table Name="" Member="Lifecycles">
     154    <Type Name="Lifecycle">
     155      <Column Name="LifecycleId" Type="System.Int32" DbType="Int" IsPrimaryKey="true" CanBeNull="false" />
     156      <Column Name="LastCleanup" Type="System.DateTime" DbType="DateTime" CanBeNull="false" />
     157    </Type>
     158  </Table>
     159  <Table Name="dbo.ResourcePermission" Member="ResourcePermissions">
     160    <Type Name="ResourcePermission">
     161      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     162      <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     163      <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     164      <Association Name="Resource_ResourcePermission" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
     165    </Type>
     166  </Table>
     167  <Table Name="" Member="UserPriorities">
    211168    <Type Name="UserPriority">
    212169      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     
    216173  <Table Name="[statistics].DimClient" Member="DimClients">
    217174    <Type Name="DimClient">
    218       <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     175      <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
    219176      <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
    220177      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     
    222179      <Column Name="ResourceGroupId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
    223180      <Column Name="ResourceGroup2Id" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
    224       <Column Name="GroupName" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
    225       <Column Name="GroupName2" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
     181      <Column Name="GroupName" Type="System.String" CanBeNull="true" />
     182      <Column Name="GroupName2" Type="System.String" CanBeNull="true" />
    226183      <Association Name="DimClient_FactTask" Member="FactTasks" ThisKey="Id" OtherKey="LastClientId" Type="FactTask" />
    227184      <Association Name="DimClient_FactClientInfo" Member="FactClientInfos" ThisKey="Id" OtherKey="ClientId" Type="FactClientInfo" />
     185    </Type>
     186  </Table>
     187  <Table Name="[statistics].FactTask" Member="FactTasks">
     188    <Type Name="FactTask">
     189      <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     190      <Column Name="CalculatingTime" Storage="_TotalRuntime" Type="System.Int64" DbType="INT NOT NULL" CanBeNull="false" />
     191      <Column Name="WaitingTime" Storage="_TotalWaitingTime" Type="System.Int64" DbType="INT NOT NULL" CanBeNull="false" />
     192      <Column Name="TransferTime" Storage="_TotalTransferTime" Type="System.Int64" DbType="INT NOT NULL" CanBeNull="false" />
     193      <Column Name="NumCalculationRuns" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
     194      <Column Name="NumRetries" Storage="_NumFails" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
     195      <Column Name="CoresRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
     196      <Column Name="MemoryRequired" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
     197      <Column Name="Priority" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
     198      <Column Name="LastClientId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="true" />
     199      <Column Name="JobId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     200      <Column Name="EndTime" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="true" />
     201      <Column Name="TaskState" Type="global::HeuristicLab.Services.Hive.DataAccess.TaskState" DbType="varchar(30)" CanBeNull="false" />
     202      <Column Name="Exception" Type="System.String" DbType="varchar(MAX)" CanBeNull="true" />
     203      <Column Name="InitialWaitingTime" Storage="_InitialWaitingTimeMs" Type="System.Int64" DbType="INT" CanBeNull="false" />
     204      <Column Name="StartTime" Type="System.DateTime" CanBeNull="true" />
     205      <Association Name="DimClient_FactTask" Member="DimClient" ThisKey="LastClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" />
     206      <Association Name="DimJob_FactTask" Member="DimJob" ThisKey="JobId" OtherKey="JobId" Type="DimJob" IsForeignKey="true" />
    228207    </Type>
    229208  </Table>
     
    235214      <Column Name="UserName" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
    236215      <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    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" />
     216      <Column Name="TotalTasks" Type="System.Int32" DbType="INT NOT NULL" CanBeNull="false" />
     217      <Column Name="CompletedTasks" Type="System.Int32" DbType="INT NOT NULL" CanBeNull="false" />
     218      <Column Name="DateCompleted" Type="System.DateTime" DbType="DateTime NULL" CanBeNull="true" />
    240219      <Association Name="DimJob_FactTask" Member="FactTasks" ThisKey="JobId" OtherKey="JobId" Type="FactTask" />
    241220    </Type>
     
    244223    <Type Name="DimTime">
    245224      <Column Name="Time" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
    246       <Column Name="Minute" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    247225      <Column Name="Hour" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
    248226      <Column Name="Day" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
    249227      <Column Name="Month" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
    250228      <Column Name="Year" Type="System.DateTime" DbType="Date NOT NULL" CanBeNull="false" />
     229      <Column Name="Minute" Type="System.DateTime" CanBeNull="false" />
    251230      <Association Name="DimTime_FactClientInfo" Member="FactClientInfos" ThisKey="Time" OtherKey="Time" Type="FactClientInfo" />
    252231    </Type>
     
    269248      <Column Name="TotalMemory" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
    270249      <Column Name="CpuUtilization" Type="System.Double" DbType="Float NOT NULL" CanBeNull="false" />
    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" />
     250      <Column Name="IdleTime" Storage="_TotalTimeIdle" Type="System.Int64" DbType="INT NOT NULL" CanBeNull="false" />
     251      <Column Name="OfflineTime" Storage="_TotalTimeOffline" Type="System.Int64" DbType="INT NOT NULL" CanBeNull="false" />
     252      <Column Name="UnavailableTime" Storage="_TotalTimeUnavailable" Type="System.Int64" DbType="INT NOT NULL" CanBeNull="false" />
     253      <Column Name="SlaveState" Type="global::HeuristicLab.Services.Hive.DataAccess.SlaveState" DbType="VarChar(15)" CanBeNull="false" />
     254      <Column Name="IsAllowedToCalculate" Type="System.Boolean" DbType="BIT" CanBeNull="false" />
    276255      <Association Name="DimClient_FactClientInfo" Member="DimClient" ThisKey="ClientId" OtherKey="Id" Type="DimClient" IsForeignKey="true" />
    277256      <Association Name="DimTime_FactClientInfo" Member="DimTime" ThisKey="Time" OtherKey="Time" Type="DimTime" IsForeignKey="true" />
     
    279258    </Type>
    280259  </Table>
     260  <Table Name="dbo.Project" Member="Projects">
     261    <Type Name="Project">
     262      <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
     263      <Column Name="ParentProjectId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
     264      <Column Name="DateCreated" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
     265      <Column Name="Name" Type="System.String" DbType="VarChar(MAX) NOT NULL" CanBeNull="false" />
     266      <Column Name="Description" Type="System.String" DbType="VarChar(MAX)" CanBeNull="true" />
     267      <Column Name="OwnerUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     268      <Column Name="StartDate" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
     269      <Column Name="EndDate" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
     270      <Association Name="Project_AssignedResource" Member="AssignedProjectResources" Storage="_AssignedResources" ThisKey="ProjectId" OtherKey="ProjectId" Type="AssignedProjectResource" />
     271      <Association Name="Project_Job" Member="Jobs" ThisKey="ProjectId" OtherKey="ProjectId" Type="Job" />
     272      <Association Name="Project_Project" Member="ChildProjects" Storage="_Projects" ThisKey="ProjectId" OtherKey="ParentProjectId" Type="Project" />
     273      <Association Name="Project_ProjectPermission" Member="ProjectPermissions" ThisKey="ProjectId" OtherKey="ProjectId" Type="ProjectPermission" />
     274      <Association Name="Project_Project" Member="ParentProject" Storage="_Project1" ThisKey="ParentProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" />
     275    </Type>
     276  </Table>
     277  <Table Name="dbo.ProjectPermission" Member="ProjectPermissions">
     278    <Type Name="ProjectPermission">
     279      <Column Name="ProjectId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     280      <Column Name="GrantedUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     281      <Column Name="GrantedByUserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" CanBeNull="false" />
     282      <Association Name="Project_ProjectPermission" Member="Project" ThisKey="ProjectId" OtherKey="ProjectId" Type="Project" IsForeignKey="true" />
     283    </Type>
     284  </Table>
     285  <Table Name="dbo.AssignedTaskResource" Member="AssignedTaskResources">
     286    <Type Name="AssignedTaskResource">
     287      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     288      <Column Name="TaskId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
     289      <Association Name="Task_AssignedTaskResource" Member="Task" ThisKey="TaskId" OtherKey="TaskId" Type="Task" IsForeignKey="true" />
     290      <Association Name="Resource_AssignedTaskResource" Member="Resource" ThisKey="ResourceId" OtherKey="ResourceId" Type="Resource" IsForeignKey="true" />
     291    </Type>
     292  </Table>
    281293</Database>
Note: See TracChangeset for help on using the changeset viewer.