Context Navigation

ClientManagement.dbml @ 6825

Visit:

Last change on this file since 6825 was 6825, checked in by ascheibe, 13 years ago
#1648 updated the database scheme and dto's
File size: 11.6 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" IsDbGenerated="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="false" />
8	<Column Name="Type" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" IsDiscriminator="true" />
9	<Association Name="Resource_ResourceResourceGroup" Member="ResourceResourceGroupsChilds" Storage="_ResourceResourceGroups" ThisKey="Id" OtherKey="ResourceGroupId" Type="ResourceResourceGroup" />
10	<Association Name="Resource_ResourceResourceGroup1" Member="ResourceResourceGroupsParents" Storage="_ResourceResourceGroups1" ThisKey="Id" OtherKey="ResourceId" Type="ResourceResourceGroup" />
11	<Association Name="Resource_ClientLog" Member="ClientLogs" ThisKey="Id" OtherKey="ResourceId" Type="ClientLog" />
12	<Association Name="Resource_ClientError" Member="ClientErrors" ThisKey="Id" OtherKey="ClientId" Type="ClientError" />
13	<Association Name="Resource_ResourcePlugin" Member="ResourcePlugins" ThisKey="Id" OtherKey="ResourceId" Type="ResourcePlugin" />
14	<Type Name="Client" InheritanceCode="Client" IsInheritanceDefault="true">
15	<Column Name="ClientConfiguration" Member="ClientConfigurationId" Storage="_ClientConfiguration" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
16	<Column Name="ClientType" Member="ClientTypeId" Storage="_ClientType" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
17	<Column Name="HeuristicLabVersion" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="false" />
18	<Column Name="Country" Member="CountryId" Storage="_Country" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
19	<Column Name="OperatingSystem" Member="OperatingSystemId" Storage="_OperatingSystem" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="false" />
20	<Column Name="MemorySize" Type="System.Int32" DbType="Int" CanBeNull="true" />
21	<Column Name="Timestamp" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
22	<Column Name="NumberOfCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
23	<Column Name="ProcessorType" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
24	<Association Name="Client_ClientType" Member="ClientType" Storage="_ClientTypes" ThisKey="ClientTypeId" OtherKey="Id" Type="ClientType" Cardinality="One" />
25	<Association Name="Client_OperatingSystem" Member="OperatingSystem" Storage="_OperatingSystems" ThisKey="OperatingSystemId" OtherKey="Id" Type="OperatingSystem" Cardinality="One" />
26	<Association Name="Client_Country" Member="Country" Storage="_Countries" ThisKey="CountryId" OtherKey="Id" Type="Country" Cardinality="One" />
27	<Association Name="Client_ClientConfiguration" Member="ClientConfiguration" ThisKey="ClientConfigurationId" OtherKey="Id" Type="ClientConfiguration" Cardinality="One" />
28	</Type>
29	<Type Name="ClientGroup" InheritanceCode="ClientGroup" />
30	</Type>
31	</Table>
32	<Table Name="dbo.ResourceResourceGroup" Member="ResourceResourceGroups">
33	<Type Name="ResourceResourceGroup">
34	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
35	<Column Name="ResourceGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
36	<Association Name="Resource_ResourceResourceGroup" Member="ParentResource" Storage="_Resource" ThisKey="ResourceGroupId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
37	<Association Name="Resource_ResourceResourceGroup1" Member="Resource" Storage="_Resource1" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
38	</Type>
39	</Table>
40	<Table Name="dbo.ClientLog" Member="ClientLogs">
41	<Type Name="ClientLog">
42	<Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
43	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
44	<Column Name="Message" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
45	<Association Name="Resource_ClientLog" Member="Resource" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
46	</Type>
47	</Table>
48	<Table Name="dbo.ClientError" Member="ClientErrors">
49	<Type Name="ClientError">
50	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
51	<Column Name="Timestamp" Type="System.DateTime" DbType="DateTime NOT NULL" CanBeNull="false" />
52	<Column Name="Exception" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
53	<Column Name="UserComment" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
54	<Column Name="ConfigDump" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
55	<Column Name="ClientId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
56	<Column Name="UserId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
57	<Association Name="Resource_ClientError" Member="Resource" ThisKey="ClientId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
58	<Association Name="UserGroupBase_ClientError" Member="UserGroupBase" ThisKey="UserId" OtherKey="Id" Type="UserGroupBase" IsForeignKey="true" />
59	</Type>
60	</Table>
61	<Table Name="dbo.UserGroup" Member="UserGroupBases">
62	<Type Name="UserGroupBase" InheritanceCode="UserGroupBase">
63	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
64	<Column Name="Type" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" IsDiscriminator="true" />
65	<Association Name="UserGroupBase_ClientError" Member="ClientErrors" ThisKey="Id" OtherKey="UserId" Type="ClientError" />
66	<Association Name="UserGroupBase_UserGroupUserGroup" Member="UserGroupUserGroupsChilds" Storage="_UserGroupUserGroups" ThisKey="Id" OtherKey="UserGroupId" Type="UserGroupUserGroup" />
67	<Association Name="UserGroupBase_UserGroupUserGroup1" Member="UserGroupUserGroupsParents" Storage="_UserGroupUserGroups1" ThisKey="Id" OtherKey="UserGroupUserGroupId" Type="UserGroupUserGroup" />
68	<Type Name="User" InheritanceCode="User">
69	<Column Name="FullName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
70	</Type>
71	<Type Name="UserGroup" InheritanceCode="UserGroup">
72	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
73	</Type>
74	</Type>
75	</Table>
76	<Table Name="dbo.ClientType" Member="ClientTypes">
77	<Type Name="ClientType">
78	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
79	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
80	<Association Name="Client_ClientType" Member="Client" ThisKey="Id" OtherKey="ClientTypeId" Type="Client" IsForeignKey="true" />
81	</Type>
82	</Table>
83	<Table Name="dbo.OperatingSystem" Member="OperatingSystems">
84	<Type Name="OperatingSystem">
85	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
86	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
87	<Association Name="Client_OperatingSystem" Member="Client" ThisKey="Id" OtherKey="OperatingSystemId" Type="Client" IsForeignKey="true" />
88	</Type>
89	</Table>
90	<Table Name="dbo.Country" Member="Countries">
91	<Type Name="Country">
92	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
93	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
94	<Association Name="Client_Country" Member="Client" ThisKey="Id" OtherKey="CountryId" Type="Client" IsForeignKey="true" />
95	</Type>
96	</Table>
97	<Table Name="dbo.ClientConfiguration" Member="ClientConfigurations">
98	<Type Name="ClientConfiguration">
99	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
100	<Column Name="Hash" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
101	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
102	<Association Name="Client_ClientConfiguration" Member="Client" ThisKey="Id" OtherKey="ClientConfigurationId" Type="Client" IsForeignKey="true" />
103	</Type>
104	</Table>
105	<Table Name="dbo.Plugin" Member="Plugins">
106	<Type Name="Plugin">
107	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
108	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
109	<Column Name="StrongName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
110	<Column Name="Version" Type="System.String" DbType="NVarChar(20) NOT NULL" CanBeNull="false" />
111	<Association Name="Plugin_ResourcePlugin" Member="ResourcePlugins" ThisKey="Id" OtherKey="PluginId" Type="ResourcePlugin" />
112	</Type>
113	</Table>
114	<Table Name="dbo.ResourcePlugin" Member="ResourcePlugins">
115	<Type Name="ResourcePlugin">
116	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
117	<Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
118	<Association Name="Plugin_ResourcePlugin" Member="Plugin" ThisKey="PluginId" OtherKey="Id" Type="Plugin" IsForeignKey="true" />
119	<Association Name="Resource_ResourcePlugin" Member="Resource" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
120	</Type>
121	</Table>
122	<Table Name="dbo.UserGroupUserGroup" Member="UserGroupUserGroups">
123	<Type Name="UserGroupUserGroup">
124	<Column Name="UserGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
125	<Column Name="UserGroupUserGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
126	<Association Name="UserGroupBase_UserGroupUserGroup" Member="UserGroup" ThisKey="UserGroupId" OtherKey="Id" Type="UserGroupBase" IsForeignKey="true" />
127	<Association Name="UserGroupBase_UserGroupUserGroup1" Member="UserGroupBase" ThisKey="UserGroupUserGroupId" OtherKey="Id" Type="UserGroupBase" IsForeignKey="true" />
128	</Type>
129	</Table>
130	</Database>

Note: See TracBrowser for help on using the repository browser.

Download in other formats:

Original Format