Free cookie consent management tool by TermsFeed Policy Generator

source: branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/ClientManagement.dbml @ 6815

Last change on this file since 6815 was 6815, checked in by ascheibe, 13 years ago

#1648

  • join user and client management to 1 project
  • completed webservice interface
File size: 5.3 KB
Line 
1<?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.ClientManagement" Class="ClientManagementDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
2  <Connection Mode="AppSettings" ConnectionString="Data Source=.;Initial Catalog=HeuristicLab.ClientManagement;Integrated Security=True" SettingsObjectName="HeuristicLab.Services.Access.DataAccess.Properties.Settings" SettingsPropertyName="HeuristicLab_ClientManagementConnectionString" Provider="System.Data.SqlClient" />
3  <Table Name="dbo.Resource" Member="Resources">
4    <Type Name="Resource" InheritanceCode="Resource">
5      <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
6      <Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
7      <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
8      <Column Name="Type" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" IsDiscriminator="true" />
9      <Association Name="Resource_ResourceResourceGroup" Member="ResourceResourceGroups" ThisKey="Id" OtherKey="ResourceGroupId" Type="ResourceResourceGroup" />
10      <Association Name="Resource_ResourceResourceGroup1" Member="ResourceResourceGroups1" ThisKey="Id" OtherKey="ResourceId" Type="ResourceResourceGroup" />
11      <Association Name="Resource_ClientLog" Member="ClientLogs" ThisKey="Id" OtherKey="ResourceId" Type="ClientLog" />
12      <Type Name="Client" InheritanceCode="Client">
13        <Column Name="ProcessorType" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
14        <Column Name="NumberOfCores" Type="System.Int32" DbType="int" CanBeNull="true" />
15        <Column Name="MemorySize" Type="System.Int32" DbType="int" CanBeNull="true" />
16        <Column Name="OperatingSystem" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
17        <Column Name="IPAddress" Storage="_IPAdresss" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
18        <Column Name="HeuristicLabVersion" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
19        <Column Name="Country" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
20      </Type>
21      <Type Name="Group" InheritanceCode="Group" />
22    </Type>
23  </Table>
24  <Table Name="dbo.ResourceResourceGroup" Member="ResourceResourceGroups">
25    <Type Name="ResourceResourceGroup">
26      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
27      <Column Name="ResourceGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
28      <Association Name="Resource_ResourceResourceGroup" Member="Resource" ThisKey="ResourceGroupId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
29      <Association Name="Resource_ResourceResourceGroup1" Member="Resource1" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
30    </Type>
31  </Table>
32  <Table Name="dbo.ClientLog" Member="ClientLogs">
33    <Type Name="ClientLog">
34      <Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
35      <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
36      <Column Name="Message" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
37      <Column Name="Exception" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
38      <Association Name="Resource_ClientLog" Member="Resource" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
39    </Type>
40  </Table>
41  <Table Name="dbo.[User]" Member="Users">
42    <Type Name="User">
43      <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
44      <Column Name="FullName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
45      <Association Name="User_UserUserGroup" Member="UserUserGroups" ThisKey="Id" OtherKey="UserId" Type="UserUserGroup" />
46    </Type>
47  </Table>
48  <Table Name="dbo.UserGroup" Member="UserGroups">
49    <Type Name="UserGroup">
50      <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
51      <Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
52      <Column Name="ParentUserGroup" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
53      <Association Name="UserGroup_UserUserGroup" Member="UserUserGroups" ThisKey="Id" OtherKey="UserGroupId" Type="UserUserGroup" />
54    </Type>
55  </Table>
56  <Table Name="dbo.UserUserGroup" Member="UserUserGroups">
57    <Type Name="UserUserGroup">
58      <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
59      <Column Name="UserGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
60      <Association Name="User_UserUserGroup" Member="User" ThisKey="UserId" OtherKey="Id" Type="User" IsForeignKey="true" />
61      <Association Name="UserGroup_UserUserGroup" Member="UserGroup" ThisKey="UserGroupId" OtherKey="Id" Type="UserGroup" IsForeignKey="true" />
62    </Type>
63  </Table>
64</Database>
Note: See TracBrowser for help on using the repository browser.