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 | <Column Name="ClientType" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
|
---|
21 | </Type>
|
---|
22 | <Type Name="Group" InheritanceCode="Group" />
|
---|
23 | </Type>
|
---|
24 | </Table>
|
---|
25 | <Table Name="dbo.ResourceResourceGroup" Member="ResourceResourceGroups">
|
---|
26 | <Type Name="ResourceResourceGroup">
|
---|
27 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
28 | <Column Name="ResourceGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
29 | <Association Name="Resource_ResourceResourceGroup" Member="Resource" ThisKey="ResourceGroupId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
|
---|
30 | <Association Name="Resource_ResourceResourceGroup1" Member="Resource1" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
|
---|
31 | </Type>
|
---|
32 | </Table>
|
---|
33 | <Table Name="dbo.ClientLog" Member="ClientLogs">
|
---|
34 | <Type Name="ClientLog">
|
---|
35 | <Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
36 | <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
37 | <Column Name="Message" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
|
---|
38 | <Column Name="Exception" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
|
---|
39 | <Association Name="Resource_ClientLog" Member="Resource" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
|
---|
40 | </Type>
|
---|
41 | </Table>
|
---|
42 | <Table Name="dbo.[User]" Member="Users">
|
---|
43 | <Type Name="User">
|
---|
44 | <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
45 | <Column Name="FullName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
|
---|
46 | <Association Name="User_UserUserGroup" Member="UserUserGroups" ThisKey="Id" OtherKey="UserId" Type="UserUserGroup" />
|
---|
47 | </Type>
|
---|
48 | </Table>
|
---|
49 | <Table Name="dbo.UserGroup" Member="UserGroups">
|
---|
50 | <Type Name="UserGroup">
|
---|
51 | <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
52 | <Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
|
---|
53 | <Column Name="ParentUserGroup" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
|
---|
54 | <Association Name="UserGroup_UserUserGroup" Member="UserUserGroups" ThisKey="Id" OtherKey="UserGroupId" Type="UserUserGroup" />
|
---|
55 | </Type>
|
---|
56 | </Table>
|
---|
57 | <Table Name="dbo.UserUserGroup" Member="UserUserGroups">
|
---|
58 | <Type Name="UserUserGroup">
|
---|
59 | <Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
60 | <Column Name="UserGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
|
---|
61 | <Association Name="User_UserUserGroup" Member="User" ThisKey="UserId" OtherKey="Id" Type="User" IsForeignKey="true" />
|
---|
62 | <Association Name="UserGroup_UserUserGroup" Member="UserGroup" ThisKey="UserGroupId" OtherKey="Id" Type="UserGroup" IsForeignKey="true" />
|
---|
63 | </Type>
|
---|
64 | </Table>
|
---|
65 | </Database> |
---|