数据表:T_ASC_ReceiverHis(共享任务接收人_历史)

T_ASC_ReceiverHis(共享任务接收人_历史):描述

名称

T_ASC_ReceiverHis(共享任务接收人_历史)

代码

T_ASC_ReceiverHis

注释

共享任务接收人_历史

模型

BOS

主键

PK_ASC_RECEIVERHIS


T_ASC_ReceiverHis(共享任务接收人_历史):列规格定义

名称

代码

数据类型

长度

强制

注释

内码

FASCReceiverId

int

 

TRUE

 

共享任务内码

FASCAssignId

int

 

TRUE

 

接收人表内码

FId

varchar(36)

36

TRUE

 

接收人用户内码

FReceiverId

int

 

TRUE

 

状态

FStatus

smallint

 

TRUE

1-生效中、2-已失效

分配时间

FDistTime

datetime

 

FALSE

 


T_ASC_ReceiverHis(共享任务接收人_历史):脚本代码

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

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

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

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

/*==============================================================*/
/* Table: T_ASC_ReceiverHis */
/*==============================================================*/
create table T_ASC_ReceiverHis (
FASCReceiverId int not null default 0,
FASCAssignId int not null default 0,
FId varchar(36) not null default '',
FReceiverId int not null default 0,
FStatus smallint not null default 1,
FDistTime datetime null,
constraint PK_ASC_RECEIVERHIS primary key (FASCReceiverId)
)
go

/*==============================================================*/
/* Index: IDX_ASC_ReceiverHis_ASCAsId */
/*==============================================================*/
create index IDX_ASC_ReceiverHis_ASCAsId on T_ASC_ReceiverHis (
FASCAssignId ASC
)
go

/*==============================================================*/
/* Index: IDX_ASC_ReceiverHis_FId */
/*==============================================================*/
create index IDX_ASC_ReceiverHis_FId on T_ASC_ReceiverHis (
FId ASC
)
go

/*==============================================================*/
/* Index: IDX_ASC_ReceiverHis_RecId */
/*==============================================================*/
create index IDX_ASC_ReceiverHis_RecId on T_ASC_ReceiverHis (
FReceiverId ASC
)
go


T_ASC_ReceiverHis(共享任务接收人_历史):键值定义

名称

代码

主要的

PK_ASC_RECEIVERHIS

PK_ASC_RECEIVERHIS

TRUE


T_ASC_ReceiverHis(共享任务接收人_历史):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_ASC_ReceiverHis_ASCAsId

IDX_ASC_ReceiverHis_ASCAsId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_ReceiverHis(共享任务接收人_历史)

IDX_ASC_ReceiverHis_FId

IDX_ASC_ReceiverHis_FId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_ReceiverHis(共享任务接收人_历史)

IDX_ASC_ReceiverHis_RecId

IDX_ASC_ReceiverHis_RecId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_ReceiverHis(共享任务接收人_历史)