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

📄 ty.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 3 页
字号:
🔍
123 
	[cComputer] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tUSU_QuerySet]    Script Date: 2003-5-30 16:07:46 ******/
CREATE TABLE [dbo].[tUSU_QuerySet] (
	[cModule] [varchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[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 ,
	[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]
;

/****** Object:  Table [dbo].[tUSU_SubCompany]    Script Date: 2003-5-30 16:07:46 ******/
CREATE TABLE [dbo].[tUSU_SubCompany] (
	[cCode] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcShortName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[siOrder] [smallint] NULL ,
	[vcTrade] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcEconomy] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcFile] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL ,
	[bMerge] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tUSU_TableItem]    Script Date: 2003-5-30 16:07:46 ******/
CREATE TABLE [dbo].[tUSU_TableItem] (
	[cModule] [varchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VcItemCHI] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VcItemEng] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[VcItemType] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tUSU_Trade]    Script Date: 2003-5-30 16:07:46 ******/
CREATE TABLE [dbo].[tUSU_Trade] (
	[vcName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_Balance<<YEAR>>]    Script Date: 2003-5-30 16:07:46 ******/
CREATE TABLE [dbo].[tZW_Balance<<YEAR>>] (
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmmc] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[yefx] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bz] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ljjsl00] [decimal](15, 3) NOT NULL ,
	[ljjwb00] [decimal](15, 2) NOT NULL ,
	[ljj00] [decimal](15, 2) NOT NULL ,
	[ljdsl00] [decimal](15, 3) NOT NULL ,
	[ljdwb00] [decimal](15, 2) NOT NULL ,
	[ljd00] [decimal](15, 2) NOT NULL ,
	[ljjsl01] [decimal](15, 3) NOT NULL ,
	[ljjwb01] [decimal](15, 2) NOT NULL ,
	[ljj01] [decimal](15, 2) NOT NULL ,
	[ljdsl01] [decimal](15, 3) NOT NULL ,
	[ljdwb01] [decimal](15, 2) NOT NULL ,
	[ljd01] [decimal](15, 2) NOT NULL ,
	[ljjsl02] [decimal](15, 3) NOT NULL ,
	[ljjwb02] [decimal](15, 2) NOT NULL ,
	[ljj02] [decimal](15, 2) NOT NULL ,
	[ljdsl02] [decimal](15, 3) NOT NULL ,
	[ljdwb02] [decimal](15, 2) NOT NULL ,
	[ljd02] [decimal](15, 2) NOT NULL ,
	[ljjsl03] [decimal](15, 3) NOT NULL ,
	[ljjwb03] [decimal](15, 2) NOT NULL ,
	[ljj03] [decimal](15, 2) NOT NULL ,
	[ljdsl03] [decimal](15, 3) NOT NULL ,
	[ljdwb03] [decimal](15, 2) NOT NULL ,
	[ljd03] [decimal](15, 2) NOT NULL ,
	[ljjsl04] [decimal](15, 3) NOT NULL ,
	[ljjwb04] [decimal](15, 2) NOT NULL ,
	[ljj04] [decimal](15, 2) NOT NULL ,
	[ljdsl04] [decimal](15, 3) NOT NULL ,
	[ljdwb04] [decimal](15, 2) NOT NULL ,
	[ljd04] [decimal](15, 2) NOT NULL ,
	[ljjsl05] [decimal](15, 3) NOT NULL ,
	[ljjwb05] [decimal](15, 2) NOT NULL ,
	[ljj05] [decimal](15, 2) NOT NULL ,
	[ljdsl05] [decimal](15, 3) NOT NULL ,
	[ljdwb05] [decimal](15, 2) NOT NULL ,
	[ljd05] [decimal](15, 2) NOT NULL ,
	[ljjsl06] [decimal](15, 3) NOT NULL ,
	[ljjwb06] [decimal](15, 2) NOT NULL ,
	[ljj06] [decimal](15, 2) NOT NULL ,
	[ljdsl06] [decimal](15, 3) NOT NULL ,
	[ljdwb06] [decimal](15, 2) NOT NULL ,
	[ljd06] [decimal](15, 2) NOT NULL ,
	[ljjsl07] [decimal](15, 3) NOT NULL ,
	[ljjwb07] [decimal](15, 2) NOT NULL ,
	[ljj07] [decimal](15, 2) NOT NULL ,
	[ljdsl07] [decimal](15, 3) NOT NULL ,
	[ljdwb07] [decimal](15, 2) NOT NULL ,
	[ljd07] [decimal](15, 2) NOT NULL ,
	[ljjsl08] [decimal](15, 3) NOT NULL ,
	[ljjwb08] [decimal](15, 2) NOT NULL ,
	[ljj08] [decimal](15, 2) NOT NULL ,
	[ljdsl08] [decimal](15, 3) NOT NULL ,
	[ljdwb08] [decimal](15, 2) NOT NULL ,
	[ljd08] [decimal](15, 2) NOT NULL ,
	[ljjsl09] [decimal](15, 3) NOT NULL ,
	[ljjwb09] [decimal](15, 2) NOT NULL ,
	[ljj09] [decimal](15, 2) NOT NULL ,
	[ljdsl09] [decimal](15, 3) NOT NULL ,
	[ljdwb09] [decimal](15, 2) NOT NULL ,
	[ljd09] [decimal](15, 2) NOT NULL ,
	[ljjsl10] [decimal](15, 3) NOT NULL ,
	[ljjwb10] [decimal](15, 2) NOT NULL ,
	[ljj10] [decimal](15, 2) NOT NULL ,
	[ljdsl10] [decimal](15, 3) NOT NULL ,
	[ljdwb10] [decimal](15, 2) NOT NULL ,
	[ljd10] [decimal](15, 2) NOT NULL ,
	[ljjsl11] [decimal](15, 3) NOT NULL ,
	[ljjwb11] [decimal](15, 2) NOT NULL ,
	[ljj11] [decimal](15, 2) NOT NULL ,
	[ljdsl11] [decimal](15, 3) NOT NULL ,
	[ljdwb11] [decimal](15, 2) NOT NULL ,
	[ljd11] [decimal](15, 2) NOT NULL ,
	[ljjsl12] [decimal](15, 3) NOT NULL ,
	[ljjwb12] [decimal](15, 2) NOT NULL ,
	[ljj12] [decimal](15, 2) NOT NULL ,
	[ljdsl12] [decimal](15, 3) NOT NULL ,
	[ljdwb12] [decimal](15, 2) NOT NULL ,
	[ljd12] [decimal](15, 2) NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tZW_km<<YEAR>>]    Script Date: 2003-5-30 16:07:47 ******/
CREATE TABLE [dbo].[tZW_km<<YEAR>>] (
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmmc] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmmcEng] [varchar] (80) COLLATE Chinese_PRC_CI_AS NULL ,
	[zjm] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
	[kmlx] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[kmjc] [smallint] NOT NULL ,
	[IsEndkm] [smallint] NULL ,
	[yefx] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[zygs] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[hzdykm] [varchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
	[sldw] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[wbdw] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsRjz] [smallint] NULL ,
	[IsYhz] [smallint] NULL ,
	[IsGrwlhs] [smallint] NULL ,
	[IsKhwlhs] [smallint] NULL ,
	[IsGyswlhs] [smallint] NULL ,
	[IsBmhs] [smallint] NULL ,
	[IsXmhs] [smallint] NULL ,
	[IsXjllkm] [smallint] NULL ,
	[Xjlllb] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[JfKze] [decimal](15, 2) NULL ,
	[DfKze] [decimal](15, 2) NULL ,
	[YeKze] [decimal](15, 2) NULL ,
	[kmqx] [smallint] NULL ,
	[CwfxLx] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsFc] [smallint] NULL ,
	[bUse] [smallint] NULL ,
	[bAdd] [smallint] NULL ,
	[cLawless] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[tRS_TJGDM] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_TJGDM__USED__7F60ED59] DEFAULT (0) FOR [USED],
	 PRIMARY KEY  CLUSTERED 
	(
		[CODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tRS_TZZRY] WITH NOCHECK ADD 
	CONSTRAINT [DF__tRS_TZZRY__NL__023D5A04] DEFAULT (0) FOR [NL],
	CONSTRAINT [DF__tRS_TZZRY__GL__03317E3D] DEFAULT (0) FOR [GL],
	CONSTRAINT [DF__tRS_TZZRY__BQYGL__0425A276] DEFAULT (0) FOR [BQYGL],
	CONSTRAINT [DF__tRS_TZZRY__HTBZ__0519C6AF] DEFAULT (0) FOR [HTBZ],
	 PRIMARY KEY  CLUSTERED 
	(
		[ZGBH]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_AccountFormat] WITH NOCHECK ADD 
	CONSTRAINT [PK_USU_AccountFormat] PRIMARY KEY  CLUSTERED 
	(
		[AccountType],
		[AccountFormat]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_DMJS] WITH NOCHECK ADD 
	CONSTRAINT [DF__tUSU_DMJS__WS__76CBA758] DEFAULT (0) FOR [WS],
	CONSTRAINT [PK_USU_DMJS] PRIMARY KEY  NONCLUSTERED 
	(
		[Type],
		[JC]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_Department<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tUSU_Depa__bDepE__7A9C383C] DEFAULT ((-1)) FOR [bDepEnd],
	CONSTRAINT [DF__tUSU_Depa__bOthe__7B905C75] DEFAULT (0) FOR [bOtherUse],
	CONSTRAINT [DF__tUSU_Depa__IsHav__7C8480AE] DEFAULT (0) FOR [IsHaveZD],
	 PRIMARY KEY  CLUSTERED 
	(
		[cDepCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_Economy] WITH NOCHECK ADD 
	CONSTRAINT [PK_USU_Economy] PRIMARY KEY  CLUSTERED 
	(
		[vcName]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_Fz<<YEAR>>] WITH NOCHECK ADD
123

⌨️ 快捷键说明

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