Context Navigation

AccessService.dbml @ 14877

Visit:

Last change on this file since 14877 was 14748, checked in by jkarder, 8 years ago

#2743: cleaned up

updated app configs
updated settings

File size: 10.3 KB

Rev	Line
[8040]	1	<?xml version="1.0" encoding="utf-8"?><Database Name="HeuristicLab.ClientManagement" Class="AccessServiceDataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
[14748]	2	<Connection Mode="AppSettings" ConnectionString="Data Source=.\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=HeuristicLab.AccessService" SettingsObjectName="HeuristicLab.Services.Access.DataAccess.Properties.Settings" SettingsPropertyName="HeuristicLab_ClientManagementConnectionString" Provider="System.Data.SqlClient" />
[8040]	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