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

📄 gz.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 2 页
字号:
🔍
12 
CREATE TABLE [dbo].[tGZ_Bank] (
	[BankCode] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BankName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsFixedLen] [smallint] NULL ,
	[ZHlen] [smallint] NULL 
) ON [PRIMARY]
;
ALTER TABLE [dbo].[tGZ_Bank] WITH NOCHECK ADD 
	CONSTRAINT [DF__tGZ_Bank__IsFixe__0880433F] DEFAULT ((-1)) FOR [IsFixedLen],
	CONSTRAINT [DF__tGZ_Bank__ZHlen__09746778] DEFAULT (10) FOR [ZHlen],
	 PRIMARY KEY  CLUSTERED 
	(
		[BankCode]
	)  ON [PRIMARY] 
;
/****** Object:  Table [dbo].[tgz_TZZRY]    Script Date: 2003-5-30 16:07:44 ******/
CREATE TABLE [dbo].[tgz_TZZRY] (
	[ZGBH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[BMBH] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[BMMC] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZGXM] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GZZH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZZ] [char] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[SFZH] [char] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[XB] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[MZ] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JGBH] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[JG] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[CSRQ] [datetime] NULL ,
	[NL] [smallint] NULL ,
	[HY] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GRSF] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZZMM] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[SHBZH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[YLZHH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GRYHZH] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GRYHDH] [char] (2) COLLATE Chinese_PRC_CI_AS NULL ,
	[WHCD] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[BYYX] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[BYSJ] [datetime] NULL ,
	[ZY] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[XW] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[YZ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[CJGZSJ] [datetime] NULL ,
	[JRBDWSJ] [datetime] NULL ,
	[GL] [smallint] NULL ,
	[RYFL] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[GWGZ] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JSZC] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GZJB] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[XZZW] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[JTZZ] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[YB] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[DHHM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[HKSZD] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[HKXZ] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[GADQS] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LGQK] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[LGSJ] [datetime] NULL ,
	[XGFL] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[XGSJ] [datetime] NULL ,
	[BQYGL] [smallint] NULL ,
	[HTBZ] [smallint] NULL ,
	[GZLBid] [int] NULL ,
	[KHH] [char] (25) COLLATE Chinese_PRC_CI_AS NULL ,
	[ZPfile] [char] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[dadh] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[KMDM] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[TFNY] [CHAR](10) COLLATE Chinese_PRC_CI_AS NULL,
    [HFNY] [CHAR](10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
;
ALTER TABLE [dbo].[tGz_TZZRY] WITH NOCHECK ADD 
	CONSTRAINT [DF__tGz_TZZRY__NL__023D5A04] DEFAULT (0) FOR [NL],
	CONSTRAINT [DF__tGz_TZZRY__GL__03317E3D] DEFAULT (0) FOR [GL],
	CONSTRAINT [DF__tGz_TZZRY__BQYGL__0425A276] DEFAULT (0) FOR [BQYGL],
	CONSTRAINT [DF__tGz_TZZRY__HTBZ__0519C6AF] DEFAULT (0) FOR [HTBZ],
	 PRIMARY KEY  CLUSTERED 
	(
		[ZGBH]
	)  ON [PRIMARY] 
;

CREATE TABLE [dbo].[tGZ_BBDefine] (
	[ID] [smallint] NULL ,
	[BBMC] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Item] [char] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[ItemEng] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsFLXM] [smallint] NOT NULL ,
	[SYFlag] [char] (2) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[tgz_bzmz] (
	[BZMC] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MZBH] [varchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[MZMC] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[HSBL] [decimal](8, 2) NULL 
) ON [PRIMARY]
;

CREATE TABLE [dbo].[tGZ_Formulacal] (
	[GZLBid] [int] NOT NULL ,
	[AccountYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AccountPeriod] [smallint] NOT NULL ,
	[OrderNum] [smallint] NOT NULL ,
	[NUMFL] [smallint] NOT NULL ,
	[ItemID] [int] NOT NULL ,
	[ItemName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[formvalue] [varchar] (500) COLLATE Chinese_PRC_CI_AS NULL ,
	[FORMVALUECHINA] [varchar] (1000) COLLATE Chinese_PRC_CI_AS NULL ,
	[ISSYSTEM] [smallint] NOT NULL
) ON [PRIMARY]
;
ALTER TABLE [dbo].[tGZ_Formulacal] WITH NOCHECK ADD 
	CONSTRAINT [DF__tGZ_tGZ_Formulacal__ISSYSTEM__1] DEFAULT ((0)) FOR [ISSYSTEM],
	CONSTRAINT [PK_GZ_Formulacal] PRIMARY KEY  NONCLUSTERED 
	(
		[GZLBid],
		[AccountYear],
		[AccountPeriod],
		[ItemID]
	)  ON [PRIMARY] 
;


CREATE TABLE [dbo].[tGZ_GZData<<YEAR>>] (
	[GZLBid] [int] NOT NULL ,
	[AccountPeriod] [smallint] NOT NULL ,
	[RYBH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RYXM] [CHAR](20) not null,
	[BMMC] [CHAR](20) not null,
	[BMBH] [CHAR](20) not null,
	[RYLB] [CHAR](20) not null,
	[F1] [decimal](8, 2) NOT NULL ,
	[F2] [decimal](8, 2) NOT NULL ,
	[F3] [decimal](8, 2) NOT NULL ,
	[F4] [decimal](8, 2) NULL ,
	[F5] [decimal](8, 2) NULL ,
	[F6] [decimal](8, 2) NOT NULL ,
	[F7] [decimal](8, 2) NULL 
) ON [PRIMARY]
;
ALTER TABLE [dbo].[tGZ_GZData<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tGZ_GZData<<YEAR>>__F1__1] DEFAULT ((0)) FOR [F1],
	CONSTRAINT [DF__tGZ_GZData<<YEAR>>__F2__1] DEFAULT ((0)) FOR [F2],
	CONSTRAINT [DF__tGZ_GZData<<YEAR>>__F3__1] DEFAULT ((0)) FOR [F3],
	CONSTRAINT [DF__tGZ_GZData<<YEAR>>__F4__1] DEFAULT ((0)) FOR [F4],
	CONSTRAINT [DF__tGZ_GZData<<YEAR>>__F5__1] DEFAULT ((0)) FOR [F5],
	CONSTRAINT [DF__tGZ_GZData<<YEAR>>__F6__1] DEFAULT ((0)) FOR [F6],
	CONSTRAINT [DF__tGZ_GZData<<YEAR>>__F7__1] DEFAULT ((0)) FOR [F7],
	CONSTRAINT [PK_GZ_GZData<<YEAR>>] PRIMARY KEY  NONCLUSTERED 
	(
		[GZLBid],
		[AccountPeriod],
		[RYBH]
	)  ON [PRIMARY] 
;

CREATE TABLE [dbo].[tGZ_GZDatatemp] (
	[GZLBid] [int] NOT NULL ,
	[PCID] [smallint] NOT NULL,
	[AccountPeriod] [smallint] NOT NULL ,
	[RYBH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RYXM] [CHAR](20) not null,
	[BMMC] [CHAR](20) not null,
	[BMBH] [CHAR](20) not null,
	[RYLB] [CHAR](20) not null,
	[F1] [decimal](8, 2) NOT NULL ,
	[F2] [decimal](8, 2) NOT NULL ,
	[F3] [decimal](8, 2) NOT NULL ,
	[F4] [decimal](8, 2) NULL ,
	[F5] [decimal](8, 2) NULL ,
	[F6] [decimal](8, 2) NOT NULL ,
	[F7] [decimal](8, 2) NULL 
) ON [PRIMARY]
;
CREATE TABLE [dbo].[tGZ_GZDataP<<YEAR>>] (
	[GZLBid] [int] NOT NULL ,
	[PCID] [smallint] NOT NULL,
	[AccountPeriod] [smallint] NOT NULL ,
	[RYBH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[RYXM] [CHAR](20) not null,
	[BMMC] [CHAR](20) not null,
	[BMBH] [CHAR](20) not null,
	[RYLB] [CHAR](20) not null,
	[F1] [decimal](8, 2) NOT NULL ,
	[F2] [decimal](8, 2) NOT NULL ,
	[F3] [decimal](8, 2) NOT NULL ,
	[F4] [decimal](8, 2) NULL ,
	[F5] [decimal](8, 2) NULL ,
	[F6] [decimal](8, 2) NOT NULL ,
	[F7] [decimal](8, 2) NULL 
) ON [PRIMARY]
;
ALTER TABLE [dbo].[tGZ_GZDataP<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tGZ_GZDataP<<YEAR>>__F1__1] DEFAULT ((0)) FOR [F1],
	CONSTRAINT [DF__tGZ_GZDataP<<YEAR>>__F2__1] DEFAULT ((0)) FOR [F2],
	CONSTRAINT [DF__tGZ_GZDataP<<YEAR>>__F3__1] DEFAULT ((0)) FOR [F3],
	CONSTRAINT [DF__tGZ_GZDataP<<YEAR>>__F4__1] DEFAULT ((0)) FOR [F4],
	CONSTRAINT [DF__tGZ_GZDataP<<YEAR>>__F5__1] DEFAULT ((0)) FOR [F5],
	CONSTRAINT [DF__tGZ_GZDataP<<YEAR>>__F6__1] DEFAULT ((0)) FOR [F6],
	CONSTRAINT [DF__tGZ_GZDataP<<YEAR>>__F7__1] DEFAULT ((0)) FOR [F7],
	CONSTRAINT [PK_GZ_GZDataP2002] PRIMARY KEY  NONCLUSTERED 
	(
		[GZLBid],
		[AccountPeriod],
		[PCid],
		[RYBH]
	)  ON [PRIMARY] 
;

CREATE TABLE [dbo].[tGZ_GZItem] (
	[ItemID] [int] NOT NULL ,
	[ItemName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[DataType] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[FieldLength] [smallint] NOT NULL ,
	[DecimalBits] [smallint] NULL ,
	[KJKMDM] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsUsed] [smallint] NULL ,
	[IsSysDef] [smallint] NULL ,
	[ISTAKETAX] [smallint] not null
) ON [PRIMARY]
;
12

⌨️ 快捷键说明

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