数据表:T_ASC_Receiver(共享任务接收人)

T_ASC_Receiver(共享任务接收人):描述

名称

T_ASC_Receiver(共享任务接收人)

代码

T_ASC_Receiver

注释

共享任务分配给具体的接收人

模型

BOS

主键

PK_ASC_RECEIVER


T_ASC_Receiver(共享任务接收人):列规格定义

名称

代码

数据类型

长度

强制

注释

内码

FASCReceiverId

int

 

TRUE

 

共享任务内码

FASCAssignId

int

 

TRUE

 

接收人表内码

FId

varchar(36)

36

TRUE

 

接收人用户内码

FReceiverId

int

 

TRUE

 

状态

FStatus

smallint

 

TRUE

1-生效中、2-已失效

分配时间

FDistTime

datetime

 

FALSE

 


T_ASC_Receiver(共享任务接收人):脚本代码

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

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

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

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

/*==============================================================*/
/* Table: T_ASC_Receiver */
/*==============================================================*/
create table T_ASC_Receiver (
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_RECEIVER primary key (FASCReceiverId)
)
go

/*==============================================================*/
/* Index: IDX_ASC_Receiver_ASCAssignId */
/*==============================================================*/
create index IDX_ASC_Receiver_ASCAssignId on T_ASC_Receiver (
FASCAssignId ASC
)
go

/*==============================================================*/
/* Index: IDX_ASC_Receiver_FId */
/*==============================================================*/
create index IDX_ASC_Receiver_FId on T_ASC_Receiver (
FId ASC
)
go

/*==============================================================*/
/* Index: IDX_ASC_Receiver_ReceiverId */
/*==============================================================*/
create index IDX_ASC_Receiver_ReceiverId on T_ASC_Receiver (
FReceiverId ASC
)
go


T_ASC_Receiver(共享任务接收人):键值定义

名称

代码

主要的

PK_ASC_RECEIVER

PK_ASC_RECEIVER

TRUE


T_ASC_Receiver(共享任务接收人):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_ASC_Receiver_ASCAssignId

IDX_ASC_Receiver_ASCAssignId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_Receiver(共享任务接收人)

IDX_ASC_Receiver_FId

IDX_ASC_Receiver_FId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_Receiver(共享任务接收人)

IDX_ASC_Receiver_ReceiverId

IDX_ASC_Receiver_ReceiverId

FALSE

FALSE

FALSE

FALSE

FALSE

T_ASC_Receiver(共享任务接收人)