【正文】 ) = 1)drop table [dbo].[tb_User]GOCREATE TABLE [dbo].[tb_Company] ([CompanyID] [int] IDENTITY (1, 1) NOT NULL ,[CompanyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[CompanyDirector] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[CompanyPhone] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[CompanyFax] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[CompanyAddress] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,[CompanyRemark] [nvarchar] (400) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Customer] ([CustomerID] [int] IDENTITY (1, 1) NOT NULL ,[Name] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Sex] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,[Birthday] [datetime] NULL ,[PhoneH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[PhoneM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[Address] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,[Remark] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Department] ([DepartmentID] [int] IDENTITY (1, 1) NOT NULL ,[DepName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[DepDescription] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,[DepPrincipal] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Depot] ([DepotID] [int] IDENTITY (1, 1) NOT NULL ,[DepotSort] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Goods] ([GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[UserID] [int] NULL ,《數(shù)據(jù)庫語言》課程設(shè)計(jì)說明書 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院[CompanyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[DepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsNum] [int] NULL ,[GoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsTime] [datetime] NULL ,[GoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsPrice] [money] NULL ,[SellPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[Remark] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Popedom] ([PopedomID] [int] IDENTITY (1, 1) NOT NULL ,[SysUserSort] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[SysUserName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[EmployeeInfo] [bit] NULL ,[CompanyInfo] [bit] NULL ,[CustomerInfo] [bit] NULL ,[GoodsInInfo] [bit] NULL ,[GoodsOutInfo] [bit] NULL ,[SellGoodsInfo] [bit] NULL ,[ReGoodsInfo] [bit] NULL ,[StockChangeInfo] [bit] NULL ,[StockAlarmInfo] [bit] NULL ,[SysUser] [bit] NULL ,[PopedomInfo] [bit] NULL ,[BakDataInfo] [bit] NULL ,[ReBakDataInfo] [bit] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Post] ([PostID] [int] IDENTITY (1, 1) NOT NULL ,[PostName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[PostDescription] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_ReGoods] ([ReGoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[StockID] [int] NULL ,《數(shù)據(jù)庫語言》課程設(shè)計(jì)說明書 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[UserID] [int] NULL ,[CustomerID] [int] NULL ,[CompanyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[DepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsTime] [datetime] NULL ,[ReGoodsNum] [int] NULL ,[ReGoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[ReGoodsResult] [nvarchar] (400) COLLATE Chinese_PRC_CI_AS NULL ,[ReGoodsSort] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Sell] ([SellID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,[StockID] [int] NULL ,[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[UserID] [int] NULL ,[GoodsName] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsNum] [int] NULL ,[GoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsTime] [datetime] NULL ,[GoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsPrice] [money] NULL ,[SellPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[Remark] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[tb_Stock] ([StockID] [int] IDENTITY (1, 1) NOT NULL ,[GoodsID] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[CompanyName] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,[DepotName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsName] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[StockNum] [int] NULL ,[AlarmNum] [int] NULL ,[GoodsUnit] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,《數(shù)據(jù)庫語言》課程設(shè)計(jì)說明書 計(jì)算機(jī) 067 班 王慧計(jì)算機(jī)與信息工程學(xué)院[GoodsTime] [datetime] NULL ,[GoodsSpec] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[GoodsPrice] [money] NULL ,[SellPrice] [money] NULL ,[NeedPay] [money] NULL ,[HasPay] [money] NULL ,[Remark] [nvarchar