⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 gd.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 5 页
字号:
🔍
12345 
	[DZ] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[QYYF] [char] (7) COLLATE Chinese_PRC_CI_AS NULL ,
	[GDDZKM] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJDZKM] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[NOYMJZ] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[LJZD] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[WCDZYW] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[GDRZKM] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJRZKM] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZYZJFF] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[FPZQ] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[TZZJ] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[SCKP] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[JTZJ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[JZZBDZKM] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[JZZBRZKM] [char] (30) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ORIGINCHANGED] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDQZJLYDM] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZJLYMC] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHZJLYDM] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHZJLYMC] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_OTHERMODE] (
	[VCFILENAME] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LCONTENT] [image] NULL ,
	[LENGTH] [int] NULL ,
	[TCHINAME] [char] (20) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_OTHERXM] (
	[ID] [int] NOT NULL ,
	[TENGNAME] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TCHINAME] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[XMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[LX] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZSCD] [smallint] NULL ,
	[XSCD] [smallint] NULL ,
	[KPUSED] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_PLZD<<YEAR>>] (
	[ID] [int] NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JLBH] [smallint] NULL ,
	[KJQJ] [smallint] NULL ,
	[YW] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[DJLX] [char] (28) COLLATE Chinese_PRC_CI_AS NULL ,
	[KMDM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[FX] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[JE] [decimal](15, 2) NULL ,
	[ZDBZ] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[PZZL] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[PZKJQJ] [smallint] NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_QUERYSET] (
	[VCQUERYNAME] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCRELATION] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCLEFT] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCCHINAME] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCTABLENAME] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCITEMCHI] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCITEMENG] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCCOMPARE] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VCVALUES] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[VCRIGHT] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[IORDERNUM] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_SYZK] (
	[DM] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SYZKMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SFJTZJ] [smallint] NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_XFFF] (
	[BH] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[MC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSFF] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[USED] [char] (1) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_YEARADJUSTGS] (
	[TZRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZCLBBH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ZCLBMC] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[TZQZJGS] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[TZHZJGS] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[TZYY] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_YSXM] (
	[YSMC] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[XMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_YTXF] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[YTNY] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BYYTE] [decimal](15, 2) NULL ,
	[LJYT] [decimal](15, 2) NULL ,
	[ZYTE] [decimal](15, 2) NULL ,
	[YTYZ] [decimal](15, 2) NULL ,
	[TXQ] [decimal](5, 0) NOT NULL ,
	[NYTL] [decimal](15, 4) NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCBMFA] (
	[BMFS] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BMGZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[XHCD] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMFGF] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZXYZ] [decimal](15, 2) NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCBMZY] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQBM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQDD] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHBM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHDD] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQBMBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHBMBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCDXJL] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[KSRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[XLYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCFL] (
	[DM] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MC] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCFSSB] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SBBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[SBMC] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[XH] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[JZ] [decimal](15, 2) NULL ,
	[SL] [smallint] NULL ,
	[DW] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SYRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCGZZLTZ] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQGZZL] [decimal](15, 4) NULL ,
	[BDHGZZL] [decimal](15, 4) NULL ,
	[BDQYZJE] [decimal](15, 2) NULL ,
	[BDQYZJL] [decimal](15, 6) NULL ,
	[BDQZJFF] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCJCZLBD] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQJCZ] [decimal](15, 2) NULL ,
	[BDHJCZ] [decimal](15, 2) NULL ,
	[BDQJCZL] [decimal](15, 4) NULL ,
	[BDHJCZL] [decimal](15, 4) NULL ,
	[BDQZJFF] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCJS] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JSRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSFS] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[QLSR] [decimal](15, 2) NULL ,
	[QLFY] [decimal](15, 2) NULL ,
	[QLYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZXRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCJZZB] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[LJJZZB] [decimal](15, 2) NULL ,
	[YZ] [decimal](15, 2) NULL ,
	[LJZJ] [decimal](15, 2) NULL ,
	[JZJE] [decimal](15, 2) NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQYZJE] [decimal](15, 2) NULL ,
	[BDQYZJL] [decimal](15, 6) NULL ,
	[BDQZJFF] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCLB] (
	[DM] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[SYNX] [decimal](5, 0) NULL ,
	[JLDW] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JTSX] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJFF] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[KPYS] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZCKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZJKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[TXQ] [decimal](5, 0) NULL ,
	[YTXFL] [decimal](15, 4) NULL ,
	[XFKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[JZZBKM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCLBJS] (
	[JC] [smallint] NOT NULL ,
	[WS] [smallint] NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCLBTZ] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZCLB] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHZCLB] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZCLBBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDHZCLBBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[TXQ] [decimal](5, 0) NULL ,
	[YTFL] [decimal](15, 4) NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];
 

CREATE TABLE [dbo].[TGD_ZCLJZJTZ] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQLJZJ] [decimal](15, 2) NULL ,
	[BDHLJZJ] [decimal](15, 2) NULL ,
	[BDQYZJE] [decimal](15, 2) NULL ,
	[BDQYZJL] [decimal](15, 6) NULL ,
	[BDQZJFF] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQZY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];
 
CREATE TABLE [dbo].[TGD_ZCPG] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[PGQYZ] [decimal](15, 2) NULL ,
	[PGHYZ] [decimal](15, 2) NULL ,
	[PGQLJZJ] [decimal](15, 2) NULL ,
	[PGHLJZJ] [decimal](15, 2) NULL ,
	[PGQJZ] [decimal](15, 2) NULL ,
	[PGHJZ] [decimal](15, 2) NULL ,
	[PGQJCZL] [decimal](15, 4) NULL ,
	[PGHJCZL] [decimal](15, 4) NULL ,
	[PGQSYNX] [decimal](5, 0) NULL ,
	[PGHSYNX] [decimal](5, 0) NULL ,
	[PGQGZZL] [decimal](5, 0) NULL ,
	[PGHGZZL] [decimal](5, 0) NULL ,
	[PGQJZZB] [decimal](18, 0) NULL ,
	[PGHJZZB] [decimal](18, 0) NULL ,
	[PGRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [char] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY];

CREATE TABLE [dbo].[TGD_ZCSYNXTZ] (
	[KPBH] [char] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DJH] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BDRQ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSR] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDYY] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BZ] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BDQSYNX] [smallint] NULL ,
	[BDHSYNX] [smallint] NULL ,
	[BDQYZJE] [decimal](15, 2) NULL ,
12345

⌨️ 快捷键说明

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