数据表:t_BF_InstanceAmountHis (流程携带历史表)

t_BF_InstanceAmountHis (流程携带历史表):描述

名称

t_BF_InstanceAmountHis (流程携带历史表)

代码

T_BF_INSTANCEAMOUNTHIS

注释

对发生时间超过一定期限的数据,迁移到本表,减少正式表数据量。

模型

BOS

主键

PK_BF_INSTANCEAMOUNTHIS


t_BF_InstanceAmountHis (流程携带历史表):列规格定义

名称

代码

数据类型

长度

强制

注释

数据内码

FDetailId

varchar(36)

36

TRUE

 

路线内码

FRouteId

varchar(36)

36

TRUE

 

源单字段

FSourceField

varchar(30)

30

FALSE

默认为字段Key,如果是常用字段,则用A-Z字符串代表,节省存储空间:
A = FBaseUnitQty;
B = FQty;
C = FAmount;
D = FBasicUnitQty;
E = FBaseQty;
F = FBaseMustQty;

目标单字段

FTargetField

varchar(30)

30

TRUE

默认为字段Key,如果是常用字段,则用A-Z字符串代表,节省存储空间:
A = FBaseUnitQty;
B = FQty;
C = FAmount;
D = FBasicUnitQty;
E = FBaseQty;
F = FBaseMustQty;

携带数值

FAmount

decimal(23,10)

23

TRUE

 

创建时间

FCreateTime

datetime

 

FALSE

 

归档时间

FBackUpTime

datetime

 

FALSE

 


t_BF_InstanceAmountHis (流程携带历史表):脚本代码

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

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

/*==============================================================*/
/* Table: T_BF_INSTANCEAMOUNTHIS */
/*==============================================================*/
create table T_BF_INSTANCEAMOUNTHIS (
FDetailId varchar(36) not null default NEWID(),
FRouteId varchar(36) not null default '',
FSourceField varchar(30) null default '',
FTargetField varchar(30) not null default '',
FAmount decimal(23,10) not null default 0,
FCreateTime datetime null,
FBackUpTime datetime null,
constraint PK_BF_INSTANCEAMOUNTHIS primary key (FDetailId)
)
go

/*==============================================================*/
/* Index: IDX_BF_INSTANCEAMOUNTHIS */
/*==============================================================*/
create index IDX_BF_INSTANCEAMOUNTHIS on T_BF_INSTANCEAMOUNTHIS (
FRouteId ASC
)
go


t_BF_InstanceAmountHis (流程携带历史表):键值定义

名称

代码

主要的

PK_BF_INSTANCEAMOUNTHIS

PK_BF_INSTANCEAMOUNTHIS

TRUE


t_BF_InstanceAmountHis (流程携带历史表):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_BF_INSTANCEAMOUNTHIS

IDX_BF_INSTANCEAMOUNTHIS

FALSE

FALSE

FALSE

FALSE

FALSE

t_BF_InstanceAmountHis (流程携带历史表)