【文章內(nèi)容簡介】 中服裝的idPrimary keyForeign keyNoNoStore庫存量NoNoLowest庫存量下限NoNo 模式圖：（該系統(tǒng)的模式圖） 表支持的用戶事務(wù)：該系統(tǒng)的Devision視圖的數(shù)據(jù)項(xiàng)和更新/刪除事務(wù)所需的表事 務(wù)需 求 的 表錄入新管理員的詳細(xì)信息更新/刪除管理員信息。Admin(AdminID,AdminName,Password ,RealName,Email ,AddDate )；Bullet(BulID,BulTitle,BulContent,BulAddDate ,AdminID)；外鍵AdimID引用Admin(AdminID)BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；外鍵ConfirmAdminID引用Admin(AdminID)錄入新會員的詳細(xì)信息更新/刪除會員的信息。Member（MemberID,Password,MemberName,RealName,Telephone,Mobile,Email,Address,Zip ,AddDate,AccumulatePoints,Sex)BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；外鍵OrderMemberID引用Member（MemberID）錄入新服裝的詳細(xì)信息更新/刪除服裝的信息。Costume(CostumeID,CostumeName,CostumeTypeID ,CostumeStyle,CostumeBrand ,CostumeColor,CostumeSize,CostumeTexture,Addtion,AddDate,OrderDesc,CostumePrice,CostumePoint,CostumeImg,IsSpecial,SpecailPrice) 。外鍵CostumeTypeID引用CostumeType(TypeID)CostumeType(TypeID,TypeName,TypeFid,TypeHaveChild,TypeAddDate)OrderDetail(OrderDetailID,OrderID,StaffID,CostumeID,CostumeNum,OrderPrice)。外鍵CostumeID引用Costume(CostumeID)錄入新服裝類型的詳細(xì)信息更新/刪除服裝類型的信息CostumeType(TypeID,TypeName,TypeFid,TypeHaveChild,TypeAddDate)外鍵TypeFid引用CostumeType(TypeID)Costume(CostumeID,CostumeName,CostumeTypeID ,CostumeStyle,CostumeBrand ,CostumeColor,CostumeSize,CostumeTexture,Addtion,AddDate,OrderDesc,CostumePrice,CostumePoint,CostumeImg,IsSpecial,SpecailPrice) 。外鍵CostumeTypeID引用CostumeType(TypeID)錄入新的公告的詳細(xì)信息更新/刪除公告的信息Bullet(BulID,BulTitle,BulContent,BulAddDate ,AdminID,BulPoint)外鍵AdminID引用Admin（AdminID）Admin(AdminID,AdminName,Password ,RealName,Email ,AddDate )；錄入新的訂單的詳細(xì)信息更新/刪除訂單的信息BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；外鍵ConfirmAdminID引用Admin（AdmainID）Admin(AdminID,AdminName,Password ,RealName,Email ,AddDate )；外鍵OrderMemberID引用Member（MemberID）Member(MemberID,Password,MemberName,RealName,Telephone,Mobile,Email,Address,Zip ,AddDate,AccumulatePoints,Sex)OrderDetail(OrderDetailID,OrderID,StaffID,CostumeID,CostumeNum,OrderPrice)；外鍵OrderID引用BusinessOrder(OrderID)錄入新的詳細(xì)訂單的詳細(xì)信息更新/刪除詳細(xì)訂單的信息OrderDetail(OrderDetailID,OrderID,StaffID,CostumeID,CostumeNum,OrderPrice)；外鍵OrderID引用BusinessOrder（OrderID）BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；外鍵CostumeID引用Costume（CostumeID）Costume(CostumeID,CostumeName,CostumeTypeID,CostumeStyle,CostumeBrand,CostumeColor,CostumeSize,CostumeTexture,Addtion,AddDate,OrderDesc,CostumePrice,CostumePoint,CostumeImg,IsSpecial,SpecailPrice) 。列出指定服裝的詳細(xì)信息Costume(CostumeID,CostumeName,CostumeTypeID ,CostumeStyle,CostumeBrand,CostumeColor,CostumeSize,CostumeTexture,Addtion,AddDate,OrderDesc,CostumePrice,CostumePoint,CostumeImg,IsSpecial,SpecailPrice) 。外鍵CostumeTypeID引用CostumeType(TypeID)CostumeType(TypeID,TypeName,TypeFid,TypeHaveChild,TypeAddDate)列出指定類型的服裝信息CostumeType(TypeID,TypeName,TypeFid,TypeHaveChild,TypeAddDate)外鍵TypeFid引用CostumeType(TypeID)Costume(CostumeID,CostumeName,CostumeTypeID ,CostumeStyle,CostumeBrand ,CostumeColor,CostumeSize,CostumeTexture,Addtion,AddDate,OrderDesc,CostumePrice,CostumePoint,CostumeImg,IsSpecial,SpecailPrice) 。外鍵CostumeTypeID引用CostumeType(TypeID)按照指定會員的詳細(xì)信息Member(MemberID,Password,MemberName,RealName,Telephone,Mobile,Email,Address,Zip ,AddDate,AccumulatePoints,Sex)BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；外鍵OrderMemberID引用Member（MemberID）列出指定管理員的詳細(xì)信息Admin(AdminID,AdminName,Password ,RealName,Email ,AddDate )；Bullet(BulID,BulTitle,BulContent,BulAddDate ,AdminID)；外鍵AdimID引用Admin(AdminID)BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；外鍵ConfirmAdminID引用Admin(AdminID)列出指定公告的發(fā)布管理員的信息Bullet(BulID,BulTitle,BulContent,BulAddDate ,AdminID,BulPoint)外鍵AdminID引用Admin（AdminID）Admin(AdminID,AdminName,Password ,RealName,Email ,AddDate )；列出指定訂單所對應(yīng)的各詳細(xì)訂單的信息，按詳細(xì)訂單號排序BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；OrderDetail(OrderDetailID,OrderID,CostumeID,CostumeNum,OrderPrice)；外鍵OrderID引用BusinessOrder(OrderID)列出指定訂單所對應(yīng)的會員的詳細(xì)信息BusinessOrder(OrderID,OrderTime,OrderIsConfirm,ConfirmTime,ConfirmAdminID,OrderSendStatus,OrderRecName,OrderAddress,OrderZip,OrderMemberID,OrderTotalPrice,OrderEmail)；外鍵OrderMemberID引用Member（MemberID）Member(MemberID,Password,MemberName,RealName,Telephone,Mobile,Email,Address,Zip ,AddDate,AccumulatePoints,Sex)列出指定的詳細(xì)訂單所對應(yīng)的服裝的詳細(xì)信息OrderDetail(OrderDetailID,OrderID,CostumeID,CostumeNum,OrderPrice)；外鍵CostumeID引用Costume（CostumeID）Costume(CostumeID,CostumeName,CostumeTypeID ,CostumeStyle,CostumeBrand ,CostumeColor,CostumeSize,CostumeTexture,Addtion,AddDate,OrderDesc,CostumePrice,CostumePoint,CostumeImg,IsSpecial,SpecailPrice) 。 設(shè)計(jì)基本表 ：216。 Admin：1. 表名: Admin 2. 所有者 ：dbo：CREATE TABLE [dbo].[Admin] ( [AdminID] [int] IDENTITY (1000, 1) NOT NULL , [AdminName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Actor] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [Password] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [RealName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [Email] [varchar] (200) COLLATE Chinese_PRC_CI_AS NOT NULL , [AddDate] [datetime] NOT NULL ) ON [PRIMARY]GO4. 權(quán)限管理：RANT SELECT , UPDATE , INSERT , DELETE ON [dbo].[Admin] TO [超級管理員]GOGRANT