| 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> |
|---|
