从数据库中导出的表.sql

仓储系统

--------------------这是从数据库中导出的表-------------2003-07-30---------
--------------------可以直接执行下面的表---------------2003-07-30---------

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Customer]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Customer]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Department]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Department]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[GysArchives]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[GysArchives]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[InOutClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[InOutClass]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[JlUnit]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[JlUnit]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MateClass]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MateClass]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MateQuality]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[MateQuality]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mate_Basic]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mate_Basic]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mate_Bf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mate_Bf]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mate_CgRk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mate_CgRk]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mate_Ck]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mate_Ck]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mate_Ly]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mate_Ly]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mate_PyPk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mate_PyPk]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mate_ZzRk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Mate_ZzRk]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Pd_Type]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Pd_Type]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Product_Rk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Product_Rk]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StockUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StockUser]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[StoreRoom]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[StoreRoom]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Storeposition]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Storeposition]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[TuiLiao_Rk]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[TuiLiao_Rk]
GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[m_b]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[m_b]
GO

CREATE TABLE [dbo].[Customer] (
	[Kh_code] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Type] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Decription] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Man] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Tel] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_CourtMan] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Fax] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Zip] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Email] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_Add] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_IEAdd] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_TaxNo] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_CreditGrade] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Start_date] [datetime] NULL ,
	[End_date] [datetime] NULL ,
	[Last_TradeDate] [datetime] NULL ,
	[Last_TradeMoney] [float] NULL ,
	[Last_TradePayDate] [datetime] NULL ,
	[Last_TradePayMoney] [float] NULL ,
	[Kh_Region] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_TradeTime] [float] NULL ,
	[Kh_HangYe] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BalanceCode] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[CreditDate] [datetime] NULL ,
	[Kh_Satified] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Cor_Mark] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[Kh_memo] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Department] (
	[Dept_id] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dept_Name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dept_place] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dept_Leader] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dept_Job] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dept_Memo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[GysArchives] (
	[Gys_code] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Add] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Lxr] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Tel] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Zip] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Tax] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Khbank] [varchar] (15) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Account] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_Credit] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gys_memo] [varchar] (150) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[InOutClass] (
	[InOut_ClassNo] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[InOut_ClassName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[JlUnit] (
	[UnitNo] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[UnitName] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MateClass] (
	[MClass_No] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[MClass_Name] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MateQuality] (
	[QualityNo] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[Quality] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Mate_Basic] (
	[Xh] [smallint] IDENTITY (1, 1) NOT NULL ,
	[Mate_Code] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mate_Name] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mate_Type] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mate_Unit] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mate_Class] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[Stoc_Amount] [decimal](18, 4) NULL ,
	[Mate_Price] [money] NULL ,
	[Mate_TotalPrice] [money] NULL ,
	[ABC_Class] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mate_Quality] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[DeptNo] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[Oper_id] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mate_memo] [char] (150) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Mate_Bf] (
	[Xh] [tinyint] IDENTITY (1, 1) NOT NULL ,
	[Bf_Bill] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[Plan_id] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Mate_Code] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[Dept_id] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[Out_Date] [datetime] NULL ,
	[KfNo] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[KwNo] [char] (5) COLLATE Chinese_PRC_CI_AS NULL ,
	[Out_Type] [char] (3) COLLATE Chinese_PRC_CI_AS NULL ,
	[Out_Amount] [decimal](9, 0) NULL ,
	[Out_Price] [money] NULL ,
	[Out_Zj] [money] NULL ,
	[Out_Post] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[Bf_No] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,