数据表:T_BAS_SMSSENDINFO(短信发送信息)

T_BAS_SMSSENDINFO(短信发送信息):描述

名称

T_BAS_SMSSENDINFO(短信发送信息)

代码

T_BAS_SMSSENDINFO

注释

短信发送信息

模型

BOS

主键

PK_SEC_SMSSENDINGINFO


T_BAS_SMSSENDINFO(短信发送信息):列规格定义

名称

代码

数据类型

长度

强制

注释

唯一标识

FID

int

 

TRUE

 

发送时间

FSENDTIME

datetime

 

FALSE

 

接受人

FRECEIVER

int

 

FALSE

 

业务类别

FTYPE

char(1)

1

FALSE

0,业务预警
1,短信验证码

手机号

FPHONE

varchar(20)

20

FALSE

 

接受短信数

FCOUNT

int

 

FALSE

 

发送状态

FSTATUS

char(1)

1

FALSE

0,成功
1,失败
2,发送中

供应商类别

FFACILITATOR

char(1)

1

FALSE

 

是否收费

FISPAY

char(1)

1

FALSE

是否收费 1 收费 0 不收费

接收人名称

FRECEIVERNAME

nvarchar(50)

50

FALSE

 

业务详情

FMESSAGEDETAIL

nvarchar(50)

50

FALSE

 

短信内容

FMSGCONTENT

varchar(255)

255

FALSE

 


T_BAS_SMSSENDINFO(短信发送信息):脚本代码

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

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

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

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

/*==============================================================*/
/* Table: T_BAS_SMSSENDINFO */
/*==============================================================*/
create table T_BAS_SMSSENDINFO (
FID int not null default 0,
FSENDTIME datetime null,
FRECEIVER int null,
FTYPE char(1) null,
FPHONE varchar(20) null,
FCOUNT int null,
FSTATUS char(1) null,
FFACILITATOR char(1) null,
FISPAY char(1) null,
FRECEIVERNAME nvarchar(50) null,
FMESSAGEDETAIL nvarchar(50) null,
FMSGCONTENT varchar(255) null,
constraint PK_T_BAS_SMSSENDINFO primary key (FID)
)
go

/*==============================================================*/
/* Index: IDX_BAS_SMSSENDINFO_RECEIVER */
/*==============================================================*/
create index IDX_BAS_SMSSENDINFO_RECEIVER on T_BAS_SMSSENDINFO (
FRECEIVER ASC
)
go

/*==============================================================*/
/* Index: IDX_BAS_SMSSENDINFO_SENDTIME */
/*==============================================================*/
create index IDX_BAS_SMSSENDINFO_SENDTIME on T_BAS_SMSSENDINFO (
FSENDTIME ASC
)
go

/*==============================================================*/
/* Index: IDX_BAS_SMSSENDINFO_PHONE */
/*==============================================================*/
create index IDX_BAS_SMSSENDINFO_PHONE on T_BAS_SMSSENDINFO (
FPHONE ASC
)
go


T_BAS_SMSSENDINFO(短信发送信息):键值定义

名称

代码

主要的

PK_SEC_SMSSENDINGINFO

PK_SEC_SMSSENDINGINFO

TRUE


T_BAS_SMSSENDINFO(短信发送信息):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_BAS_SMSSENDINFO_RECEIVER

IDX_BAS_SMSSENDINFO_RECEIVER

FALSE

FALSE

FALSE

FALSE

FALSE

T_BAS_SMSSENDINFO(短信发送信息)

IDX_BAS_SMSSENDINFO_SENDTIME

IDX_BAS_SMSSENDINFO_SENDTIME

FALSE

FALSE

FALSE

FALSE

FALSE

T_BAS_SMSSENDINFO(短信发送信息)

IDX_BAS_SMSSENDINFO_PHONE

IDX_BAS_SMSSENDINFO_PHONE

FALSE

FALSE

FALSE

FALSE

FALSE

T_BAS_SMSSENDINFO(短信发送信息)