数据表:T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则)

T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则):描述

名称

T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则)

代码

T_ORG_CHANGESELFRULEENTRY

注释

 

模型

BOS

主键

PK_ORG_CHANGESRENTRY


T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则):列规格定义

名称

代码

数据类型

长度

强制

注释

明细分录内码

FENTRYID

varchar(36)

36

TRUE

 

变更检查规则内码

FID

varchar(36)

36

TRUE

 

序号字段

FINDEX

smallint

 

TRUE

 

插件处理程序

FPLUGIN

NVARCHAR(255)

255

FALSE

 

检查条件

FCHECKCONDITION

NVARCHAR(255)

255

FALSE

 

业务领域

FSELFTOPCLASSID

varchar(36)

36

TRUE

 

控制强度

FSCONTROLSTRENGTH

char(1)

1

TRUE

0:强制
1:忽略

锁定控制强度

FSISLOCKCS

char(1)

1

FALSE

 


T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则):脚本代码

if exists (select 1
from sysindexes
where id = object_id('T_ORG_CHANGESELFRULEENTRY')
and name = 'IDX_ORG_CHANGESRENTRY_FIX'
and indid > 0
and indid < 255)
drop index T_ORG_CHANGESELFRULEENTRY.IDX_ORG_CHANGESRENTRY_FIX
go

if exists (select 1
from sysindexes
where id = object_id('T_ORG_CHANGESELFRULEENTRY')
and name = 'IDX_ORG_CHANGESRENTRY_FID'
and indid > 0
and indid < 255)
drop index T_ORG_CHANGESELFRULEENTRY.IDX_ORG_CHANGESRENTRY_FID
go

if exists (select 1
from sysobjects
where id = object_id('T_ORG_CHANGESELFRULEENTRY')
and type = 'U')
drop table T_ORG_CHANGESELFRULEENTRY
go

/*==============================================================*/
/* Table: T_ORG_CHANGESELFRULEENTRY */
/*==============================================================*/
create table T_ORG_CHANGESELFRULEENTRY (
FENTRYID varchar(36) not null default ' ',
FID varchar(36) not null default ' ',
FINDEX smallint not null default 0,
FPLUGIN NVARCHAR(255) null,
FCHECKCONDITION NVARCHAR(255) null,
FSELFTOPCLASSID varchar(36) not null default ' ',
FSCONTROLSTRENGTH char(1) not null default '0',
FSISLOCKCS char(1) null,
constraint PK_ORG_CHANGESRENTRY primary key (FENTRYID)
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGESRENTRY_FID */
/*==============================================================*/
create index IDX_ORG_CHANGESRENTRY_FID on T_ORG_CHANGESELFRULEENTRY (
FID ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGESRENTRY_FIX */
/*==============================================================*/
create index IDX_ORG_CHANGESRENTRY_FIX on T_ORG_CHANGESELFRULEENTRY (
FINDEX ASC
)
go


T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则):键值定义

名称

代码

主要的

PK_ORG_CHANGESRENTRY

PK_ORG_CHANGESRENTRY

TRUE


T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_ORG_CHANGESRENTRY_FID

IDX_ORG_CHANGESRENTRY_FID

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则)

IDX_ORG_CHANGESRENTRY_FIX

IDX_ORG_CHANGESRENTRY_FIX

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGESELFRULEENTRY(变更检查规则之自定义规则)