C#超市管理信息系统

CREATE TABLE [dbo].[MarketMember] ( [MemberID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [MemberCard] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [MemberName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [MemberPhone] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [MemberAddress] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [TotalCost] [money] NULL , [RegDate] [smalldatetime] NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Merch] ( [MerchID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [MerchName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [MerchPrice] [smallmoney] NOT NULL , [MerchNum] [int] NOT NULL , [WarningNum] [int] NOT NULL , [PlanNum] [int] NOT NULL , [ProSalesPrice] [smallmoney] NULL , [ProSalesDateS] [smalldatetime] NULL , [ProSalesDateE] [smalldatetime] NULL , [AllowAbate] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [AllowSale] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [Factory] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Sale] ( [SaleID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [MerchID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [SaleDate] [smalldatetime] NOT NULL , [SaleNum] [int] NOT NULL , [SalePrice] [money] NOT NULL , [Salesman] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[Stock] ( [StockID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [MerchID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [MerchNum] [int] NOT NULL , [MerchPrice] [money] NOT NULL , [TotalPrice] [money] NOT NULL , [StockDate] [smalldatetime] NOT NULL , [DealMan] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [Finished] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL , [Remark] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[SyUser] ( [UserID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [UserName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [UserPW] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL , [UserStyle] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY] GO