📄 rs.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 2 页
字号:
上一页 12
	[GSXM] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[COUNTER] [decimal](9, 2) NULL ,
	[Time] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGGSF]    Script Date: 2003-6-2 17:24:45 ******/
CREATE TABLE [dbo].[tRS_TZGGSF] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fldDate] [datetime] NULL ,
	[DWFDFY] [decimal](9, 2) NULL ,
	[TCFDFY] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGGSHZ]    Script Date: 2003-6-2 17:24:45 ******/
CREATE TABLE [dbo].[tRS_TZGGSHZ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DLBZTG] [decimal](9, 2) NULL ,
	[YCLQFTG] [decimal](9, 2) NULL ,
	[SBJCTG] [decimal](9, 2) NULL ,
	[WSCRWTG] [decimal](9, 2) NULL ,
	[HD] [decimal](9, 2) NULL ,
	[XX] [decimal](9, 2) NULL ,
	[JJRJB] [decimal](9, 2) NULL ,
	[GZRJB] [decimal](9, 2) NULL ,
	[GXJJB] [decimal](9, 2) NULL ,
	[Month] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGGW]    Script Date: 2003-6-2 17:24:45 ******/
CREATE TABLE [dbo].[tRS_TZGGW] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GWMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GWDM] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[COUNTER] [decimal](9, 2) NULL ,
	[Time] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGGWHZ]    Script Date: 2003-6-2 17:24:45 ******/
CREATE TABLE [dbo].[tRS_TZGGWHZ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GWDM] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[GWMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[COUNTER] [decimal](9, 2) NULL ,
	[Month] [char] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[GZHF] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGKQ]    Script Date: 2003-6-2 17:24:45 ******/
CREATE TABLE [dbo].[tRS_TZGKQ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KQXM] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[COUNTER] [decimal](9, 2) NULL ,
	[Time] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGKQHZ]    Script Date: 2003-6-2 17:24:45 ******/
CREATE TABLE [dbo].[tRS_TZGKQHZ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KGCS] [decimal](9, 2) NULL ,
	[KGSS] [decimal](9, 2) NULL ,
	[CDCS] [decimal](9, 2) NULL ,
	[CDSS] [decimal](9, 2) NULL ,
	[ZTCS] [decimal](9, 2) NULL ,
	[ZTSS] [decimal](9, 2) NULL ,
	[Month] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGQJ]    Script Date: 2003-6-2 17:24:46 ******/
CREATE TABLE [dbo].[tRS_TZGQJ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QJXM] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[COUNTER] [decimal](9, 2) NULL ,
	[Time] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGQJHZ]    Script Date: 2003-6-2 17:24:46 ******/
CREATE TABLE [dbo].[tRS_TZGQJHZ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BJ] [decimal](9, 2) NULL ,
	[SJ] [decimal](9, 2) NULL ,
	[GJ] [decimal](9, 2) NULL ,
	[GXJ] [decimal](9, 2) NULL ,
	[JJ] [decimal](9, 2) NULL ,
	[TQJ] [decimal](9, 2) NULL ,
	[HJ] [decimal](9, 2) NULL ,
	[SAJ] [decimal](9, 2) NULL ,
	[BLJ] [decimal](9, 2) NULL ,
	[CJ] [decimal](9, 2) NULL ,
	[GSJ] [decimal](9, 2) NULL ,
	[NXJ] [decimal](9, 2) NULL ,
	[Month] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGSYF]    Script Date: 2003-6-2 17:24:46 ******/
CREATE TABLE [dbo].[tRS_TZGSYF] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fldDate] [datetime] NULL ,
	[DWFDFY] [decimal](9, 2) NULL ,
	[TCFDFY] [decimal](9, 2) NULL ,
	[GRFDFY] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGYLF]    Script Date: 2003-6-2 17:24:46 ******/
CREATE TABLE [dbo].[tRS_TZGYLF] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fldDate] [datetime] NULL ,
	[DWFDFY] [decimal](9, 2) NULL ,
	[TCFDFY] [decimal](9, 2) NULL ,
	[GRFDFY] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGZFF]    Script Date: 2003-6-2 17:24:46 ******/
CREATE TABLE [dbo].[tRS_TZGZFF] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[fldDate] [datetime] NULL ,
	[ZFGJJ] [decimal](9, 2) NULL ,
	[ZFFZF] [decimal](9, 2) NULL ,
	[JFZC] [decimal](9, 2) NULL ,
	[XSF] [decimal](9, 2) NULL ,
	[ZFBT] [decimal](9, 2) NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZGZS]    Script Date: 2003-6-2 17:24:46 ******/
CREATE TABLE [dbo].[tRS_TZGZS] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZSH] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZSLB] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[FZRQ] [datetime] NULL ,
	[YXNX] [int] NULL ,
	[DQSJ] [datetime] NULL ,
	[FZJG] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[RRSJ] [datetime] NULL ,
	[BZ] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYGW]    Script Date: 2003-6-2 17:24:47 ******/
CREATE TABLE [dbo].[tRS_TZZRYGW] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GWMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDSJ] [datetime] NULL ,
	[BDFS] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDSM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYGZ]    Script Date: 2003-6-2 17:24:47 ******/
CREATE TABLE [dbo].[tRS_TZZRYGZ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YGZJE] [decimal](15, 2) NULL ,
	[XGZJE] [decimal](15, 2) NULL ,
	[BDPZSJ] [datetime] NULL ,
	[BDJS] [smallint] NULL ,
	[BDJE] [decimal](15, 2) NULL ,
	[TZSJ] [datetime] NULL ,
	[YJWJ] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYJF]    Script Date: 2003-6-2 17:24:47 ******/
CREATE TABLE [dbo].[tRS_TZZRYJF] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JZZL] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JZRQ] [datetime] NULL ,
	[JZYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[PZDW] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[JCRQ] [datetime] NULL ,
	[JCYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYJL]    Script Date: 2003-6-2 17:24:47 ******/
CREATE TABLE [dbo].[tRS_TZZRYJL] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[QSSJ] [datetime] NULL ,
	[ZZSJ] [datetime] NULL ,
	[SZDW] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[CSGZ] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[DRZW] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZMR] [char] (8) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYJS]    Script Date: 2003-6-2 17:24:47 ******/
CREATE TABLE [dbo].[tRS_TZZRYJS] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZYJSMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[QDFS] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[QDSJ] [datetime] NULL ,
	[PRZW] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[PRQSSJ] [datetime] NULL ,
	[PRZZSJ] [datetime] NULL ,
	[PRDW] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[SPDW] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYJT]    Script Date: 2003-6-2 17:24:48 ******/
CREATE TABLE [dbo].[tRS_TZZRYJT] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[XM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GX] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CSRQ] [datetime] NULL ,
	[GZDW] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZW] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZZMM] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LXDH] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYPS]    Script Date: 2003-6-2 17:24:48 ******/
CREATE TABLE [dbo].[tRS_TZZRYPS] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[PXFS] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[QSSJ] [datetime] NULL ,
	[JSSJ] [datetime] NULL ,
	[PXQX] [smallint] NULL ,
	[ZY] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[PXDWMC] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[PXNR] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[PXJF] [decimal](15, 2) NULL ,
	[PXJG] [char] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYWJ]    Script Date: 2003-6-2 17:24:48 ******/
CREATE TABLE [dbo].[tRS_TZZRYWJ] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[GZJL] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRYXX]    Script Date: 2003-6-2 17:24:48 ******/
CREATE TABLE [dbo].[tRS_TZZRYXX] (
	[ZGBH] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SJ] [datetime] NULL ,
	[LB] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[RR] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [char] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[tRS_TBMDYMX] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_TBMDYMX__RS__3E1D39E1] DEFAULT (0) FOR [RS],
	CONSTRAINT [DF__tRS_TBMDYM__RERS__3F115E1A] DEFAULT (0) FOR [RERS]
;

ALTER TABLE [dbo].[tRS_TBXJFDWJ] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_TBXJFDWJ__JS__42E1EEFE] DEFAULT (0) FOR [JS]
;

ALTER TABLE [dbo].[tRS_TBXJFGRJ] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_TBXJFGRJ__JS__45BE5BA9] DEFAULT (0) FOR [JS]
;

ALTER TABLE [dbo].[tRS_THTSJ] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_THTSJ__YXBZ__4C6B5938] DEFAULT (0) FOR [YXBZ]
;

ALTER TABLE [dbo].[tRS_TQTDM] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_TQTDM__USED__5224328E] DEFAULT (0) FOR [USED]
;

ALTER TABLE [dbo].[tRS_TZGGWHZ] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_TZGGWH__GZHF__5CA1C101] DEFAULT (0) FOR [GZHF]
;
上一页 12
⌨️ 快捷键说明

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