315 lines
18 KiB
XML
315 lines
18 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
|
|
<!-- EF Runtime content -->
|
|
<edmx:Runtime>
|
|
<!-- SSDL content -->
|
|
<edmx:StorageModels>
|
|
<Schema Namespace="Хранилище musicschoolModel" Provider="System.Data.SqlClient" ProviderManifestToken="2008" 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/02/edm/ssdl">
|
|
<EntityType Name="Course">
|
|
<Key>
|
|
<PropertyRef Name="CourseID" />
|
|
</Key>
|
|
<Property Name="CourseID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name" Type="nvarchar" MaxLength="100" Nullable="false" />
|
|
<Property Name="Description" Type="nvarchar" MaxLength="500" />
|
|
<Property Name="Duration" Type="int" Nullable="false" />
|
|
<Property Name="Price" Type="decimal" Precision="10" Scale="2" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Enrollment">
|
|
<Key>
|
|
<PropertyRef Name="EnrollmentID" />
|
|
</Key>
|
|
<Property Name="EnrollmentID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="StudentID" Type="int" Nullable="false" />
|
|
<Property Name="CourseID" Type="int" Nullable="false" />
|
|
<Property Name="EnrollmentDate" Type="date" Nullable="false" />
|
|
<Property Name="Grade" Type="decimal" Precision="3" Scale="2" />
|
|
</EntityType>
|
|
<EntityType Name="Instruments">
|
|
<Key>
|
|
<PropertyRef Name="Id_instrument" />
|
|
</Key>
|
|
<Property Name="Id_instrument" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Name_instrument" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Date_receiving" Type="datetime" />
|
|
<Property Name="isPersonal" Type="bit" />
|
|
</EntityType>
|
|
<EntityType Name="Student">
|
|
<Key>
|
|
<PropertyRef Name="StudentID" />
|
|
</Key>
|
|
<Property Name="StudentID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="FirstName" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="BirthDate" Type="date" Nullable="false" />
|
|
<Property Name="Phone" Type="nvarchar" MaxLength="20" />
|
|
<Property Name="Email" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="photo" Type="image" />
|
|
<Property Name="Id_instrument" Type="int" />
|
|
</EntityType>
|
|
<EntityType Name="User">
|
|
<Key>
|
|
<PropertyRef Name="UserID" />
|
|
</Key>
|
|
<Property Name="UserID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="username" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="password" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="permission_level" Type="int" Nullable="false" />
|
|
</EntityType>
|
|
<Association Name="FK__Enrollmen__Cours__14270015">
|
|
<End Role="Course" Type="Self.Course" Multiplicity="1" />
|
|
<End Role="Enrollment" Type="Self.Enrollment" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Course">
|
|
<PropertyRef Name="CourseID" />
|
|
</Principal>
|
|
<Dependent Role="Enrollment">
|
|
<PropertyRef Name="CourseID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK__Enrollmen__Stude__151B244E">
|
|
<End Role="Student" Type="Self.Student" Multiplicity="1" />
|
|
<End Role="Enrollment" Type="Self.Enrollment" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Student">
|
|
<PropertyRef Name="StudentID" />
|
|
</Principal>
|
|
<Dependent Role="Enrollment">
|
|
<PropertyRef Name="StudentID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_Student_ToTable">
|
|
<End Role="Instruments" Type="Self.Instruments" Multiplicity="0..1" />
|
|
<End Role="Student" Type="Self.Student" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Instruments">
|
|
<PropertyRef Name="Id_instrument" />
|
|
</Principal>
|
|
<Dependent Role="Student">
|
|
<PropertyRef Name="Id_instrument" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityContainer Name="Хранилище musicschoolModelContainer">
|
|
<EntitySet Name="Course" EntityType="Self.Course" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Enrollment" EntityType="Self.Enrollment" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Instruments" EntityType="Self.Instruments" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Student" EntityType="Self.Student" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="User" EntityType="Self.User" Schema="dbo" store:Type="Tables" />
|
|
<AssociationSet Name="FK__Enrollmen__Cours__14270015" Association="Self.FK__Enrollmen__Cours__14270015">
|
|
<End Role="Course" EntitySet="Course" />
|
|
<End Role="Enrollment" EntitySet="Enrollment" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK__Enrollmen__Stude__151B244E" Association="Self.FK__Enrollmen__Stude__151B244E">
|
|
<End Role="Student" EntitySet="Student" />
|
|
<End Role="Enrollment" EntitySet="Enrollment" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_Student_ToTable" Association="Self.FK_Student_ToTable">
|
|
<End Role="Instruments" EntitySet="Instruments" />
|
|
<End Role="Student" EntitySet="Student" />
|
|
</AssociationSet>
|
|
</EntityContainer>
|
|
</Schema></edmx:StorageModels>
|
|
<!-- CSDL content -->
|
|
<edmx:ConceptualModels>
|
|
<Schema Namespace="musicschoolModel" Alias="Self" 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/2008/09/edm">
|
|
<EntityContainer Name="musicschoolEntities1" annotation:LazyLoadingEnabled="true">
|
|
<EntitySet Name="Course" EntityType="musicschoolModel.Course" />
|
|
<EntitySet Name="Enrollment" EntityType="musicschoolModel.Enrollment" />
|
|
<EntitySet Name="Student" EntityType="musicschoolModel.Student" />
|
|
<EntitySet Name="User" EntityType="musicschoolModel.User" />
|
|
<AssociationSet Name="FK__Enrollmen__Cours__14270015" Association="musicschoolModel.FK__Enrollmen__Cours__14270015">
|
|
<End Role="Course" EntitySet="Course" />
|
|
<End Role="Enrollment" EntitySet="Enrollment" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK__Enrollmen__Stude__151B244E" Association="musicschoolModel.FK__Enrollmen__Stude__151B244E">
|
|
<End Role="Student" EntitySet="Student" />
|
|
<End Role="Enrollment" EntitySet="Enrollment" />
|
|
</AssociationSet>
|
|
<EntitySet Name="Instruments" EntityType="musicschoolModel.Instruments" />
|
|
<AssociationSet Name="FK_Student_ToTable" Association="musicschoolModel.FK_Student_ToTable">
|
|
<End Role="Instruments" EntitySet="Instruments" />
|
|
<End Role="Student" EntitySet="Student" />
|
|
</AssociationSet>
|
|
</EntityContainer>
|
|
<EntityType Name="Course">
|
|
<Key>
|
|
<PropertyRef Name="CourseID" />
|
|
</Key>
|
|
<Property Name="CourseID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name" Type="String" Nullable="false" MaxLength="100" FixedLength="false" Unicode="true" />
|
|
<Property Name="Description" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
|
<Property Name="Duration" Type="Int32" Nullable="false" />
|
|
<Property Name="Price" Type="Decimal" Nullable="false" Precision="10" Scale="2" />
|
|
<NavigationProperty Name="Enrollment" Relationship="musicschoolModel.FK__Enrollmen__Cours__14270015" FromRole="Course" ToRole="Enrollment" />
|
|
</EntityType>
|
|
<EntityType Name="Enrollment">
|
|
<Key>
|
|
<PropertyRef Name="EnrollmentID" />
|
|
</Key>
|
|
<Property Name="EnrollmentID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="StudentID" Type="Int32" Nullable="false" />
|
|
<Property Name="CourseID" Type="Int32" Nullable="false" />
|
|
<Property Name="EnrollmentDate" Type="DateTime" Nullable="false" Precision="0" />
|
|
<Property Name="Grade" Type="Decimal" Precision="3" Scale="2" />
|
|
<NavigationProperty Name="Course" Relationship="musicschoolModel.FK__Enrollmen__Cours__14270015" FromRole="Enrollment" ToRole="Course" />
|
|
<NavigationProperty Name="Student" Relationship="musicschoolModel.FK__Enrollmen__Stude__151B244E" FromRole="Enrollment" ToRole="Student" />
|
|
</EntityType>
|
|
<EntityType Name="Student">
|
|
<Key>
|
|
<PropertyRef Name="StudentID" />
|
|
</Key>
|
|
<Property Name="StudentID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="BirthDate" Type="DateTime" Nullable="false" Precision="0" />
|
|
<Property Name="Phone" Type="String" MaxLength="20" FixedLength="false" Unicode="true" />
|
|
<Property Name="Email" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="photo" Type="Binary" MaxLength="Max" FixedLength="false" />
|
|
<NavigationProperty Name="Enrollment" Relationship="musicschoolModel.FK__Enrollmen__Stude__151B244E" FromRole="Student" ToRole="Enrollment" />
|
|
<Property Name="Id_instrument" Type="Int32" />
|
|
<NavigationProperty Name="Instruments" Relationship="musicschoolModel.FK_Student_ToTable" FromRole="Student" ToRole="Instruments" />
|
|
</EntityType>
|
|
<EntityType Name="User">
|
|
<Key>
|
|
<PropertyRef Name="UserID" />
|
|
</Key>
|
|
<Property Name="UserID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="username" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="password" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="permission_level" Type="Int32" Nullable="false" />
|
|
</EntityType>
|
|
<Association Name="FK__Enrollmen__Cours__14270015">
|
|
<End Type="musicschoolModel.Course" Role="Course" Multiplicity="1" />
|
|
<End Type="musicschoolModel.Enrollment" Role="Enrollment" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Course">
|
|
<PropertyRef Name="CourseID" />
|
|
</Principal>
|
|
<Dependent Role="Enrollment">
|
|
<PropertyRef Name="CourseID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK__Enrollmen__Stude__151B244E">
|
|
<End Type="musicschoolModel.Student" Role="Student" Multiplicity="1" />
|
|
<End Type="musicschoolModel.Enrollment" Role="Enrollment" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Student">
|
|
<PropertyRef Name="StudentID" />
|
|
</Principal>
|
|
<Dependent Role="Enrollment">
|
|
<PropertyRef Name="StudentID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="Instruments">
|
|
<Key>
|
|
<PropertyRef Name="Id_instrument" />
|
|
</Key>
|
|
<Property Name="Id_instrument" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Name_instrument" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Date_receiving" Type="DateTime" Precision="3" />
|
|
<Property Name="isPersonal" Type="Boolean" />
|
|
<NavigationProperty Name="Student" Relationship="musicschoolModel.FK_Student_ToTable" FromRole="Instruments" ToRole="Student" />
|
|
</EntityType>
|
|
<Association Name="FK_Student_ToTable">
|
|
<End Type="musicschoolModel.Instruments" Role="Instruments" Multiplicity="0..1" />
|
|
<End Type="musicschoolModel.Student" Role="Student" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Instruments">
|
|
<PropertyRef Name="Id_instrument" />
|
|
</Principal>
|
|
<Dependent Role="Student">
|
|
<PropertyRef Name="Id_instrument" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
</Schema>
|
|
</edmx:ConceptualModels>
|
|
<!-- C-S mapping content -->
|
|
<edmx:Mappings>
|
|
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
|
|
<EntityContainerMapping StorageEntityContainer="Хранилище musicschoolModelContainer" CdmEntityContainer="musicschoolEntities1">
|
|
<EntitySetMapping Name="Course">
|
|
<EntityTypeMapping TypeName="musicschoolModel.Course">
|
|
<MappingFragment StoreEntitySet="Course">
|
|
<ScalarProperty Name="Price" ColumnName="Price" />
|
|
<ScalarProperty Name="Duration" ColumnName="Duration" />
|
|
<ScalarProperty Name="Description" ColumnName="Description" />
|
|
<ScalarProperty Name="Name" ColumnName="Name" />
|
|
<ScalarProperty Name="CourseID" ColumnName="CourseID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Enrollment">
|
|
<EntityTypeMapping TypeName="musicschoolModel.Enrollment">
|
|
<MappingFragment StoreEntitySet="Enrollment">
|
|
<ScalarProperty Name="Grade" ColumnName="Grade" />
|
|
<ScalarProperty Name="EnrollmentDate" ColumnName="EnrollmentDate" />
|
|
<ScalarProperty Name="CourseID" ColumnName="CourseID" />
|
|
<ScalarProperty Name="StudentID" ColumnName="StudentID" />
|
|
<ScalarProperty Name="EnrollmentID" ColumnName="EnrollmentID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Student">
|
|
<EntityTypeMapping TypeName="musicschoolModel.Student">
|
|
<MappingFragment StoreEntitySet="Student">
|
|
<ScalarProperty Name="Id_instrument" ColumnName="Id_instrument" />
|
|
<ScalarProperty Name="photo" ColumnName="photo" />
|
|
<ScalarProperty Name="Email" ColumnName="Email" />
|
|
<ScalarProperty Name="Phone" ColumnName="Phone" />
|
|
<ScalarProperty Name="BirthDate" ColumnName="BirthDate" />
|
|
<ScalarProperty Name="LastName" ColumnName="LastName" />
|
|
<ScalarProperty Name="FirstName" ColumnName="FirstName" />
|
|
<ScalarProperty Name="StudentID" ColumnName="StudentID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="User">
|
|
<EntityTypeMapping TypeName="musicschoolModel.User">
|
|
<MappingFragment StoreEntitySet="User">
|
|
<ScalarProperty Name="permission_level" ColumnName="permission_level" />
|
|
<ScalarProperty Name="password" ColumnName="password" />
|
|
<ScalarProperty Name="username" ColumnName="username" />
|
|
<ScalarProperty Name="UserID" ColumnName="UserID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Instruments">
|
|
<EntityTypeMapping TypeName="musicschoolModel.Instruments">
|
|
<MappingFragment StoreEntitySet="Instruments">
|
|
<ScalarProperty Name="isPersonal" ColumnName="isPersonal" />
|
|
<ScalarProperty Name="Date_receiving" ColumnName="Date_receiving" />
|
|
<ScalarProperty Name="Name_instrument" ColumnName="Name_instrument" />
|
|
<ScalarProperty Name="Id_instrument" ColumnName="Id_instrument" />
|
|
</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/2008/10/edmx">
|
|
<Connection>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
|
</DesignerInfoPropertySet>
|
|
</Connection>
|
|
<Options>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
|
<DesignerProperty Name="EnablePluralization" Value="false" />
|
|
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
|
|
<DesignerProperty Name="UseLegacyProvider" Value="true" />
|
|
<DesignerProperty Name="CodeGenerationStrategy" Value="Нет" />
|
|
</DesignerInfoPropertySet>
|
|
</Options>
|
|
<!-- Diagram content (shape and connector positions) -->
|
|
<Diagrams></Diagrams>
|
|
</Designer>
|
|
</edmx:Edmx> |