Comunes/tsl5
10
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
main
tsl5/tsl5Model.edmx
manuel f8102dd7f1 Agregar archivos de proyecto.
2026-05-14 09:52:12 +02:00

375 lines
22 KiB
XML
Raw Permalink Blame History

<?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="tsl5Model.Store" Alias="Self" Provider="MySql.Data.MySqlClient" ProviderManifestToken="5.1" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
<EntityContainer Name="tsl5ModelStoreContainer">
<EntitySet Name="excepcionesmenus" EntityType="tsl5Model.Store.excepcionesmenus" store:Type="Tables" Schema="emtusahuelva" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="grupobd" EntityType="tsl5Model.Store.grupobd" store:Type="Tables" Schema="emtusahuelva" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="gruposmenus" EntityType="tsl5Model.Store.gruposmenus" store:Type="Tables" Schema="emtusahuelva" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="menus" EntityType="tsl5Model.Store.menus" store:Type="Tables" Schema="emtusahuelva" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<EntitySet Name="usuarios" EntityType="tsl5Model.Store.usuarios" store:Type="Tables" Schema="emtusahuelva" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" />
<AssociationSet Name="excepcionesmenus_menus" Association="tsl5Model.Store.excepcionesmenus_menus">
<End Role="menus" EntitySet="menus" />
<End Role="excepcionesmenus" EntitySet="excepcionesmenus" />
</AssociationSet>
<AssociationSet Name="excepcionesmenus_usuarios" Association="tsl5Model.Store.excepcionesmenus_usuarios">
<End Role="usuarios" EntitySet="usuarios" />
<End Role="excepcionesmenus" EntitySet="excepcionesmenus" />
</AssociationSet>
<AssociationSet Name="Menus_GruposMenus" Association="tsl5Model.Store.Menus_GruposMenus">
<End Role="gruposmenus" EntitySet="gruposmenus" />
<End Role="menus" EntitySet="menus" />
</AssociationSet>
<AssociationSet Name="Usuarios_Grupobd" Association="tsl5Model.Store.Usuarios_Grupobd">
<End Role="grupobd" EntitySet="grupobd" />
<End Role="usuarios" EntitySet="usuarios" />
</AssociationSet>
<AssociationSet Name="usuarios_gruposmenus" Association="tsl5Model.Store.usuarios_gruposmenus">
<End Role="gruposmenus" EntitySet="gruposmenus" />
<End Role="usuarios" EntitySet="usuarios" />
</AssociationSet>
</EntityContainer>
<EntityType Name="excepcionesmenus">
<Key>
<PropertyRef Name="idExcepcionesMenus" />
</Key>
<Property Name="idExcepcionesMenus" Type="int" Nullable="false" />
<Property Name="idMenu" Type="int" />
<Property Name="idUsuario" Type="int" />
</EntityType>
<EntityType Name="grupobd">
<Key>
<PropertyRef Name="idGrupoBD" />
</Key>
<Property Name="idGrupoBD" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Descripcion" Type="varchar" MaxLength="45" />
</EntityType>
<EntityType Name="gruposmenus">
<Key>
<PropertyRef Name="idGruposMenus" />
</Key>
<Property Name="idGruposMenus" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Descripcion" Type="varchar" MaxLength="45" />
</EntityType>
<EntityType Name="menus">
<Key>
<PropertyRef Name="idMenus" />
</Key>
<Property Name="idMenus" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Texto" Type="varchar" MaxLength="60" />
<Property Name="Ayuda" Type="varchar" MaxLength="255" />
<Property Name="Accion" Type="varchar" MaxLength="500" />
<Property Name="Orden" Type="int" />
<Property Name="idMenuPadre" Type="int" />
<Property Name="idGrupoMenu" Type="int" />
</EntityType>
<EntityType Name="usuarios">
<Key>
<PropertyRef Name="idUsuarios" />
</Key>
<Property Name="idUsuarios" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
<Property Name="Usuario" Type="varchar" Nullable="false" MaxLength="30" />
<Property Name="SHA1Passwd" Type="varchar" MaxLength="40" />
<Property Name="idGrupobd" Type="int" Nullable="false" />
<Property Name="idGrupomenus" Type="int" />
</EntityType>
<Association Name="excepcionesmenus_menus">
<End Role="menus" Type="tsl5Model.Store.menus" Multiplicity="0..1" />
<End Role="excepcionesmenus" Type="tsl5Model.Store.excepcionesmenus" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="menus">
<PropertyRef Name="idMenus" />
</Principal>
<Dependent Role="excepcionesmenus">
<PropertyRef Name="idMenu" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="excepcionesmenus_usuarios">
<End Role="usuarios" Type="tsl5Model.Store.usuarios" Multiplicity="0..1" />
<End Role="excepcionesmenus" Type="tsl5Model.Store.excepcionesmenus" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="usuarios">
<PropertyRef Name="idUsuarios" />
</Principal>
<Dependent Role="excepcionesmenus">
<PropertyRef Name="idUsuario" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="Menus_GruposMenus">
<End Role="gruposmenus" Type="tsl5Model.Store.gruposmenus" Multiplicity="0..1" />
<End Role="menus" Type="tsl5Model.Store.menus" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="gruposmenus">
<PropertyRef Name="idGruposMenus" />
</Principal>
<Dependent Role="menus">
<PropertyRef Name="idGrupoMenu" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="Usuarios_Grupobd">
<End Role="grupobd" Type="tsl5Model.Store.grupobd" Multiplicity="1" />
<End Role="usuarios" Type="tsl5Model.Store.usuarios" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="grupobd">
<PropertyRef Name="idGrupoBD" />
</Principal>
<Dependent Role="usuarios">
<PropertyRef Name="idGrupobd" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="usuarios_gruposmenus">
<End Role="gruposmenus" Type="tsl5Model.Store.gruposmenus" Multiplicity="0..1" />
<End Role="usuarios" Type="tsl5Model.Store.usuarios" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="gruposmenus">
<PropertyRef Name="idGruposMenus" />
</Principal>
<Dependent Role="usuarios">
<PropertyRef Name="idGrupomenus" />
</Dependent>
</ReferentialConstraint>
</Association>
</Schema>
</edmx:StorageModels>
<!-- CSDL content -->
<edmx:ConceptualModels>
<Schema Namespace="tsl5Model" Alias="Self" xmlns="http://schemas.microsoft.com/ado/2009/11/edm" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation">
<EntityContainer Name="tsl5Entities" annotation:LazyLoadingEnabled="true" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation">
<EntitySet Name="excepcionesmenus" EntityType="tsl5Model.excepcionesmenus" />
<EntitySet Name="grupobd" EntityType="tsl5Model.grupobd" />
<EntitySet Name="gruposmenus" EntityType="tsl5Model.gruposmenus" />
<EntitySet Name="menus" EntityType="tsl5Model.menus" />
<EntitySet Name="usuarios" EntityType="tsl5Model.usuarios" />
<AssociationSet Name="excepcionesmenus_menus" Association="tsl5Model.excepcionesmenus_menus">
<End Role="menus" EntitySet="menus" />
<End Role="excepcionesmenus" EntitySet="excepcionesmenus" />
</AssociationSet>
<AssociationSet Name="excepcionesmenus_usuarios" Association="tsl5Model.excepcionesmenus_usuarios">
<End Role="usuarios" EntitySet="usuarios" />
<End Role="excepcionesmenus" EntitySet="excepcionesmenus" />
</AssociationSet>
<AssociationSet Name="Usuarios_Grupobd" Association="tsl5Model.Usuarios_Grupobd">
<End Role="grupobd" EntitySet="grupobd" />
<End Role="usuarios" EntitySet="usuarios" />
</AssociationSet>
<AssociationSet Name="Menus_GruposMenus" Association="tsl5Model.Menus_GruposMenus">
<End Role="gruposmenus" EntitySet="gruposmenus" />
<End Role="menus" EntitySet="menus" />
</AssociationSet>
<AssociationSet Name="usuarios_gruposmenus" Association="tsl5Model.usuarios_gruposmenus">
<End Role="gruposmenus" EntitySet="gruposmenus" />
<End Role="usuarios" EntitySet="usuarios" />
</AssociationSet>
</EntityContainer>
<EntityType Name="excepcionesmenus">
<Key>
<PropertyRef Name="idExcepcionesMenus" />
</Key>
<Property Name="idExcepcionesMenus" Type="Int32" Nullable="false" />
<Property Name="idMenu" Type="Int32" />
<Property Name="idUsuario" Type="Int32" />
<NavigationProperty Name="menus" Relationship="tsl5Model.excepcionesmenus_menus" FromRole="excepcionesmenus" ToRole="menus" />
<NavigationProperty Name="usuarios" Relationship="tsl5Model.excepcionesmenus_usuarios" FromRole="excepcionesmenus" ToRole="usuarios" />
</EntityType>
<EntityType Name="grupobd">
<Key>
<PropertyRef Name="idGrupoBD" />
</Key>
<Property Name="idGrupoBD" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
<Property Name="Descripcion" Type="String" />
<NavigationProperty Name="usuarios" Relationship="tsl5Model.Usuarios_Grupobd" FromRole="grupobd" ToRole="usuarios" />
</EntityType>
<EntityType Name="gruposmenus">
<Key>
<PropertyRef Name="idGruposMenus" />
</Key>
<Property Name="idGruposMenus" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
<Property Name="Descripcion" Type="String" />
<NavigationProperty Name="menus" Relationship="tsl5Model.Menus_GruposMenus" FromRole="gruposmenus" ToRole="menus" />
<NavigationProperty Name="usuarios" Relationship="tsl5Model.usuarios_gruposmenus" FromRole="gruposmenus" ToRole="usuarios" />
</EntityType>
<EntityType Name="menus">
<Key>
<PropertyRef Name="idMenus" />
</Key>
<Property Name="idMenus" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
<Property Name="Texto" Type="String" />
<Property Name="Ayuda" Type="String" />
<Property Name="Accion" Type="String" />
<Property Name="Orden" Type="Int32" />
<Property Name="idMenuPadre" Type="Int32" />
<Property Name="idGrupoMenu" Type="Int32" />
<NavigationProperty Name="excepcionesmenus" Relationship="tsl5Model.excepcionesmenus_menus" FromRole="menus" ToRole="excepcionesmenus" />
<NavigationProperty Name="gruposmenus" Relationship="tsl5Model.Menus_GruposMenus" FromRole="menus" ToRole="gruposmenus" />
</EntityType>
<EntityType Name="usuarios">
<Key>
<PropertyRef Name="idUsuarios" />
</Key>
<Property Name="idUsuarios" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" />
<Property Name="Usuario" Type="String" Nullable="false" />
<Property Name="SHA1Passwd" Type="String" />
<Property Name="idGrupobd" Type="Int32" Nullable="false" />
<Property Name="idGrupomenus" Type="Int32" />
<NavigationProperty Name="excepcionesmenus" Relationship="tsl5Model.excepcionesmenus_usuarios" FromRole="usuarios" ToRole="excepcionesmenus" />
<NavigationProperty Name="grupobd" Relationship="tsl5Model.Usuarios_Grupobd" FromRole="usuarios" ToRole="grupobd" />
<NavigationProperty Name="gruposmenus" Relationship="tsl5Model.usuarios_gruposmenus" FromRole="usuarios" ToRole="gruposmenus" />
</EntityType>
<Association Name="excepcionesmenus_menus">
<End Role="menus" Type="tsl5Model.menus" Multiplicity="0..1" />
<End Role="excepcionesmenus" Type="tsl5Model.excepcionesmenus" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="menus">
<PropertyRef Name="idMenus" />
</Principal>
<Dependent Role="excepcionesmenus">
<PropertyRef Name="idMenu" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="excepcionesmenus_usuarios">
<End Role="usuarios" Type="tsl5Model.usuarios" Multiplicity="0..1" />
<End Role="excepcionesmenus" Type="tsl5Model.excepcionesmenus" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="usuarios">
<PropertyRef Name="idUsuarios" />
</Principal>
<Dependent Role="excepcionesmenus">
<PropertyRef Name="idUsuario" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="Usuarios_Grupobd">
<End Role="grupobd" Type="tsl5Model.grupobd" Multiplicity="1" />
<End Role="usuarios" Type="tsl5Model.usuarios" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="grupobd">
<PropertyRef Name="idGrupoBD" />
</Principal>
<Dependent Role="usuarios">
<PropertyRef Name="idGrupobd" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="Menus_GruposMenus">
<End Role="gruposmenus" Type="tsl5Model.gruposmenus" Multiplicity="0..1" />
<End Role="menus" Type="tsl5Model.menus" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="gruposmenus">
<PropertyRef Name="idGruposMenus" />
</Principal>
<Dependent Role="menus">
<PropertyRef Name="idGrupoMenu" />
</Dependent>
</ReferentialConstraint>
</Association>
<Association Name="usuarios_gruposmenus">
<End Role="gruposmenus" Type="tsl5Model.gruposmenus" Multiplicity="0..1" />
<End Role="usuarios" Type="tsl5Model.usuarios" Multiplicity="*" />
<ReferentialConstraint>
<Principal Role="gruposmenus">
<PropertyRef Name="idGruposMenus" />
</Principal>
<Dependent Role="usuarios">
<PropertyRef Name="idGrupomenus" />
</Dependent>
</ReferentialConstraint>
</Association>
</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="tsl5ModelStoreContainer" CdmEntityContainer="tsl5Entities">
<EntitySetMapping Name="excepcionesmenus"><EntityTypeMapping TypeName="tsl5Model.excepcionesmenus"><MappingFragment StoreEntitySet="excepcionesmenus">
<ScalarProperty Name="idExcepcionesMenus" ColumnName="idExcepcionesMenus" />
<ScalarProperty Name="idMenu" ColumnName="idMenu" />
<ScalarProperty Name="idUsuario" ColumnName="idUsuario" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="grupobd"><EntityTypeMapping TypeName="tsl5Model.grupobd"><MappingFragment StoreEntitySet="grupobd">
<ScalarProperty Name="idGrupoBD" ColumnName="idGrupoBD" />
<ScalarProperty Name="Descripcion" ColumnName="Descripcion" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="gruposmenus"><EntityTypeMapping TypeName="tsl5Model.gruposmenus"><MappingFragment StoreEntitySet="gruposmenus">
<ScalarProperty Name="idGruposMenus" ColumnName="idGruposMenus" />
<ScalarProperty Name="Descripcion" ColumnName="Descripcion" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="menus"><EntityTypeMapping TypeName="tsl5Model.menus"><MappingFragment StoreEntitySet="menus">
<ScalarProperty Name="idMenus" ColumnName="idMenus" />
<ScalarProperty Name="Texto" ColumnName="Texto" />
<ScalarProperty Name="Ayuda" ColumnName="Ayuda" />
<ScalarProperty Name="Accion" ColumnName="Accion" />
<ScalarProperty Name="Orden" ColumnName="Orden" />
<ScalarProperty Name="idMenuPadre" ColumnName="idMenuPadre" />
<ScalarProperty Name="idGrupoMenu" ColumnName="idGrupoMenu" />
</MappingFragment></EntityTypeMapping></EntitySetMapping>
<EntitySetMapping Name="usuarios"><EntityTypeMapping TypeName="tsl5Model.usuarios"><MappingFragment StoreEntitySet="usuarios">
<ScalarProperty Name="idUsuarios" ColumnName="idUsuarios" />
<ScalarProperty Name="Usuario" ColumnName="Usuario" />
<ScalarProperty Name="SHA1Passwd" ColumnName="SHA1Passwd" />
<ScalarProperty Name="idGrupobd" ColumnName="idGrupobd" />
<ScalarProperty Name="idGrupomenus" ColumnName="idGrupomenus" />
</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="False" />
<DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
</DesignerInfoPropertySet>
</Options>
<!-- Diagram content (shape and connector positions) -->
<Diagrams>
<Diagram Name="Model1" ZoomLevel="95">
<EntityTypeShape EntityType="tsl5Model.excepcionesmenus" Width="1.5" PointX="5.25" PointY="4" Height="1.9802864583333335" IsExpanded="true" />
<EntityTypeShape EntityType="tsl5Model.grupobd" Width="1.5" PointX="1.375" PointY="1.75" Height="1.5956835937499996" IsExpanded="true" />
<EntityTypeShape EntityType="tsl5Model.gruposmenus" Width="1.5" PointX="0.75" PointY="4.125" Height="1.7879850260416657" IsExpanded="true" />
<EntityTypeShape EntityType="tsl5Model.menus" Width="1.5" PointX="3" PointY="3.625" Height="2.7494921874999996" IsExpanded="true" />
<EntityTypeShape EntityType="tsl5Model.usuarios" Width="1.5" PointX="6" PointY="0.75" Height="2.5571907552083317" IsExpanded="true" />
<AssociationConnector Association="tsl5Model.excepcionesmenus_menus" ManuallyRouted="false">
<ConnectorPoint PointX="4.5" PointY="4.9901432291666667" />
<ConnectorPoint PointX="4.791666666666667" PointY="4.9901432291666659" />
<ConnectorPoint PointX="4.958333333333333" PointY="4.9901432291666667" />
<ConnectorPoint PointX="5.25" PointY="4.9901432291666667" />
</AssociationConnector>
<AssociationConnector Association="tsl5Model.excepcionesmenus_usuarios" ManuallyRouted="false">
<ConnectorPoint PointX="6.375" PointY="3.3071907552083317" />
<ConnectorPoint PointX="6.375" PointY="4" />
</AssociationConnector>
<AssociationConnector Association="tsl5Model.Usuarios_Grupobd" ManuallyRouted="false">
<ConnectorPoint PointX="4.875" PointY="7.375" />
<ConnectorPoint PointX="4.875" PointY="2.0285953776041659" />
<ConnectorPoint PointX="6" PointY="2.0285953776041659" />
</AssociationConnector>
<AssociationConnector Association="tsl5Model.Menus_GruposMenus" ManuallyRouted="false">
<ConnectorPoint PointX="2.25" PointY="5.0189925130208328" />
<ConnectorPoint PointX="3" PointY="5.0189925130208328" />
</AssociationConnector>
<AssociationConnector Association="tsl5Model.usuarios_gruposmenus" ManuallyRouted="false">
<ConnectorPoint PointX="1.5" PointY="4.125" />
<ConnectorPoint PointX="1.5" PointY="2.6991455664062496" />
<ConnectorPoint PointX="4.791666666666667" PointY="2.6991455664062491" />
<ConnectorPoint PointX="4.958333333333333" PointY="2.6991455664062496" />
<ConnectorPoint PointX="6" PointY="2.6991455664062496" />
</AssociationConnector>
</Diagram>
</Diagrams>
</Designer>
</edmx:Edmx>
Reference in New Issue View Git Blame Copy Permalink