Context Navigation

AccessService.dbml @ 12852

Visit:

Last change on this file since 12852 was 8040, checked in by ascheibe, 13 years ago
#1648 integrated server parts of the access service into trunk
File size: 10.3 KB

Line
1	<?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.ClientManagement" Class="AccessServiceDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
2	<Connection Mode="AppSettings" ConnectionString="Data Source=.;Initial Catalog=HeuristicLab.AccessService;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" IsInheritanceDefault="true">
5	<Column Name="Id" AutoSync="OnInsert" 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="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_ResourcePlugin" Member="ResourcePlugins" ThisKey="Id" OtherKey="ResourceId" Type="ResourcePlugin" />
13	<Type Name="Client" InheritanceCode="Client">
14	<Column Name="HeuristicLabVersion" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
15	<Column Name="MemorySize" Type="System.Int32" DbType="Int" CanBeNull="true" />
16	<Column Name="Timestamp" Type="System.DateTime" DbType="DateTime" CanBeNull="true" />
17	<Column Name="NumberOfCores" Type="System.Int32" DbType="Int" CanBeNull="true" />
18	<Column Name="ProcessorType" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
19	<Column Name="ClientTypeId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
20	<Column Name="OperatingSystemId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
21	<Column Name="ClientConfigurationId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
22	<Column Name="CountryId" Type="System.Guid" DbType="UniqueIdentifier" CanBeNull="true" />
23	<Column Name="PerformanceValue" Type="System.Double" DbType="real" CanBeNull="true" />
24	<Association Name="ClientType_Client" Member="ClientType" ThisKey="ClientTypeId" OtherKey="Id" Type="ClientType" IsForeignKey="true" />
25	<Association Name="OperatingSystem_Client" Member="OperatingSystem" ThisKey="OperatingSystemId" OtherKey="Id" Type="OperatingSystem" IsForeignKey="true" />
26	<Association Name="Country_Client" Member="Country" ThisKey="CountryId" OtherKey="Id" Type="Country" IsForeignKey="true" />
27	<Association Name="ClientConfiguration_Client" Member="ClientConfiguration" ThisKey="ClientConfigurationId" OtherKey="Id" Type="ClientConfiguration" IsForeignKey="true" />
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	</Type>
58	</Table>
59	<Table Name="dbo.UserGroup" Member="UserGroupBases">
60	<Type Name="UserGroupBase" InheritanceCode="UserGroupBase" IsInheritanceDefault="true">
61	<Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
62	<Column Name="Type" Type="System.String" DbType="NVarChar(10) NOT NULL" CanBeNull="false" IsDiscriminator="true" />
63	<Association Name="UserGroupBase_UserGroupUserGroup" Member="UserGroupUserGroupsChilds" Storage="_UserGroupUserGroups" ThisKey="Id" OtherKey="UserGroupId" Type="UserGroupUserGroup" />
64	<Association Name="UserGroupBase_UserGroupUserGroup1" Member="UserGroupUserGroupsParents" Storage="_UserGroupUserGroups1" ThisKey="Id" OtherKey="UserGroupUserGroupId" Type="UserGroupUserGroup" />
65	<Type Name="User" InheritanceCode="User">
66	<Column Name="FullName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
67	</Type>
68	<Type Name="UserGroup" InheritanceCode="UserGroup">
69	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
70	</Type>
71	</Type>
72	</Table>
73	<Table Name="dbo.ClientType" Member="ClientTypes">
74	<Type Name="ClientType">
75	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
76	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
77	</Type>
78	</Table>
79	<Table Name="dbo.OperatingSystem" Member="OperatingSystems">
80	<Type Name="OperatingSystem">
81	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
82	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
83	</Type>
84	</Table>
85	<Table Name="dbo.Country" Member="Countries">
86	<Type Name="Country">
87	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
88	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
89	</Type>
90	</Table>
91	<Table Name="dbo.ClientConfiguration" Member="ClientConfigurations">
92	<Type Name="ClientConfiguration">
93	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
94	<Column Name="Hash" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
95	<Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
96	</Type>
97	</Table>
98	<Table Name="dbo.Plugin" Member="Plugins">
99	<Type Name="Plugin">
100	<Column Name="Id" AutoSync="Never" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
101	<Column Name="Name" Type="System.String" DbType="NVarChar(MAX) NOT NULL" CanBeNull="false" />
102	<Column Name="StrongName" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />
103	<Column Name="Version" Type="System.String" DbType="NVarChar(20) NOT NULL" CanBeNull="false" />
104	<Association Name="Plugin_ResourcePlugin" Member="ResourcePlugins" ThisKey="Id" OtherKey="PluginId" Type="ResourcePlugin" />
105	</Type>
106	</Table>
107	<Table Name="dbo.ResourcePlugin" Member="ResourcePlugins">
108	<Type Name="ResourcePlugin">
109	<Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
110	<Column Name="PluginId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
111	<Association Name="Plugin_ResourcePlugin" Member="Plugin" ThisKey="PluginId" OtherKey="Id" Type="Plugin" IsForeignKey="true" />
112	<Association Name="Resource_ResourcePlugin" Member="Resource" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />
113	</Type>
114	</Table>
115	<Table Name="dbo.UserGroupUserGroup" Member="UserGroupUserGroups">
116	<Type Name="UserGroupUserGroup">
117	<Column Name="UserGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
118	<Column Name="UserGroupUserGroupId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />
119	<Association Name="UserGroupBase_UserGroupUserGroup" Member="UserGroup" ThisKey="UserGroupId" OtherKey="Id" Type="UserGroupBase" IsForeignKey="true" />
120	<Association Name="UserGroupBase_UserGroupUserGroup1" Member="UserGroupBase" ThisKey="UserGroupUserGroupId" OtherKey="Id" Type="UserGroupBase" IsForeignKey="true" />
121	</Type>
122	</Table>
123	</Database>

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

Download in other formats:

Original Format