数据表:T_ASC_DistPolicyObjs(共享任务分配策略_单据范围)

T_ASC_DistPolicyObjs(共享任务分配策略_单据范围):描述

名称

T_ASC_DistPolicyObjs(共享任务分配策略_单据范围)

代码

T_ASC_DistPolicyObjs

注释

共享任务分配策略_单据范围

模型

BOS

主键

PK_ASC_DISTPOLICYOBJS


T_ASC_DistPolicyObjs(共享任务分配策略_单据范围):列规格定义

名称

代码

数据类型

长度

强制

注释

内码

FEntryId

int

 

TRUE

 

分配策略内码

FId

int

 

TRUE

 

序号

FSeq

int

 

TRUE

 

单据

FObjectTypeId

varchar(36)

36

TRUE

 


T_ASC_DistPolicyObjs(共享任务分配策略_单据范围):脚本代码

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

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

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

/*==============================================================*/
/* Table: T_ASC_DistPolicyObjs */
/*==============================================================*/
create table T_ASC_DistPolicyObjs (
FEntryId int not null default 0,
FId int not null default 0,
FSeq int not null default 0,
FObjectTypeId varchar(36) not null default '',
constraint PK_ASC_DISTPOLICYOBJS primary key (FEntryId)
)
go

/*==============================================================*/
/* Index: IDX_ASC_DistPolicyObjs_PId */
/*==============================================================*/
create index IDX_ASC_DistPolicyObjs_PId on T_ASC_DistPolicyObjs (
FId ASC
)
go

/*==============================================================*/
/* Index: IDX_ASC_DistPolicyObjs_OId */
/*==============================================================*/
create index IDX_ASC_DistPolicyObjs_OId on T_ASC_DistPolicyObjs (
FObjectTypeId ASC
)
go


T_ASC_DistPolicyObjs(共享任务分配策略_单据范围):键值定义

名称

代码

主要的

PK_ASC_DISTPOLICYOBJS

PK_ASC_DISTPOLICYOBJS

TRUE


T_ASC_DistPolicyObjs(共享任务分配策略_单据范围):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_ASC_DistPolicyObjs_PId

IDX_ASC_DistPolicyObjs_PId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_DistPolicyObjs(共享任务分配策略_单据范围)

IDX_ASC_DistPolicyObjs_OId

IDX_ASC_DistPolicyObjs_OId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_DistPolicyObjs(共享任务分配策略_单据范围)