数据表:T_WF_ENTRUSTRECEIVER(委托任务接收人)

T_WF_ENTRUSTRECEIVER(委托任务接收人):描述

名称

T_WF_ENTRUSTRECEIVER(委托任务接收人)

代码

T_WF_ENTRUSTRECEIVER

注释

 

模型

BOS

主键

Key_1


T_WF_ENTRUSTRECEIVER(委托任务接收人):列规格定义

名称

代码

数据类型

长度

强制

注释

内码

FENTRUSTRECEIVERID

int

 

TRUE

 

接收人表记录内码

FID

varchar(36)

36

TRUE

 

接收人用户内码

FRECEIVERID

int

 

TRUE

 

委托规则明细内码

FENTRUSTRULEENTRYID

int

 

TRUE

 

委托规则内码

FENTRUSTRULEID

int

 

TRUE

 

委托人用户内码

FCONSIGNOR

int

 

TRUE

 

委托人岗位内码

FCONSIGNORPOSTID

int

 

TRUE

 

委托状态

FCONSIGNSTATUS

smallint

 

TRUE

0:非委托
1:委托
2:撤销

委托时间

FCONSIGNTIME

datetime

 

FALSE

 


T_WF_ENTRUSTRECEIVER(委托任务接收人):脚本代码

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

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

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

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

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

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

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

/*==============================================================*/
/* Table: T_WF_ENTRUSTRECEIVER */
/*==============================================================*/
create table T_WF_ENTRUSTRECEIVER (
FENTRUSTRECEIVERID int not null default 0,
FID varchar(36) not null default '',
FRECEIVERID int not null default 0,
FENTRUSTRULEENTRYID int not null default 0,
FENTRUSTRULEID int not null default 0,
FCONSIGNOR int not null default 0,
FCONSIGNORPOSTID int not null default 0,
FCONSIGNSTATUS smallint not null default 0,
FCONSIGNTIME datetime null,
constraint PK_T_WF_ENTRUSTRECEIVER primary key (FENTRUSTRECEIVERID)
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_FID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_FID on T_WF_ENTRUSTRECEIVER (
FID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_RECEIVERID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_RECEIVERID on T_WF_ENTRUSTRECEIVER (
FRECEIVERID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_RULEENTRYID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_RULEENTRYID on T_WF_ENTRUSTRECEIVER (
FENTRUSTRULEENTRYID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_RULEID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_RULEID on T_WF_ENTRUSTRECEIVER (
FENTRUSTRULEID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_CONSIGNOR */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_CONSIGNOR on T_WF_ENTRUSTRECEIVER (
FCONSIGNOR ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCV_CSTATUS */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCV_CSTATUS on T_WF_ENTRUSTRECEIVER (
FCONSIGNSTATUS ASC
)
go


T_WF_ENTRUSTRECEIVER(委托任务接收人):键值定义

名称

代码

主要的

Key_1

Key_1

TRUE


T_WF_ENTRUSTRECEIVER(委托任务接收人):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_WF_ENTRUSTRCV_FID

IDX_WF_ENTRUSTRCV_FID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVER(委托任务接收人)

IDX_WF_ENTRUSTRCV_RECEIVERID

IDX_WF_ENTRUSTRCV_RECEIVERID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVER(委托任务接收人)

IDX_WF_ENTRUSTRCV_RULEENTRYID

IDX_WF_ENTRUSTRCV_RULEENTRYID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVER(委托任务接收人)

IDX_WF_ENTRUSTRCV_RULEID

IDX_WF_ENTRUSTRCV_RULEID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVER(委托任务接收人)

IDX_WF_ENTRUSTRCV_CONSIGNOR

IDX_WF_ENTRUSTRCV_CONSIGNOR

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVER(委托任务接收人)

IDX_WF_ENTRUSTRCV_CSTATUS

IDX_WF_ENTRUSTRCV_CSTATUS

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVER(委托任务接收人)