js_filt.sql

来自「本系统是一个报表分析查询系统」· SQL 代码 · 共 15 行

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Js_Filt]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Js_Filt]
GO

CREATE TABLE [dbo].[Js_Filt] (
	[Js_FiltID] [int] NOT NULL ,--过滤条件内码
	[Js_RptID] [int] NOT NULL ,--所属报表内码
	[Js_FieldControlID] [int] NOT NULL ,--字段内码
	[Js_LinkSign] [int] NOT NULL ,--是否连接下个条件
        [Js_Desc] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL,--描述，为空则自动获取Js_FieldControl中得数据
	[Js_OrderID] [int] NOT NULL --排序序号
) ON [PRIMARY]
GO