<?xml version="1.0" encoding="utf-8"?>
|
<Schema Namespace="Sam_DBModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
|
<EntityType Name="Base_SysMenu">
|
<Key>
|
<PropertyRef Name="Menu_Id" />
|
</Key>
|
<Property Name="Menu_Id" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
<Property Name="ParentId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Menu_Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Menu_Tag" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Menu_Img" Type="Int32" />
|
<Property Name="SortCode" Type="Int32" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyDate" Type="DateTime" Precision="3" />
|
<Property Name="ModifyUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Menu_Type" Type="Int32" Nullable="false" />
|
</EntityType>
|
<EntityContainer Name="Sam_DBEntities" annotation:LazyLoadingEnabled="true">
|
<EntitySet Name="Base_SysMenu" EntityType="Self.Base_SysMenu" />
|
<EntitySet Name="Base_UserRight" EntityType="Sam_DBModel.Base_UserRight" />
|
<EntitySet Name="Base_Organization" EntityType="Sam_DBModel.Base_Organization" />
|
<EntitySet Name="sysdiagrams" EntityType="Sam_DBModel.sysdiagrams" />
|
<EntitySet Name="Base_StaffOrganize" EntityType="Sam_DBModel.Base_StaffOrganize" />
|
<EntitySet Name="Base_UserInfo" EntityType="Sam_DBModel.Base_UserInfo" />
|
<AssociationSet Name="FK_Base_StaffOrganize_Base_UserInfo" Association="Sam_DBModel.FK_Base_StaffOrganize_Base_UserInfo">
|
<End Role="Base_UserInfo" EntitySet="Base_UserInfo" />
|
<End Role="Base_StaffOrganize" EntitySet="Base_StaffOrganize" />
|
</AssociationSet>
|
<AssociationSet Name="FK_Base_UserRight_Base_UserInfo" Association="Sam_DBModel.FK_Base_UserRight_Base_UserInfo">
|
<End Role="Base_UserInfo" EntitySet="Base_UserInfo" />
|
<End Role="Base_UserRight" EntitySet="Base_UserRight" />
|
</AssociationSet>
|
<EntitySet Name="Base_AppendPropertyInstance" EntityType="Sam_DBModel.Base_AppendPropertyInstance" />
|
<AssociationSet Name="FK_Base_AppendPropertyInstance_Base_UserInfo" Association="Sam_DBModel.FK_Base_AppendPropertyInstance_Base_UserInfo">
|
<End Role="Base_UserInfo" EntitySet="Base_UserInfo" />
|
<End Role="Base_AppendPropertyInstance" EntitySet="Base_AppendPropertyInstance" />
|
</AssociationSet>
|
<EntitySet Name="Base_AppendProperty" EntityType="Sam_DBModel.Base_AppendProperty" />
|
<EntitySet Name="Base_RoleRight" EntityType="Sam_DBModel.Base_RoleRight" />
|
<EntitySet Name="Base_Roles" EntityType="Sam_DBModel.Base_Roles" />
|
<AssociationSet Name="FK_Base_RoleRight_Base_Roles" Association="Sam_DBModel.FK_Base_RoleRight_Base_Roles">
|
<End Role="Base_Roles" EntitySet="Base_Roles" />
|
<End Role="Base_RoleRight" EntitySet="Base_RoleRight" />
|
</AssociationSet>
|
<EntitySet Name="Base_UserRole" EntityType="Sam_DBModel.Base_UserRole" />
|
<AssociationSet Name="FK_Base_UserRole_Base_UserInfo" Association="Sam_DBModel.FK_Base_UserRole_Base_UserInfo">
|
<End Role="Base_UserInfo" EntitySet="Base_UserInfo" />
|
<End Role="Base_UserRole" EntitySet="Base_UserRole" />
|
</AssociationSet>
|
<EntitySet Name="Base_Log" EntityType="Sam_DBModel.Base_Log" />
|
</EntityContainer>
|
<EntityType Name="Base_UserRight">
|
<Key>
|
<PropertyRef Name="UserRight_ID" />
|
</Key>
|
<Property Name="UserRight_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Menu_Id" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="Base_UserInfo" Relationship="Sam_DBModel.FK_Base_UserRight_Base_UserInfo" FromRole="Base_UserRight" ToRole="Base_UserInfo" />
|
</EntityType>
|
<EntityType Name="Base_Organization">
|
<Key>
|
<PropertyRef Name="Organization_ID" />
|
</Key>
|
<Property Name="Organization_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_Code" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_InnerPhone" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_OuterPhone" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_Manager" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_AssistantManager" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_Fax" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_Zipcode" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_Address" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
|
<Property Name="ParentId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_Remark" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
|
<Property Name="SortCode" Type="Int32" />
|
<Property Name="DeleteMark" Type="Int32" />
|
<Property Name="CreateDate" Type="DateTime" Precision="0" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyDate" Type="DateTime" Precision="3" />
|
<Property Name="ModifyUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="sysdiagrams">
|
<Key>
|
<PropertyRef Name="diagram_id" />
|
</Key>
|
<Property Name="name" Type="String" Nullable="false" MaxLength="128" FixedLength="false" Unicode="true" />
|
<Property Name="principal_id" Type="Int32" Nullable="false" />
|
<Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
<Property Name="version" Type="Int32" />
|
<Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
|
</EntityType>
|
<EntityType Name="Base_StaffOrganize">
|
<Key>
|
<PropertyRef Name="StaffOrganize_Id" />
|
</Key>
|
<Property Name="StaffOrganize_Id" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Organization_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="Base_UserInfo" Relationship="Sam_DBModel.FK_Base_StaffOrganize_Base_UserInfo" FromRole="Base_StaffOrganize" ToRole="Base_UserInfo" />
|
</EntityType>
|
<EntityType Name="Base_UserInfo">
|
<Key>
|
<PropertyRef Name="User_ID" />
|
</Key>
|
<Property Name="User_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="User_Code" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="User_Account" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="User_Pwd" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="User_Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="User_Sex" Type="String" MaxLength="10" FixedLength="false" Unicode="false" />
|
<Property Name="Title" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Email" Type="String" MaxLength="20" FixedLength="false" Unicode="false" />
|
<Property Name="Theme" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="DeleteMark" Type="Int32" />
|
<Property Name="CreateDate" Type="DateTime" Precision="0" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyDate" Type="DateTime" Precision="0" />
|
<Property Name="ModifyUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="User_Remark" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="Base_StaffOrganize" Relationship="Sam_DBModel.FK_Base_StaffOrganize_Base_UserInfo" FromRole="Base_UserInfo" ToRole="Base_StaffOrganize" />
|
<NavigationProperty Name="Base_UserRight" Relationship="Sam_DBModel.FK_Base_UserRight_Base_UserInfo" FromRole="Base_UserInfo" ToRole="Base_UserRight" />
|
<NavigationProperty Name="Base_AppendPropertyInstance" Relationship="Sam_DBModel.FK_Base_AppendPropertyInstance_Base_UserInfo" FromRole="Base_UserInfo" ToRole="Base_AppendPropertyInstance" />
|
<NavigationProperty Name="Base_UserRole" Relationship="Sam_DBModel.FK_Base_UserRole_Base_UserInfo" FromRole="Base_UserInfo" ToRole="Base_UserRole" />
|
</EntityType>
|
<Association Name="FK_Base_StaffOrganize_Base_UserInfo">
|
<End Type="Sam_DBModel.Base_UserInfo" Role="Base_UserInfo" Multiplicity="0..1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Type="Sam_DBModel.Base_StaffOrganize" Role="Base_StaffOrganize" Multiplicity="*" />
|
</Association>
|
<Association Name="FK_Base_UserRight_Base_UserInfo">
|
<End Type="Sam_DBModel.Base_UserInfo" Role="Base_UserInfo" Multiplicity="0..1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Type="Sam_DBModel.Base_UserRight" Role="Base_UserRight" Multiplicity="*" />
|
</Association>
|
<EntityType Name="Base_AppendPropertyInstance">
|
<Key>
|
<PropertyRef Name="PropertyInstance_ID" />
|
</Key>
|
<Property Name="PropertyInstance_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Property_Control_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="PropertyInstance_Value" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="Base_UserInfo" Relationship="Sam_DBModel.FK_Base_AppendPropertyInstance_Base_UserInfo" FromRole="Base_AppendPropertyInstance" ToRole="Base_UserInfo" />
|
</EntityType>
|
<Association Name="FK_Base_AppendPropertyInstance_Base_UserInfo">
|
<End Type="Sam_DBModel.Base_UserInfo" Role="Base_UserInfo" Multiplicity="1" />
|
<End Type="Sam_DBModel.Base_AppendPropertyInstance" Role="Base_AppendPropertyInstance" Multiplicity="*" />
|
</Association>
|
<EntityType Name="Base_AppendProperty">
|
<Key>
|
<PropertyRef Name="Property_ID" />
|
</Key>
|
<Property Name="Property_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Property_Function" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Property_Control_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Property_Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Property_Control_DataSource" Type="String" MaxLength="Max" FixedLength="false" Unicode="false" />
|
<Property Name="Property_Control_Length" Type="Int32" Nullable="false" />
|
<Property Name="Property_Control_Style" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="SortCode" Type="Int32" />
|
<Property Name="DeleteMark" Type="Int32" />
|
<Property Name="CreateDate" Type="DateTime" Precision="0" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyDate" Type="DateTime" Precision="3" />
|
<Property Name="ModifyUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
<EntityType Name="Base_RoleRight">
|
<Key>
|
<PropertyRef Name="RoleRight_ID" />
|
</Key>
|
<Property Name="RoleRight_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Menu_Id" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="Base_Roles" Relationship="Sam_DBModel.FK_Base_RoleRight_Base_Roles" FromRole="Base_RoleRight" ToRole="Base_Roles" />
|
</EntityType>
|
<EntityType Name="Base_Roles">
|
<Key>
|
<PropertyRef Name="Roles_ID" />
|
</Key>
|
<Property Name="Roles_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ParentId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Roles_Name" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Roles_Remark" Type="String" MaxLength="200" FixedLength="false" Unicode="false" />
|
<Property Name="SortCode" Type="Int32" />
|
<Property Name="DeleteMark" Type="Int32" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyDate" Type="DateTime" Precision="3" />
|
<Property Name="ModifyUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ModifyUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="Base_RoleRight" Relationship="Sam_DBModel.FK_Base_RoleRight_Base_Roles" FromRole="Base_Roles" ToRole="Base_RoleRight" />
|
</EntityType>
|
<Association Name="FK_Base_RoleRight_Base_Roles">
|
<End Type="Sam_DBModel.Base_Roles" Role="Base_Roles" Multiplicity="0..1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Type="Sam_DBModel.Base_RoleRight" Role="Base_RoleRight" Multiplicity="*" />
|
</Association>
|
<EntityType Name="Base_UserRole">
|
<Key>
|
<PropertyRef Name="UserRole_ID" />
|
</Key>
|
<Property Name="UserRole_ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Roles_ID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateDate" Type="DateTime" Precision="3" />
|
<Property Name="CreateUserId" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<NavigationProperty Name="Base_UserInfo" Relationship="Sam_DBModel.FK_Base_UserRole_Base_UserInfo" FromRole="Base_UserRole" ToRole="Base_UserInfo" />
|
</EntityType>
|
<Association Name="FK_Base_UserRole_Base_UserInfo">
|
<End Type="Sam_DBModel.Base_UserInfo" Role="Base_UserInfo" Multiplicity="0..1" />
|
<End Type="Sam_DBModel.Base_UserRole" Role="Base_UserRole" Multiplicity="*" />
|
</Association>
|
<EntityType Name="Base_Log">
|
<Key>
|
<PropertyRef Name="LogID" />
|
</Key>
|
<Property Name="LogID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="Type" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="LogMessage" Type="String" MaxLength="500" FixedLength="false" Unicode="true" />
|
<Property Name="CreateTime" Type="DateTime" Precision="3" />
|
<Property Name="CreateUserName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="CreateUserID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="LocalIP" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
<Property Name="ClassName" Type="String" MaxLength="50" FixedLength="false" Unicode="false" />
|
</EntityType>
|
</Schema>
|