Changeset 6825 for branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/ClientManagement.dbml
- Timestamp:
- 09/23/11 20:13:55 (13 years ago)
- Location:
- branches/ClientUserManagement
- Files:
-
- 2 edited
-
. (modified) (1 prop)
-
HeuristicLab.Services.Access.DataAccess/3.3/ClientManagement.dbml (modified) (3 diffs)
Legend:
- Unmodified
- Added
- Removed
-
branches/ClientUserManagement
- Property svn:ignore
-
old new 1 1 *.suo 2 *.testsettings 3 HeuristicLab.Services.Access.vsmdi
-
- Property svn:ignore
-
branches/ClientUserManagement/HeuristicLab.Services.Access.DataAccess/3.3/ClientManagement.dbml
r6820 r6825 3 3 <Table Name="dbo.Resource" Member="Resources"> 4 4 <Type Name="Resource" InheritanceCode="Resource"> 5 <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" />5 <Column Name="Id" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" /> 6 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" />7 <Column Name="Description" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="false" /> 8 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="ResourceResourceGroups 1" ThisKey="Id" OtherKey="ResourceId" Type="ResourceResourceGroup" />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 11 <Association Name="Resource_ClientLog" Member="ClientLogs" ThisKey="Id" OtherKey="ResourceId" Type="ClientLog" /> 12 <Type Name="Client" InheritanceCode="Client"> 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" /> 13 23 <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" /> 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" /> 21 28 </Type> 22 <Type Name=" Group" InheritanceCode="Group" />29 <Type Name="ClientGroup" InheritanceCode="ClientGroup" /> 23 30 </Type> 24 31 </Table> … … 27 34 <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 28 35 <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="Resource 1" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" />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" /> 31 38 </Type> 32 39 </Table> … … 36 43 <Column Name="ResourceId" Type="System.Guid" DbType="UniqueIdentifier NOT NULL" IsPrimaryKey="true" CanBeNull="false" /> 37 44 <Column Name="Message" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" /> 38 <Column Name="Exception" Type="System.String" DbType="NVarChar(MAX)" CanBeNull="true" />39 45 <Association Name="Resource_ClientLog" Member="Resource" ThisKey="ResourceId" OtherKey="Id" Type="Resource" IsForeignKey="true" /> 40 46 </Type> 41 47 </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" /> 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" /> 47 59 </Type> 48 60 </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" /> 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> 55 74 </Type> 56 75 </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" /> 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"> 60 124 <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" /> 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" /> 63 128 </Type> 64 129 </Table>
Note: See TracChangeset
for help on using the changeset viewer.
