数据表:T_ORG_CHANGERULEENTRY(变更检查规则之检查规则)

T_ORG_CHANGERULEENTRY(变更检查规则之检查规则):描述

名称

T_ORG_CHANGERULEENTRY(变更检查规则之检查规则)

代码

T_ORG_CHANGERULEENTRY

注释

 

模型

BOS

主键

PK_ORG_CHANGERULEENTRY


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

名称

代码

数据类型

长度

强制

注释

明细分录内码

FENTRYID

varchar(36)

36

TRUE

 

变更检查规则内码

FID

varchar(36)

36

TRUE

 

序号字段

FINDEX

smallint

 

TRUE

 

业务对象

FOBJECTTYPEID

varchar(36)

36

TRUE

 

组织字段名称

FORGNAME

nvarchar(80)

80

TRUE

 

检查条件

FCHECKRULEID

varchar(36)

36

FALSE

 

预设

FISSYSPRESET

char(1)

1

TRUE

 

控制强度

FCONTROLSTRENGTH

char(1)

1

TRUE

0:强制
1:忽略

锁定控制强度

FISLOCKCS

char(1)

1

FALSE

 

业务领域

FTOPCLASSID

varchar(36)

36

FALSE

 

子系统

FSUBSYSID

varchar(36)

36

FALSE

 

组织字段Key

FORGKEY

varchar(80)

80

FALSE

 


T_ORG_CHANGERULEENTRY(变更检查规则之检查规则):脚本代码

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

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

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

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

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

/*==============================================================*/
/* Table: T_ORG_CHANGERULEENTRY */
/*==============================================================*/
create table T_ORG_CHANGERULEENTRY (
FENTRYID varchar(36) not null default ' ',
FID varchar(36) not null default ' ',
FINDEX smallint not null default 0,
FOBJECTTYPEID varchar(36) not null default ' ',
FORGNAME nvarchar(80) not null default ' ',
FCHECKRULEID varchar(36) null,
FISSYSPRESET char(1) not null default '0',
FCONTROLSTRENGTH char(1) not null default '0',
FISLOCKCS char(1) null,
FTOPCLASSID varchar(36) null,
FSUBSYSID varchar(36) null,
FORGKEY varchar(80) null,
constraint PK_ORG_CHANGERULEENTRY primary key (FENTRYID)
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGERULEE_FID */
/*==============================================================*/
create index IDX_ORG_CHANGERULEE_FID on T_ORG_CHANGERULEENTRY (
FID ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGERULEE_FIX */
/*==============================================================*/
create index IDX_ORG_CHANGERULEE_FIX on T_ORG_CHANGERULEENTRY (
FINDEX ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGERULEE_FOBJ */
/*==============================================================*/
create index IDX_ORG_CHANGERULEE_FOBJ on T_ORG_CHANGERULEENTRY (
FOBJECTTYPEID ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGERULEE_FORG */
/*==============================================================*/
create index IDX_ORG_CHANGERULEE_FORG on T_ORG_CHANGERULEENTRY (
FORGNAME ASC
)
go


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

名称

代码

主要的

PK_ORG_CHANGERULEENTRY

PK_ORG_CHANGERULEENTRY

TRUE


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

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_ORG_CHANGERULEE_FID

IDX_ORG_CHANGERULEE_FID

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGERULEENTRY(变更检查规则之检查规则)

IDX_ORG_CHANGERULEE_FIX

IDX_ORG_CHANGERULEE_FIX

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGERULEENTRY(变更检查规则之检查规则)

IDX_ORG_CHANGERULEE_FOBJ

IDX_ORG_CHANGERULEE_FOBJ

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGERULEENTRY(变更检查规则之检查规则)

IDX_ORG_CHANGERULEE_FORG

IDX_ORG_CHANGERULEE_FORG

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGERULEENTRY(变更检查规则之检查规则)