334 lines
19 KiB
XML
334 lines
19 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
|
|
<!-- EF Runtime content -->
|
|
<edmx:Runtime>
|
|
<!-- SSDL content -->
|
|
<edmx:StorageModels>
|
|
<Schema Namespace="FabApprovalTrainingModels.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
|
|
<!--Errors Found During Generation:
|
|
warning 6002: The table/view 'FabApprovalSystem.dbo.ECNTrainingBy' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
|
<EntityType Name="ECNTrainingBy">
|
|
<Key>
|
|
<PropertyRef Name="ECNNumber" />
|
|
<PropertyRef Name="AcknowledgementTrainingByID" />
|
|
</Key>
|
|
<Property Name="ECNNumber" Type="int" Nullable="false" />
|
|
<Property Name="AcknowledgementTrainingByID" Type="int" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="TECNNotificationsUsers">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="UserId" Type="int" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Training">
|
|
<Key>
|
|
<PropertyRef Name="TrainingID" />
|
|
</Key>
|
|
<Property Name="TrainingID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="ECN" Type="int" Nullable="false" />
|
|
<Property Name="StartedDate" Type="datetime" />
|
|
<Property Name="CompletedDate" Type="datetime" />
|
|
<Property Name="Status" Type="bit" />
|
|
<Property Name="Deleted" Type="bit" />
|
|
<Property Name="DeletedDate" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="TrainingAssignments">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="UserID" Type="int" Nullable="false" />
|
|
<Property Name="DateAssigned" Type="datetime" />
|
|
<Property Name="DateCompleted" Type="datetime" />
|
|
<Property Name="TrainingID" Type="int" Nullable="false" />
|
|
<Property Name="status" Type="bit" Nullable="false" />
|
|
<Property Name="FullName" Type="varchar" MaxLength="100" />
|
|
<Property Name="Deleted" Type="bit" />
|
|
<Property Name="DeletedDate" Type="datetime" />
|
|
<Property Name="LastNotification" Type="datetime" />
|
|
</EntityType>
|
|
<EntityType Name="TrainingDocAcks">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="TrainingAssignmentID" Type="int" Nullable="false" />
|
|
<Property Name="ECNNumber" Type="int" Nullable="false" />
|
|
<Property Name="AttachmentID" Type="int" Nullable="false" />
|
|
<Property Name="DateReviewed" Type="date" />
|
|
<Property Name="Reviewed" Type="bit" />
|
|
<Property Name="FileName" Type="varchar" MaxLength="300" />
|
|
<Property Name="Deleted" Type="bit" />
|
|
<Property Name="DeletedDate" Type="datetime" />
|
|
</EntityType>
|
|
<!--Errors Found During Generation:
|
|
warning 6002: The table/view 'FabApprovalSystem.dbo.TrainingGroupMembers' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
|
<EntityType Name="TrainingGroupMembers">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
<PropertyRef Name="TrainingGroupID" />
|
|
<PropertyRef Name="UserID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="TrainingGroupID" Type="int" Nullable="false" />
|
|
<Property Name="UserID" Type="int" Nullable="false" />
|
|
<Property Name="FullName" Type="varchar" MaxLength="100" />
|
|
</EntityType>
|
|
<!--Errors Found During Generation:
|
|
warning 6002: The table/view 'FabApprovalSystem.dbo.TrainingGroups' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.-->
|
|
<EntityType Name="TrainingGroups">
|
|
<Key>
|
|
<PropertyRef Name="TrainingGroupID" />
|
|
<PropertyRef Name="TrainingGroupName" />
|
|
</Key>
|
|
<Property Name="TrainingGroupID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="TrainingGroupName" Type="varchar" MaxLength="50" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="TrainingReportUsers">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="UserId" Type="int" Nullable="false" />
|
|
</EntityType>
|
|
<EntityContainer Name="FabApprovalTrainingModelsStoreContainer">
|
|
<EntitySet Name="TECNNotificationsUsers" EntityType="Self.TECNNotificationsUsers" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Training" EntityType="Self.Training" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="TrainingAssignments" EntityType="Self.TrainingAssignments" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="TrainingDocAcks" EntityType="Self.TrainingDocAcks" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="TrainingReportUsers" EntityType="Self.TrainingReportUsers" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="ECNTrainingBy" EntityType="Self.ECNTrainingBy" store:Type="Tables" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[ECNTrainingBy].[ECNNumber] AS [ECNNumber],
|
|
[ECNTrainingBy].[AcknowledgementTrainingByID] AS [AcknowledgementTrainingByID]
|
|
FROM [dbo].[ECNTrainingBy] AS [ECNTrainingBy]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="TrainingGroupMembers" EntityType="Self.TrainingGroupMembers" store:Type="Tables" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[TrainingGroupMembers].[ID] AS [ID],
|
|
[TrainingGroupMembers].[TrainingGroupID] AS [TrainingGroupID],
|
|
[TrainingGroupMembers].[UserID] AS [UserID],
|
|
[TrainingGroupMembers].[FullName] AS [FullName]
|
|
FROM [dbo].[TrainingGroupMembers] AS [TrainingGroupMembers]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="TrainingGroups" EntityType="Self.TrainingGroups" store:Type="Tables" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[TrainingGroups].[TrainingGroupID] AS [TrainingGroupID],
|
|
[TrainingGroups].[TrainingGroupName] AS [TrainingGroupName]
|
|
FROM [dbo].[TrainingGroups] AS [TrainingGroups]</DefiningQuery>
|
|
</EntitySet>
|
|
</EntityContainer>
|
|
</Schema></edmx:StorageModels>
|
|
<!-- CSDL content -->
|
|
<edmx:ConceptualModels>
|
|
<Schema Namespace="FabApprovalTrainingModels" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
|
|
<EntityType Name="TrainingGroupMember">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
<PropertyRef Name="TrainingGroupID" />
|
|
<PropertyRef Name="UserID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="TrainingGroupID" Type="Int32" Nullable="false" />
|
|
<Property Name="UserID" Type="Int32" Nullable="false" />
|
|
<Property Name="FullName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
|
</EntityType>
|
|
<EntityType Name="TrainingGroup">
|
|
<Key>
|
|
<PropertyRef Name="TrainingGroupID" />
|
|
<PropertyRef Name="TrainingGroupName" />
|
|
</Key>
|
|
<Property Name="TrainingGroupID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="TrainingGroupName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
|
</EntityType>
|
|
<EntityContainer Name="FabApprovalTrainingEntities" annotation:LazyLoadingEnabled="true">
|
|
<EntitySet Name="TrainingGroupMembers" EntityType="Self.TrainingGroupMember" />
|
|
<EntitySet Name="TrainingGroups" EntityType="Self.TrainingGroup" />
|
|
<EntitySet Name="TrainingAssignments" EntityType="FabApprovalTrainingModels.TrainingAssignment" />
|
|
<EntitySet Name="ECNTrainingBies" EntityType="FabApprovalTrainingModels.ECNTrainingBy" />
|
|
<EntitySet Name="TrainingDocAcks" EntityType="FabApprovalTrainingModels.TrainingDocAck" />
|
|
<EntitySet Name="Trainings" EntityType="FabApprovalTrainingModels.Training" />
|
|
<EntitySet Name="TrainingReportUsers" EntityType="FabApprovalTrainingModels.TrainingReportUser" />
|
|
<EntitySet Name="TECNNotificationsUsers" EntityType="FabApprovalTrainingModels.TECNNotificationsUser" />
|
|
</EntityContainer>
|
|
<EntityType Name="TrainingAssignment">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="UserID" Type="Int32" Nullable="false" />
|
|
<Property Name="DateAssigned" Type="DateTime" Precision="3" />
|
|
<Property Name="DateCompleted" Type="DateTime" Precision="3" />
|
|
<Property Name="TrainingID" Type="Int32" Nullable="false" />
|
|
<Property Name="status" Type="Boolean" Nullable="false" />
|
|
<Property Name="FullName" Type="String" MaxLength="100" FixedLength="false" Unicode="false" />
|
|
<Property Name="Deleted" Type="Boolean" />
|
|
<Property Name="DeletedDate" Type="DateTime" Precision="3" />
|
|
<Property Name="LastNotification" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="ECNTrainingBy">
|
|
<Key>
|
|
<PropertyRef Name="ECNNumber" />
|
|
<PropertyRef Name="AcknowledgementTrainingByID" />
|
|
</Key>
|
|
<Property Name="ECNNumber" Type="Int32" Nullable="false" />
|
|
<Property Name="AcknowledgementTrainingByID" Type="Int32" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="TrainingDocAck">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="TrainingAssignmentID" Type="Int32" Nullable="false" />
|
|
<Property Name="ECNNumber" Type="Int32" Nullable="false" />
|
|
<Property Name="AttachmentID" Type="Int32" Nullable="false" />
|
|
<Property Name="DateReviewed" Type="DateTime" Precision="0" />
|
|
<Property Name="Reviewed" Type="Boolean" />
|
|
<Property Name="FileName" Type="String" MaxLength="300" FixedLength="false" Unicode="false" />
|
|
<Property Name="Deleted" Type="Boolean" />
|
|
<Property Name="DeletedDate" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="Training">
|
|
<Key>
|
|
<PropertyRef Name="TrainingID" />
|
|
</Key>
|
|
<Property Name="TrainingID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="ECN" Type="Int32" Nullable="false" />
|
|
<Property Name="StartedDate" Type="DateTime" Precision="3" />
|
|
<Property Name="CompletedDate" Type="DateTime" Precision="3" />
|
|
<Property Name="Status" Type="Boolean" />
|
|
<Property Name="Deleted" Type="Boolean" />
|
|
<Property Name="DeletedDate" Type="DateTime" Precision="3" />
|
|
</EntityType>
|
|
<EntityType Name="TrainingReportUser">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="UserId" Type="Int32" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="TECNNotificationsUser">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="UserId" Type="Int32" Nullable="false" />
|
|
</EntityType>
|
|
</Schema>
|
|
</edmx:ConceptualModels>
|
|
<!-- C-S mapping content -->
|
|
<edmx:Mappings>
|
|
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
|
|
<EntityContainerMapping StorageEntityContainer="FabApprovalTrainingModelsStoreContainer" CdmEntityContainer="FabApprovalTrainingEntities">
|
|
<EntitySetMapping Name="TrainingGroupMembers">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.TrainingGroupMember">
|
|
<MappingFragment StoreEntitySet="TrainingGroupMembers">
|
|
<ScalarProperty Name="FullName" ColumnName="FullName" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="TrainingGroupID" ColumnName="TrainingGroupID" />
|
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="TrainingGroups">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.TrainingGroup">
|
|
<MappingFragment StoreEntitySet="TrainingGroups">
|
|
<ScalarProperty Name="TrainingGroupID" ColumnName="TrainingGroupID" />
|
|
<ScalarProperty Name="TrainingGroupName" ColumnName="TrainingGroupName" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="TrainingAssignments">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.TrainingAssignment">
|
|
<MappingFragment StoreEntitySet="TrainingAssignments">
|
|
<ScalarProperty Name="LastNotification" ColumnName="LastNotification" />
|
|
<ScalarProperty Name="DeletedDate" ColumnName="DeletedDate" />
|
|
<ScalarProperty Name="Deleted" ColumnName="Deleted" />
|
|
<ScalarProperty Name="FullName" ColumnName="FullName" />
|
|
<ScalarProperty Name="status" ColumnName="status" />
|
|
<ScalarProperty Name="TrainingID" ColumnName="TrainingID" />
|
|
<ScalarProperty Name="DateCompleted" ColumnName="DateCompleted" />
|
|
<ScalarProperty Name="DateAssigned" ColumnName="DateAssigned" />
|
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="ECNTrainingBies">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.ECNTrainingBy">
|
|
<MappingFragment StoreEntitySet="ECNTrainingBy">
|
|
<ScalarProperty Name="AcknowledgementTrainingByID" ColumnName="AcknowledgementTrainingByID" />
|
|
<ScalarProperty Name="ECNNumber" ColumnName="ECNNumber" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="TrainingDocAcks">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.TrainingDocAck">
|
|
<MappingFragment StoreEntitySet="TrainingDocAcks">
|
|
<ScalarProperty Name="DeletedDate" ColumnName="DeletedDate" />
|
|
<ScalarProperty Name="Deleted" ColumnName="Deleted" />
|
|
<ScalarProperty Name="FileName" ColumnName="FileName" />
|
|
<ScalarProperty Name="Reviewed" ColumnName="Reviewed" />
|
|
<ScalarProperty Name="DateReviewed" ColumnName="DateReviewed" />
|
|
<ScalarProperty Name="AttachmentID" ColumnName="AttachmentID" />
|
|
<ScalarProperty Name="ECNNumber" ColumnName="ECNNumber" />
|
|
<ScalarProperty Name="TrainingAssignmentID" ColumnName="TrainingAssignmentID" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Trainings">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.Training">
|
|
<MappingFragment StoreEntitySet="Training">
|
|
<ScalarProperty Name="DeletedDate" ColumnName="DeletedDate" />
|
|
<ScalarProperty Name="Deleted" ColumnName="Deleted" />
|
|
<ScalarProperty Name="Status" ColumnName="Status" />
|
|
<ScalarProperty Name="CompletedDate" ColumnName="CompletedDate" />
|
|
<ScalarProperty Name="StartedDate" ColumnName="StartedDate" />
|
|
<ScalarProperty Name="ECN" ColumnName="ECN" />
|
|
<ScalarProperty Name="TrainingID" ColumnName="TrainingID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="TrainingReportUsers">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.TrainingReportUser">
|
|
<MappingFragment StoreEntitySet="TrainingReportUsers">
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="TECNNotificationsUsers">
|
|
<EntityTypeMapping TypeName="FabApprovalTrainingModels.TECNNotificationsUser">
|
|
<MappingFragment StoreEntitySet="TECNNotificationsUsers">
|
|
<ScalarProperty Name="UserId" ColumnName="UserId" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
</EntityContainerMapping>
|
|
</Mapping>
|
|
</edmx:Mappings>
|
|
</edmx:Runtime>
|
|
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
|
|
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
|
|
<Connection>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
|
</DesignerInfoPropertySet>
|
|
</Connection>
|
|
<Options>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
|
<DesignerProperty Name="EnablePluralization" Value="true" />
|
|
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
|
|
<DesignerProperty Name="UseLegacyProvider" Value="false" />
|
|
<DesignerProperty Name="CodeGenerationStrategy" Value="None" />
|
|
</DesignerInfoPropertySet>
|
|
</Options>
|
|
<!-- Diagram content (shape and connector positions) -->
|
|
<Diagrams></Diagrams>
|
|
</Designer>
|
|
</edmx:Edmx> |