开源进销存管理系统

--建立数据库 create database business go --打开数据库 use business go --建立供货商表 create table TbOffer( OfferId int primary key identity(1,1), OfferName varchar(50), OfferFactoryAddress varchar(200), OfferPostalcode varchar(15), OfferPhone varchar(15), OfferMobileTelephone varchar(11), OfferLinkman varchar(10), OfferProductId int, OfferSetAttri bit ) go --建立货品表 create table TbProduct( ProductId int primary key identity(1,1), ProductName varchar(50), ProductType varchar(50), ProductSpec varchar(50), ProductUnit varchar(50), PicOldUrl varchar(500), PicSmallUrl varchar(500), PicBigUrl varchar(500), ProductStockCount int, ProductDepotId int, ProductSummary varchar(50), ProductAttri bit ) go --建立库房表 create table TbDepot( DepotId int primary key identity(1,1), DepotName varchar(50), DepotAddress varchar(200), DepotProductSpec int, DepotSummary varchar(1000), DepotSetAttri bit ) go --建立出入库退换货表 create table TbJoinOrOutDepot( JoinOrOutDepotId int primary key identity(1,1), JoinOrOutDepotCompanyType varchar(50), JoinOrOutDepotCompanyId int, JoinOrOutDepotCompanyName varchar(50), JoinOrOutDepotProductId int, JoinOrOutDepotProductName varchar(50), JoinOrOutDepotDepotId int, JoinOrOutDepotDepotName varchar(50), JoinOrOutDepotScalar int, JoinOrOutDepotPrice float, JoinOrOutDepotPayType varchar(50), JoinOrOutDepotSendCompany varchar(50), JoinOrOutDepotSendAddress varchar(50), JoinOrOutDepotPhone varchar(15), JoinOrOutDepotBalance varchar(50), JoinOrOutDepotOurManager varchar(10), JoinOrOutDepotOurManagerName varchar(10), JoinOrOutDepotOtherManager varchar(10), JoinOrOutDepotGetTime datetime, JoinOrOutDepotStartTime datetime, JoinOrOutDepotType int, JoinOrOutDepotFatherId int, JoinOrOutDepotSummary varchar(1000), JoinOrOutDepotAttri bit ) go --建立客户信息表 create table TbSendProductClient( ClientInfoId int primary key identity(1,1), ClientInfoType varchar(20), ClientInfoCompanyName varchar(50), ClientBank varchar(50), ClientTaxNumber varchar(50), ClientInfoPaymentType varchar(50), ClientInfoSendCompany varchar(50), ClientInfoSendCompanyAddress varchar(200), ClientInfoAddress varchar(200), ClientInfoPostalcode varchar(15), ClientInfoPhone varchar(15), ClientInfoMobileTelephone varchar(11), ClientInfoLinkman varchar(10), ClientInfoProductId varchar(100), ClientInfoSummary varchar(1000), ClientInfoAttri bit ) go --记录表 create table TbLog( LogId int primary key identity(1,1), LogTouchUserId int, LogSummary varchar(50), LogTime datetime ) --用户表 create table TbUser( UserId int primary key identity(1,1), UserName varchar(20), Password varchar(32), RegNum varchar(10), UserNameOnline varchar(20), TelePhone varchar(15), UserRegTime datetime, UserAttri bit ) go --货品与仓库关联表 create table TbProductInDepot( ProductInDepotId int primary key identity(1,1), ProductInDepotDepotId int, ProductInDepotProductId int, ProductInDepotStockCount int, ProductInDepotAttri bit ) go