📄 bb.sql

📁 一个用VB写的财务软件源码
💻 SQL
字号:
/****** Object:  Table [dbo].[tBB_Area]   ******/
CREATE TABLE [dbo].[tBB_Area] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siStartRow] [smallint] NOT NULL ,
	[siStartCol] [smallint] NOT NULL ,
	[siEndRow] [smallint] NOT NULL ,
	[siEndCol] [smallint] NOT NULL ,
	[cAreaType] [varchar] (8) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_Authority]   ******/
CREATE TABLE [dbo].[tBB_Authority] (
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcUserID] [varchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cAuthority] [char] (4) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_CarryForward]     ******/
CREATE TABLE [dbo].[tBB_CarryForward] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[iCarryForwardYear] [smallint] NOT NULL ,
	[iCarryForwardMonth] [smallint] NOT NULL ,
	[bCarryForward] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_CollectPrintSet]     ******/
CREATE TABLE [dbo].[tBB_CollectPrintSet] (
	[siGroupCols] [smallint] NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_CollectTable]   ******/
CREATE TABLE [dbo].[tBB_CollectTable] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcCollectReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcCollectReportName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siColName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_Company]    ******/
CREATE TABLE [dbo].[tBB_Company] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cType] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bMerge] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_EqualIn]  ******/
CREATE TABLE [dbo].[tBB_EqualIn] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[iSortId] [int] NOT NULL ,
	[siRowLabel] [smallint] NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[cCalculateSign] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siStartRowLabel] [smallint] NOT NULL ,
	[siEndRowLabel] [smallint] NOT NULL ,
	[siStartColLabel] [smallint] NOT NULL ,
	[siEndColLabel] [smallint] NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_EqualOut]     ******/
CREATE TABLE [dbo].[tBB_EqualOut] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[iSortId] [int] NOT NULL ,
	[siRowLabel] [smallint] NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[cCalculateSign] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode2] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcGetTime] [char] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siRowLabel2] [smallint] NOT NULL ,
	[siColLabel2] [smallint] NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_Formula]  ******/
CREATE TABLE [dbo].[tBB_Formula] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siRowLabel] [smallint] NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[vcFormula] [varchar] (2000) COLLATE Chinese_PRC_CI_AS NOT NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_Head]  ******/
CREATE TABLE [dbo].[tBB_Head] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[siBanister] [smallint] NOT NULL ,
	[siColSerial] [smallint] NOT NULL ,
	[vcColName] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cDataType] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bGetDataCol] [smallint] NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_Item]   ******/
CREATE TABLE [dbo].[tBB_Item] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[siRowLabel] [smallint] NOT NULL ,
	[siColLabel] [smallint] NOT NULL ,
	[vcItemName] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
	[bMerge] [smallint] NULL ,
	[bAnalysis] [smallint] NULL ,
	[siItemClass] [smallint] NULL ,
	[vcItemBm] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_Report]    ******/
CREATE TABLE [dbo].[tBB_Report] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cReportType] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[bTotal] [smallint] NULL ,
	[bCollect] [smallint] NULL ,
	[bMerge] [smallint] NULL ,
	[bAnalysis] [smallint] NULL ,
	[siSerial] [smallint] NOT NULL ,
	[ID] [smallint] NULL,
        [TypeCode] [char] (2)  NOT NULL
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_ReportData<<YEAR>>]    ******/
CREATE TABLE [dbo].[tBB_ReportData<<YEAR>>] (
	[ReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EnterCode] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Month] [smallint] NOT NULL ,
	[iRowLabel] [int] NOT NULL ,
	[ColLabel] [int] NOT NULL ,
	[CellData] [decimal](15, 4) NULL 
) ON [PRIMARY]
;
/****** Object:  Table [dbo].[tBB_ReportRemark<<YEAR>>]    ******/
CREATE TABLE [dbo].[tBB_ReportRemark<<YEAR>>] (
	[ReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[EnterCode] [varchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[Month] [smallint] NOT NULL ,
	[iRowLabel] [int] NOT NULL ,
	[ColLabel] [int] NOT NULL ,
	[TextData] [varchar](100) NULL 
) ON [PRIMARY]
;
/****** Object:  Table [dbo].[tBB_ReportMode]    ******/
CREATE TABLE [dbo].[tBB_ReportMode] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[cMonth] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[lContent] [image] NULL ,
	[Length] [int] NOT NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_TotalCompany]   ******/
CREATE TABLE [dbo].[tBB_TotalCompany] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcReportCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcCompanies] [varchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcTotalCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_TotalMode]    ******/
CREATE TABLE [dbo].[tBB_TotalMode] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcTotalCode] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcTotalName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[vcTotalCompanies] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
	[vcTotalCodes] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL,
        [OffSetFlag] [smallint] default 0 
) ON [PRIMARY]
;

/****** Object:  Table [dbo].[tBB_ReportType]     ******/
CREATE TABLE [dbo].[tBB_ReportType] (
	[cYear] [char] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TypeCode] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[TypeName] [varchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
	[IsSysDef] [smallint] NULL 
) ON [PRIMARY]
;

ALTER TABLE [dbo].[tBB_ReportType] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_ReportType] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[TypeCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_Area] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_Area] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[siStartRow],
		[siStartCol],
		[siEndRow],
		[siEndCol]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_Authority] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_Authority] PRIMARY KEY  CLUSTERED 
	(
		[vcReportCode],
		[vcUserID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_CarryForward] WITH NOCHECK ADD 
	CONSTRAINT [DF__tBB_Carry__bCarr__51EF2864] DEFAULT (0) FOR [bCarryForward],
	 PRIMARY KEY  CLUSTERED 
	(
		[cYear]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_CollectTable] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_CollectTable] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcCollectReportCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_Company] WITH NOCHECK ADD 
	CONSTRAINT [DF__tBB_Compa__bMerg__42ACE4D4] DEFAULT ((-1)) FOR [bMerge],
	CONSTRAINT [PK_BB_Company] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_EqualIn] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_EqualIn] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[iSortId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_EqualOut] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_EqualOut] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[iSortId]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_Formula] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_Formula] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[siRowLabel],
		[siColLabel]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_Head] WITH NOCHECK ADD 
	CONSTRAINT [DF__tBB_Head__bGetDa__382F5661] DEFAULT (0) FOR [bGetDataCol],
	CONSTRAINT [PK_BB_Head] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[siColLabel]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_Item] WITH NOCHECK ADD 
	CONSTRAINT [DF__tBB_Item__bMerge__3B0BC30C] DEFAULT ((-1)) FOR [bMerge],
	CONSTRAINT [DF__tBB_Item__bAnaly__3BFFE745] DEFAULT ((-1)) FOR [bAnalysis],
	CONSTRAINT [PK_BB_Item] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode],
		[siRowLabel],
		[siColLabel]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_Report] WITH NOCHECK ADD 
	CONSTRAINT [DF__tBB_Repor__bTota__318258D2] DEFAULT ((-1)) FOR [bTotal],
	CONSTRAINT [DF__tBB_Repor__bColl__32767D0B] DEFAULT ((-1)) FOR [bCollect],
	CONSTRAINT [DF__tBB_Repor__bMerg__336AA144] DEFAULT ((-1)) FOR [bMerge],
	CONSTRAINT [DF__tBB_Repor__bAnal__345EC57D] DEFAULT (0) FOR [bAnalysis],
	CONSTRAINT [DF__tBB_Report__ID__3552E9B6] DEFAULT (0) FOR [ID],
	CONSTRAINT [PK_BB_Report] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_ReportData<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tBB_Repor__CellD__57A801BA] DEFAULT (0) FOR [CellData],
	CONSTRAINT [PK_BB_ReportData<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ReportCode],
		[EnterCode],
		[Month],
		[iRowLabel],
		[ColLabel]
	)  ON [PRIMARY] 
;
ALTER TABLE [dbo].[tBB_ReportRemark<<YEAR>>] WITH NOCHECK ADD
	CONSTRAINT [PK_BB_ReportRemark<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ReportCode],
		[EnterCode],
		[Month],
		[iRowLabel],
		[ColLabel]
	)  ON [PRIMARY] 
;
ALTER TABLE [dbo].[tBB_ReportMode] WITH NOCHECK ADD 
	CONSTRAINT [DF__tBB_Repor__Lengt__54CB950F] DEFAULT (0) FOR [Length],
	CONSTRAINT [PK_BB_ReportMode] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[cMonth],
		[vcReportCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_TotalCompany] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_TotalCompany] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcReportCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tBB_TotalMode] WITH NOCHECK ADD 
	CONSTRAINT [PK_BB_TotalMode] PRIMARY KEY  CLUSTERED 
	(
		[cYear],
		[vcTotalCode]
	)  ON [PRIMARY] 
;
⌨️ 快捷键说明

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