SearchPlanInfo
查询方案表
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| MaxItemCount (T+12.1) | MaxItemCount | int | 4 | True | |
| TFlag (T+12.1) | 二次开发标识 | int | 4 | True | |
| LayoutColumnCount (T+12.1) | LayoutColumnCount | int | 4 | True | |
| IsDirectSearch (T+12.1) | 是否直接进入报表 | bit | 1 | True | |
| SearchStyle (T+12.1) | 查询方案风格 | int | 4 | False | |
| NoDelete (T+12.1) | 菜单发布 | nvarchar | 50 | True | |
| IsPublicPlan (T+12.1) | 是否公共 | bit | 1 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| IsMBPublish (T+13.0) | 是否已发布(移动方案) | bit | 1 | True | |
| SearchId (T+12.1) | SearchId | int | 4 | False | |
| IsPublish (T+12.3) | 是否发布方案 | bit | 1 | True | |
| ExpressionName (T+12.1) | expressionName | nvarchar | 60 | True | |
| CreatedTime (T+12.1) | CreatedTime | datetime | 8 | True | |
| UserId (T+12.1) | 用户ID | int | 4 | True | |
| IsDefault (T+12.1) | IsDefault | bit | 1 | True | |
| SourcePlanId (T+13.0) | 源方案ID | int | 4 | True | |
| Isdisplay (T+12.1) | 是否显示 | bit | 1 | True | |
| IsShowExpression (T+12.1) | IsShowExpression | bit | 1 | True | |
| IsSystem (T+12.1) | IsSystem | bit | 1 | True | |
| IsMobilePlan (T+13.0) | 是否移动方案 | bit | 1 | True | |
| SearchName (T+12.1) | 查询名称 | nvarchar | 50 | False | |
| IsMenu (T+12.3) | 是否挂菜单 | bit | 1 | True | |
| Expression (T+12.1) | 公式表达式 | nvarchar | 400 | True | |
| EndGrade (T+12.1) | EndGrade | bit | 1 | True | |
| PlanName (T+12.1) | 方案名称 | nvarchar | 50 | True | |
| LayoutStyle (T+12.1) | 布局风格 | int | 4 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False |
Copyright 2019 Chanjet Inc.