SearchItem
| Column Name | Description | Datatype | Length | Allow Nulls | |
|---|---|---|---|---|---|
| FieldTitle (T+12.1) | FieldTitle | nvarchar | 200 | True | |
| FormatString (T+12.1) | 格式字符串 | nvarchar | 50 | True | |
| ExpressionName (T+12.1) | expressionName | nvarchar | 60 | True | |
| ItemType (T+12.3) | 字段类型 | nvarchar | 50 | True | |
| EndDefault (T+12.1) | EndDefault | nvarchar | 400 | True | |
| RangeSql (T+12.3) | 区间类型预置SQL | nvarchar | 512 | True | |
| SupportMatchMode (T+12.3) | 支持的匹配类型 | nvarchar | 8 | True | |
| DependItems (T+12.1) | DependItems | nvarchar | 400 | True | |
| RepelItems (T+12.1) | 互斥的查询项ID集合 | nvarchar | 400 | True | |
| FieldName (T+12.1) | 表字段 | nvarchar | 200 | False | |
| OrderNum (T+12.1) | 顺序号 | int | 4 | True | |
| IsBetween (T+12.1) | 是否为区间 | bit | 1 | True | |
| id (T+12.1) | 主键 | int | 4 | False | |
| CanGroupSum (T+12.1) | 可否分组小记 | bit | 1 | True | |
| ColumnName (T+12.1) | 列名称 | nvarchar | 200 | False | |
| MultiSql (T+12.3) | 多选类型预置SQL | nvarchar | 512 | True | |
| BeginDefault (T+12.1) | BeginDefault | nvarchar | 400 | True | |
| DefItemTitleExpression (T+12.3) | 自定义项显示名 | varchar | 50 | True | |
| CanFilterSearch (T+12.1) | 可过滤查询 | bit | 1 | True | |
| DTOProp (T+12.1) | DTOProp | nvarchar | 300 | True | |
| CompareSign (T+12.1) | 逻辑符 | nvarchar | 500 | True | |
| ts (T+12.1) | 分布时间戳 | timestamp | 8 | False | |
| isNotNullValue (T+12.1) | isNotNullValue | bit | 1 | True | |
| CreatedTime (T+12.1) | CreatedTime | datetime | 8 | True | |
| FieldType (T+12.1) | FieldType | nvarchar | 50 | True | |
| SingleSql (T+12.3) | 单选类型预置SQL | nvarchar | 512 | True | |
| IsSystem (T+12.1) | IsSystem | bit | 1 | False | |
| WhereOrder (T+12.1) | WhereOrder | int | 4 | True | |
| AllowRecord (T+13.0) | 是否允许记忆(PDA移动模板) | bit | 1 | True | |
| LinkSign (T+12.1) | LinkSign | nvarchar | 50 | False | |
| EndDefaultText (T+12.1) | 结束默认文本 | nvarchar | 100 | True | |
| BeginDefaultText (T+12.1) | 开始默认文本 | nvarchar | 100 | True | |
| SearchId (T+12.1) | SearchId | int | 4 | False | |
| RepelGroup (T+12.1) | 互拆组名 | nvarchar | 50 | True | |
| RefDtoProp (T+12.1) | RefDtoProp | nvarchar | 400 | True | |
| FieldTitle2 (T+12.1) | 字段标题2 | nvarchar | 50 | True | |
| whereName (T+12.1) | whereName | nvarchar | 50 | True | |
| SupportItemType (T+12.3) | 支持的查询项类型 | nvarchar | 16 | True | |
| IsRecord (T+13.0) | 是否记忆(PDA移动模板) | bit | 1 | True |
Copyright 2019 Chanjet Inc.