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

📄 ty.sql

📁 一个用VB写的财务软件源码
💻 SQL
📖 第 1 页 / 共 3 页
字号:
🔍
123 
/****** Object:  Table [dbo].[TCON_DAITEM]    Script Date: 2003-5-30 16:07:42 ******/
CREATE TABLE [dbo].[TCON_DAITEM] (
	[cItmSysCoding] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cItmDaCoding] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcItmDaCaption] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcItmDaName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cItmDaEdition] [char] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcItmSynosis] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[dItmRemove] [datetime] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[Tusu_kmToXmClass<<YEAR>>]    Script Date: 2003-5-30 16:07:43 ******/
CREATE TABLE [dbo].[Tusu_kmToXmClass<<YEAR>>] (
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[itemid] [int] NULL ,
	[itemClass] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TJGDM]    Script Date: 2003-5-30 16:07:44 ******/
CREATE TABLE [dbo].[tRS_TJGDM] (
	[CODE] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[NAME] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[USED] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tRS_TZZRY]    Script Date: 2003-5-30 16:07:44 ******/
CREATE TABLE [dbo].[tRS_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
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tUSU_AccountFormat]    Script Date: 2003-5-30 16:07:44 ******/
CREATE TABLE [dbo].[tUSU_AccountFormat] (
	[AccountType] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[AccountFormat] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[ColWidth] [varchar] (300) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tUSU_DMJS]    Script Date: 2003-5-30 16:07:44 ******/
CREATE TABLE [dbo].[tUSU_DMJS] (
	[Type] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[JC] [smallint] NOT NULL ,
	[WS] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tUSU_Department<<YEAR>>]    Script Date: 2003-5-30 16:07:44 ******/
CREATE TABLE [dbo].[tUSU_Department<<YEAR>>] (
	[cDepCode] [char] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cDepName] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[iDepGrade] [smallint] NULL ,
	[bDepEnd] [smallint] NULL ,
	[cDepPerson] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cDepPhone] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cDepMemo] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[bOtherUse] [smallint] NULL ,
	[cGDkm] [char] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsHaveZD] [smallint] NULL ,
        [XFDFKM] [varchar](40)
) ON [PRIMARY]
;

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

/****** Object:  Table [dbo].[tUSU_Fz<<YEAR>>]    Script Date: 2003-5-30 16:07:45 ******/
CREATE TABLE [dbo].[tUSU_Fz<<YEAR>>] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[kmdm] [varchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Grwl_Code] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[Khwl_Code] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[Gyswl_Code] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmdm] [char] (12) COLLATE Chinese_PRC_CI_AS NULL ,
	[xmdm] [char] (600) COLLATE Chinese_PRC_CI_AS NULL ,
	[ljjsl00] [decimal](15, 3) NULL ,
	[ljjwb00] [decimal](15, 2) NULL ,
	[ljj00] [decimal](15, 2) NULL ,
	[ljdsl00] [decimal](15, 3) NULL ,
	[ljdwb00] [decimal](15, 2) NULL ,
	[ljd00] [decimal](15, 2) NULL ,
	[ljjsl01] [decimal](15, 3) NULL ,
	[ljjwb01] [decimal](15, 2) NULL ,
	[ljj01] [decimal](15, 2) NULL ,
	[ljdsl01] [decimal](15, 3) NULL ,
	[ljdwb01] [decimal](15, 2) NULL ,
	[ljd01] [decimal](15, 2) NULL ,
	[ljjsl02] [decimal](15, 3) NULL ,
	[ljjwb02] [decimal](15, 2) NULL ,
	[ljj02] [decimal](15, 2) NULL ,
	[ljdsl02] [decimal](15, 3) NULL ,
	[ljdwb02] [decimal](15, 2) NULL ,
	[ljd02] [decimal](15, 2) NULL ,
	[ljjsl03] [decimal](15, 3) NULL ,
	[ljjwb03] [decimal](15, 2) NULL ,
	[ljj03] [decimal](15, 2) NULL ,
	[ljdsl03] [decimal](15, 3) NULL ,
	[ljdwb03] [decimal](15, 2) NULL ,
	[ljd03] [decimal](15, 2) NULL ,
	[ljjsl04] [decimal](15, 3) NULL ,
	[ljjwb04] [decimal](15, 2) NULL ,
	[ljj04] [decimal](15, 2) NULL ,
	[ljdsl04] [decimal](15, 3) NULL ,
	[ljdwb04] [decimal](15, 2) NULL ,
	[ljd04] [decimal](15, 2) NULL ,
	[ljjsl05] [decimal](15, 3) NULL ,
	[ljjwb05] [decimal](15, 2) NULL ,
	[ljj05] [decimal](15, 2) NULL ,
	[ljdsl05] [decimal](15, 3) NULL ,
	[ljdwb05] [decimal](15, 2) NULL ,
	[ljd05] [decimal](15, 2) NULL ,
	[ljjsl06] [decimal](15, 3) NULL ,
	[ljjwb06] [decimal](15, 2) NULL ,
	[ljj06] [decimal](15, 2) NULL ,
	[ljdsl06] [decimal](15, 3) NULL ,
	[ljdwb06] [decimal](15, 2) NULL ,
	[ljd06] [decimal](15, 2) NULL ,
	[ljjsl07] [decimal](15, 3) NULL ,
	[ljjwb07] [decimal](15, 2) NULL ,
	[ljj07] [decimal](15, 2) NULL ,
	[ljdsl07] [decimal](15, 3) NULL ,
	[ljdwb07] [decimal](15, 2) NULL ,
	[ljd07] [decimal](15, 2) NULL ,
	[ljjsl08] [decimal](15, 3) NULL ,
	[ljjwb08] [decimal](15, 2) NULL ,
	[ljj08] [decimal](15, 2) NULL ,
	[ljdsl08] [decimal](15, 3) NULL ,
	[ljdwb08] [decimal](15, 2) NULL ,
	[ljd08] [decimal](15, 2) NULL ,
	[ljjsl09] [decimal](15, 3) NULL ,
	[ljjwb09] [decimal](15, 2) NULL ,
	[ljj09] [decimal](15, 2) NULL ,
	[ljdsl09] [decimal](15, 3) NULL ,
	[ljdwb09] [decimal](15, 2) NULL ,
	[ljd09] [decimal](15, 2) NULL ,
	[ljjsl10] [decimal](15, 3) NULL ,
	[ljjwb10] [decimal](15, 2) NULL ,
	[ljj10] [decimal](15, 2) NULL ,
	[ljdsl10] [decimal](15, 3) NULL ,
	[ljdwb10] [decimal](15, 2) NULL ,
	[ljd10] [decimal](15, 2) NULL ,
	[ljjsl11] [decimal](15, 3) NULL ,
	[ljjwb11] [decimal](15, 2) NULL ,
	[ljj11] [decimal](15, 2) NULL ,
	[ljdsl11] [decimal](15, 3) NULL ,
	[ljdwb11] [decimal](15, 2) NULL ,
	[ljd11] [decimal](15, 2) NULL ,
	[ljjsl12] [decimal](15, 3) NULL ,
	[ljjwb12] [decimal](15, 2) NULL ,
	[ljj12] [decimal](15, 2) NULL ,
	[ljdsl12] [decimal](15, 3) NULL ,
	[ljdwb12] [decimal](15, 2) NULL ,
	[ljd12] [decimal](15, 2) NULL 
) ON [PRIMARY]
;
 CREATE  INDEX [IX_tUSU_Fz<<YEAR>>_KMDM] ON [dbo].[tUSU_Fz<<YEAR>>]([kmdm]) ON [PRIMARY]
;
 CREATE  INDEX [IX_tUSU_Fz<<YEAR>>_XMDM] ON [dbo].[tUSU_Fz<<YEAR>>]([xmdm]) ON [PRIMARY]
;
 CREATE  INDEX [IX_tUSU_Fz<<YEAR>>_BMDM] ON [dbo].[tUSU_Fz<<YEAR>>]([bmdm]) ON [PRIMARY]
;
/****** Object:  Table [dbo].[tUSU_PzMutex]    Script Date: 2003-5-30 16:07:45 ******/
CREATE TABLE [dbo].[tUSU_PzMutex] (
	[iPeriod] [smallint] NOT NULL ,
	[cPzzl] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
123

⌨️ 快捷键说明

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