数据表:T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史):描述

名称

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)

代码

T_WF_ENTRUSTRECEIVERHIS

注释

 

模型

BOS

主键

Key_1


T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史):列规格定义

名称

代码

数据类型

长度

强制

注释

内码

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_ENTRUSTRECEIVERHIS(委托任务接收人_历史):脚本代码

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

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

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

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

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

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

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

/*==============================================================*/
/* Table: T_WF_ENTRUSTRECEIVERHIS */
/*==============================================================*/
create table T_WF_ENTRUSTRECEIVERHIS (
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_ENTRUSTRECEIVERHIS primary key (FENTRUSTRECEIVERID)
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_FID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_FID on T_WF_ENTRUSTRECEIVERHIS (
FID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_RECEIVERID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_RECEIVERID on T_WF_ENTRUSTRECEIVERHIS (
FRECEIVERID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_RULEENTRYID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_RULEENTRYID on T_WF_ENTRUSTRECEIVERHIS (
FENTRUSTRULEENTRYID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_RULEID */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_RULEID on T_WF_ENTRUSTRECEIVERHIS (
FENTRUSTRULEID ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_CONSIGNOR */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_CONSIGNOR on T_WF_ENTRUSTRECEIVERHIS (
FCONSIGNOR ASC
)
go

/*==============================================================*/
/* Index: IDX_WF_ENTRUSTRCH_CSTATUS */
/*==============================================================*/
create index IDX_WF_ENTRUSTRCH_CSTATUS on T_WF_ENTRUSTRECEIVERHIS (
FCONSIGNSTATUS ASC
)
go


T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史):键值定义

名称

代码

主要的

Key_1

Key_1

TRUE


T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_WF_ENTRUSTRCH_FID

IDX_WF_ENTRUSTRCH_FID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)

IDX_WF_ENTRUSTRCH_RECEIVERID

IDX_WF_ENTRUSTRCH_RECEIVERID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)

IDX_WF_ENTRUSTRCH_RULEENTRYID

IDX_WF_ENTRUSTRCH_RULEENTRYID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)

IDX_WF_ENTRUSTRCH_RULEID

IDX_WF_ENTRUSTRCH_RULEID

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)

IDX_WF_ENTRUSTRCH_CONSIGNOR

IDX_WF_ENTRUSTRCH_CONSIGNOR

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)

IDX_WF_ENTRUSTRCH_CSTATUS

IDX_WF_ENTRUSTRCH_CSTATUS

FALSE

FALSE

FALSE

FALSE

FALSE

T_WF_ENTRUSTRECEIVERHIS(委托任务接收人_历史)