<?xml version="1.0" encoding="utf-8"?>
|
<Schema Namespace="Sam_DBModel.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">
|
<EntityType Name="Base_AppendProperty">
|
<Key>
|
<PropertyRef Name="Property_ID" />
|
</Key>
|
<Property Name="Property_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="Property_Function" Type="varchar" MaxLength="50" />
|
<Property Name="Property_Control_ID" Type="varchar" MaxLength="50" />
|
<Property Name="Property_Name" Type="varchar" MaxLength="50" />
|
<Property Name="Property_Control_DataSource" Type="varchar(max)" />
|
<Property Name="Property_Control_Length" Type="int" Nullable="false" />
|
<Property Name="Property_Control_Style" Type="varchar" MaxLength="50" />
|
<Property Name="SortCode" Type="int" />
|
<Property Name="DeleteMark" Type="int" />
|
<Property Name="CreateDate" Type="date" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyDate" Type="datetime" />
|
<Property Name="ModifyUserId" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyUserName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="Base_AppendPropertyInstance">
|
<Key>
|
<PropertyRef Name="PropertyInstance_ID" />
|
</Key>
|
<Property Name="PropertyInstance_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="Property_Control_ID" Type="varchar" MaxLength="50" />
|
<Property Name="PropertyInstance_Value" Type="varchar(max)" />
|
<Property Name="PropertyInstance_Key" Type="varchar" MaxLength="50" Nullable="false" />
|
</EntityType>
|
<EntityType Name="Base_Log">
|
<Key>
|
<PropertyRef Name="LogID" />
|
</Key>
|
<Property Name="LogID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="Type" Type="varchar" MaxLength="50" />
|
<Property Name="LogMessage" Type="nvarchar" MaxLength="500" />
|
<Property Name="CreateTime" Type="datetime" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserID" Type="varchar" MaxLength="50" />
|
<Property Name="LocalIP" Type="varchar" MaxLength="50" />
|
<Property Name="ClassName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="Base_Organization">
|
<Key>
|
<PropertyRef Name="Organization_ID" />
|
</Key>
|
<Property Name="Organization_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="Organization_Code" Type="varchar" MaxLength="20" />
|
<Property Name="Organization_Name" Type="varchar" MaxLength="50" />
|
<Property Name="Organization_InnerPhone" Type="varchar" MaxLength="20" />
|
<Property Name="Organization_OuterPhone" Type="varchar" MaxLength="20" />
|
<Property Name="Organization_Manager" Type="varchar" MaxLength="50" />
|
<Property Name="Organization_AssistantManager" Type="varchar" MaxLength="50" />
|
<Property Name="Organization_Fax" Type="varchar" MaxLength="20" />
|
<Property Name="Organization_Zipcode" Type="varchar" MaxLength="20" />
|
<Property Name="Organization_Address" Type="varchar" MaxLength="200" />
|
<Property Name="ParentId" Type="varchar" MaxLength="50" />
|
<Property Name="Organization_Remark" Type="varchar" MaxLength="200" />
|
<Property Name="SortCode" Type="int" />
|
<Property Name="DeleteMark" Type="int" />
|
<Property Name="CreateDate" Type="date" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyDate" Type="datetime" />
|
<Property Name="ModifyUserId" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyUserName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="Base_RoleRight">
|
<Key>
|
<PropertyRef Name="RoleRight_ID" />
|
</Key>
|
<Property Name="RoleRight_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="Roles_ID" Type="varchar" MaxLength="50" />
|
<Property Name="Menu_Id" Type="varchar" MaxLength="50" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="Base_Roles">
|
<Key>
|
<PropertyRef Name="Roles_ID" />
|
</Key>
|
<Property Name="Roles_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="ParentId" Type="varchar" MaxLength="50" />
|
<Property Name="Roles_Name" Type="varchar" MaxLength="50" />
|
<Property Name="Roles_Remark" Type="varchar" MaxLength="200" />
|
<Property Name="SortCode" Type="int" />
|
<Property Name="DeleteMark" Type="int" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyDate" Type="datetime" />
|
<Property Name="ModifyUserId" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyUserName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="Base_StaffOrganize">
|
<Key>
|
<PropertyRef Name="StaffOrganize_Id" />
|
</Key>
|
<Property Name="StaffOrganize_Id" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="Organization_ID" Type="varchar" MaxLength="50" />
|
<Property Name="User_ID" Type="varchar" MaxLength="50" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="Base_SysMenu">
|
<Key>
|
<PropertyRef Name="Menu_Id" />
|
</Key>
|
<Property Name="Menu_Id" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="ParentId" Type="varchar" MaxLength="50" />
|
<Property Name="Menu_Name" Type="varchar" MaxLength="50" />
|
<Property Name="Menu_Tag" Type="varchar" MaxLength="50" />
|
<Property Name="Menu_Img" Type="int" />
|
<Property Name="SortCode" Type="int" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyDate" Type="datetime" />
|
<Property Name="ModifyUserId" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyUserName" Type="varchar" MaxLength="50" />
|
<Property Name="Menu_Type" Type="int" Nullable="false" />
|
</EntityType>
|
<EntityType Name="Base_UserInfo">
|
<Key>
|
<PropertyRef Name="User_ID" />
|
</Key>
|
<Property Name="User_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="User_Code" Type="varchar" MaxLength="50" />
|
<Property Name="User_Account" Type="varchar" MaxLength="50" />
|
<Property Name="User_Pwd" Type="varchar" MaxLength="50" />
|
<Property Name="User_Name" Type="varchar" MaxLength="50" />
|
<Property Name="User_Sex" Type="varchar" MaxLength="10" />
|
<Property Name="Title" Type="varchar" MaxLength="50" />
|
<Property Name="Email" Type="varchar" MaxLength="20" />
|
<Property Name="Theme" Type="varchar" MaxLength="50" />
|
<Property Name="DeleteMark" Type="int" />
|
<Property Name="CreateDate" Type="date" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyDate" Type="date" />
|
<Property Name="ModifyUserId" Type="varchar" MaxLength="50" />
|
<Property Name="ModifyUserName" Type="varchar" MaxLength="50" />
|
<Property Name="User_Remark" Type="varchar(max)" />
|
</EntityType>
|
<EntityType Name="Base_UserRight">
|
<Key>
|
<PropertyRef Name="UserRight_ID" />
|
</Key>
|
<Property Name="UserRight_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="User_ID" Type="varchar" MaxLength="50" />
|
<Property Name="Menu_Id" Type="varchar" MaxLength="50" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="Base_UserRole">
|
<Key>
|
<PropertyRef Name="UserRole_ID" />
|
</Key>
|
<Property Name="UserRole_ID" Type="varchar" MaxLength="50" Nullable="false" />
|
<Property Name="User_ID" Type="varchar" MaxLength="50" />
|
<Property Name="Roles_ID" Type="varchar" MaxLength="50" />
|
<Property Name="CreateDate" Type="datetime" />
|
<Property Name="CreateUserId" Type="varchar" MaxLength="50" />
|
<Property Name="CreateUserName" Type="varchar" MaxLength="50" />
|
</EntityType>
|
<EntityType Name="sysdiagrams">
|
<Key>
|
<PropertyRef Name="diagram_id" />
|
</Key>
|
<Property Name="name" Type="nvarchar" MaxLength="128" Nullable="false" />
|
<Property Name="principal_id" Type="int" Nullable="false" />
|
<Property Name="diagram_id" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
<Property Name="version" Type="int" />
|
<Property Name="definition" Type="varbinary(max)" />
|
</EntityType>
|
<Association Name="FK_Base_AppendPropertyInstance_Base_UserInfo">
|
<End Role="Base_UserInfo" Type="Self.Base_UserInfo" Multiplicity="1" />
|
<End Role="Base_AppendPropertyInstance" Type="Self.Base_AppendPropertyInstance" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="Base_UserInfo">
|
<PropertyRef Name="User_ID" />
|
</Principal>
|
<Dependent Role="Base_AppendPropertyInstance">
|
<PropertyRef Name="PropertyInstance_Key" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_Base_RoleRight_Base_Roles">
|
<End Role="Base_Roles" Type="Self.Base_Roles" Multiplicity="0..1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="Base_RoleRight" Type="Self.Base_RoleRight" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="Base_Roles">
|
<PropertyRef Name="Roles_ID" />
|
</Principal>
|
<Dependent Role="Base_RoleRight">
|
<PropertyRef Name="Roles_ID" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_Base_StaffOrganize_Base_UserInfo">
|
<End Role="Base_UserInfo" Type="Self.Base_UserInfo" Multiplicity="0..1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="Base_StaffOrganize" Type="Self.Base_StaffOrganize" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="Base_UserInfo">
|
<PropertyRef Name="User_ID" />
|
</Principal>
|
<Dependent Role="Base_StaffOrganize">
|
<PropertyRef Name="User_ID" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_Base_UserRight_Base_UserInfo">
|
<End Role="Base_UserInfo" Type="Self.Base_UserInfo" Multiplicity="0..1">
|
<OnDelete Action="Cascade" />
|
</End>
|
<End Role="Base_UserRight" Type="Self.Base_UserRight" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="Base_UserInfo">
|
<PropertyRef Name="User_ID" />
|
</Principal>
|
<Dependent Role="Base_UserRight">
|
<PropertyRef Name="User_ID" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<Association Name="FK_Base_UserRole_Base_UserInfo">
|
<End Role="Base_UserInfo" Type="Self.Base_UserInfo" Multiplicity="0..1" />
|
<End Role="Base_UserRole" Type="Self.Base_UserRole" Multiplicity="*" />
|
<ReferentialConstraint>
|
<Principal Role="Base_UserInfo">
|
<PropertyRef Name="User_ID" />
|
</Principal>
|
<Dependent Role="Base_UserRole">
|
<PropertyRef Name="User_ID" />
|
</Dependent>
|
</ReferentialConstraint>
|
</Association>
|
<EntityContainer Name="Sam_DBModelStoreContainer">
|
<EntitySet Name="Base_AppendProperty" EntityType="Self.Base_AppendProperty" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_AppendPropertyInstance" EntityType="Self.Base_AppendPropertyInstance" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_Log" EntityType="Self.Base_Log" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_Organization" EntityType="Self.Base_Organization" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_RoleRight" EntityType="Self.Base_RoleRight" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_Roles" EntityType="Self.Base_Roles" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_StaffOrganize" EntityType="Self.Base_StaffOrganize" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_SysMenu" EntityType="Self.Base_SysMenu" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_UserInfo" EntityType="Self.Base_UserInfo" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_UserRight" EntityType="Self.Base_UserRight" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="Base_UserRole" EntityType="Self.Base_UserRole" Schema="dbo" store:Type="Tables" />
|
<EntitySet Name="sysdiagrams" EntityType="Self.sysdiagrams" Schema="dbo" store:Type="Tables" />
|
<AssociationSet Name="FK_Base_AppendPropertyInstance_Base_UserInfo" Association="Self.FK_Base_AppendPropertyInstance_Base_UserInfo">
|
<End Role="Base_UserInfo" EntitySet="Base_UserInfo" />
|
<End Role="Base_AppendPropertyInstance" EntitySet="Base_AppendPropertyInstance" />
|
</AssociationSet>
|
<AssociationSet Name="FK_Base_RoleRight_Base_Roles" Association="Self.FK_Base_RoleRight_Base_Roles">
|
<End Role="Base_Roles" EntitySet="Base_Roles" />
|
<End Role="Base_RoleRight" EntitySet="Base_RoleRight" />
|
</AssociationSet>
|
<AssociationSet Name="FK_Base_StaffOrganize_Base_UserInfo" Association="Self.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="Self.FK_Base_UserRight_Base_UserInfo">
|
<End Role="Base_UserInfo" EntitySet="Base_UserInfo" />
|
<End Role="Base_UserRight" EntitySet="Base_UserRight" />
|
</AssociationSet>
|
<AssociationSet Name="FK_Base_UserRole_Base_UserInfo" Association="Self.FK_Base_UserRole_Base_UserInfo">
|
<End Role="Base_UserInfo" EntitySet="Base_UserInfo" />
|
<End Role="Base_UserRole" EntitySet="Base_UserRole" />
|
</AssociationSet>
|
</EntityContainer>
|
</Schema>
|