📄 my_factory.sql

📁 工厂企业进销存管理系统文档是一个比软不错的软件工程入门实例
💻 SQL
字号:
IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'My_Factory')
	DROP DATABASE [My_Factory]
GO
CREATE DATABASE [My_Factory]
 COLLATE Chinese_PRC_CI_AS
GO
exec sp_dboption N'My_Factory', N'autoclose', N'true'
GO

exec sp_dboption N'My_Factory', N'bulkcopy', N'false'
GO

exec sp_dboption N'My_Factory', N'trunc. log', N'true'
GO

exec sp_dboption N'My_Factory', N'torn page detection', N'true'
GO

exec sp_dboption N'My_Factory', N'read only', N'false'
GO

exec sp_dboption N'My_Factory', N'dbo use', N'false'
GO

exec sp_dboption N'My_Factory', N'single', N'false'
GO

exec sp_dboption N'My_Factory', N'autoshrink', N'true'
GO

exec sp_dboption N'My_Factory', N'ANSI null default', N'false'
GO

exec sp_dboption N'My_Factory', N'recursive triggers', N'false'
GO

exec sp_dboption N'My_Factory', N'ANSI nulls', N'false'
GO

exec sp_dboption N'My_Factory', N'concat null yields null', N'false'
GO

exec sp_dboption N'My_Factory', N'cursor close on commit', N'false'
GO

exec sp_dboption N'My_Factory', N'default to local cursor', N'false'
GO

exec sp_dboption N'My_Factory', N'quoted identifier', N'false'
GO

exec sp_dboption N'My_Factory', N'ANSI warnings', N'false'
GO

exec sp_dboption N'My_Factory', N'auto create statistics', N'true'
GO

exec sp_dboption N'My_Factory', N'auto update statistics', N'true'
GO




use [My_Factory]
GO

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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



/***********创建产品类别表****************/
CREATE TABLE [dbo].[dm_wzlb] (
	[lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建产品信息表*****************/
CREATE TABLE [dbo].[dm_wz] (
	[dm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[jldw] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[rkj] [numeric](12, 2) NULL ,
	[fxj] [numeric](12, 2) NULL ,
	[lsj] [numeric](12, 2) NULL ,
	[cj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[yxrq] [datetime] NULL ,
	[bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建客户信息表*****************/
CREATE TABLE [dbo].[dm_kh] (
	[dm] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[yzbm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[itladd] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sui_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bank_no] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[bank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[card_no] [char] (13) COLLATE Chinese_PRC_CI_AS NULL ,
	[mb_reb] [numeric](12, 2) NULL ,
	[bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建供应商信息表*****************/
CREATE TABLE [dbo].[dm_gf] (
	[dm] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[yzbm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[itladd] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[email] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sui_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bank_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建业务员类别表*****************/
CREATE TABLE [dbo].[dm_ywylb] (
	[lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建业务员表*****************/
CREATE TABLE [dbo].[dm_ywy] (
	[dm] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mc] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[sfz] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建仓库表*****************/
CREATE TABLE [dbo].[dm_ck] (
	[dm] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建进货订单表*****************/
CREATE TABLE [dbo].[dh] (
	[in_date] [datetime] NULL ,
	[ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[dh_no] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[gfdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sl] [numeric](10, 0) NOT NULL ,
	[in_danj] [numeric](12, 2) NULL ,
	[i_zk] [numeric](5, 0) NULL ,
	[i_zke] [numeric](12, 2) NULL ,
	[bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建入库单表*****************/
CREATE TABLE [dbo].[inh] (
	[in_date] [datetime] NULL ,
	[ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[inh_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[gfdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sl] [numeric](10, 0) NOT NULL ,
	[in_danj] [numeric](12, 2) NULL ,
	[i_zk] [numeric](5, 0) NULL ,
	[i_zke] [numeric](12, 2) NULL ,
	[jsfk] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[jz] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[yf] [numeric](5, 0) NULL ,
	[bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz1] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建配料单表*****************/
CREATE TABLE [dbo].[mate] (
	[m_no] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[m_date] [datetime] NULL ,
	[wzdm1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzmc1] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[jldw1] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzdm2] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzmc2] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[jldw2] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[sl2] [numeric](18, 2) NULL ,
	[in_dj] [numeric](18, 2) NULL ,
	[jine] [numeric](18, 2) NULL ,
	[ywdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建生产计划表*****************/
CREATE TABLE [dbo].[plang] (
	[pl_no] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[pl_man] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[pl_date] [datetime] NULL ,
	[dm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[jldw] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[pl_sl] [numeric](12, 2) NULL ,
	[dj] [numeric](12, 2) NULL ,
	[jine] [numeric](12, 2) NULL ,
	[cp_date] [datetime] NULL ,
	[st_date] [datetime] NULL ,
	[bz] [text] COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

/***********创建销售订单表*****************/
CREATE TABLE [dbo].[xsdh] (
	[out_date] [datetime] NULL ,
	[ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[xsdh_no] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[khdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sl] [numeric](10, 0) NOT NULL ,
	[out_danj] [numeric](12, 2) NULL ,
	[o_zk] [numeric](5, 0) NULL ,
	[o_zke] [numeric](12, 2) NULL ,
	[bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建销售单表*****************/
CREATE TABLE [dbo].[outh] (
	[out_date] [datetime] NULL ,
	[ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[outh_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[khdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sl] [numeric](10, 0) NOT NULL ,
	[out_danj] [numeric](12, 2) NULL ,
	[o_zk] [numeric](5, 0) NULL ,
	[o_zke] [numeric](12, 2) NULL ,
	[jsfk] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[jz] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[yf] [numeric](5, 0) NULL ,
	[bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[bz1] [char] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO

/***********创建库存表*****************/
CREATE TABLE [dbo].[kucun] (
	[update_date] [datetime] NULL ,
	[kucun_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sl] [numeric](10, 0) NOT NULL ,
	[total_je] [numeric](12, 2) NULL 
) ON [PRIMARY]
GO

/***********创建转仓单表*****************/
CREATE TABLE [dbo].[zc] (
	[zc_no] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[zc_date] [datetime] NULL ,
	[ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL ,
	[o_ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[i_ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[sl] [numeric](10, 0) NOT NULL ,
	[total_je] [numeric](12, 2) NULL ,
	[bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
GO
💿 文件大小 739 K
👤 上传用户 bi_yangfeng
📂 所属分类软件工程
🏷️ 相关标签

#工厂 #进销 #管理系统 #文档
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -