数据表:T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据)

T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据):描述

名称

T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据)

代码

T_ORG_CHANGEBDENTITY

注释

 

模型

BOS

主键

PK_ORG_CHANGEBDENTITY


T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据):列规格定义

名称

代码

数据类型

长度

强制

注释

明细内码

FEntryID

int

 

TRUE

 

基础资料变更内码

FID

int

 

TRUE

 

序号

FINDEX

int

 

TRUE

 

变更后创建组织

FAFTERCHANGEORGID

int

 

TRUE

 

基础资料内码

FBASEID

varchar(36)

36

TRUE

 

基础资料编号

FBASENUMBER

varchar(255)

255

TRUE

 

执行结果

FEXCUTESTAUS

char(1)

1

FALSE

 

执行信息

FEXCUTEINFO

nvarchar(255)

255

FALSE

 


T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据):脚本代码

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

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

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

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

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

/*==============================================================*/
/* Table: T_ORG_CHANGEBDENTITY */
/*==============================================================*/
create table T_ORG_CHANGEBDENTITY (
FEntryID int not null default 0,
FID int not null default 0,
FINDEX int not null default 0,
FAFTERCHANGEORGID int not null default 0,
FBASEID varchar(36) not null default ' ',
FBASENUMBER varchar(255) not null default ' ',
FEXCUTESTAUS char(1) null,
FEXCUTEINFO nvarchar(255) null,
constraint PK_ORG_CHANGEBDENTITY primary key (FEntryID)
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGEBDENTITY_FID */
/*==============================================================*/
create index IDX_ORG_CHANGEBDENTITY_FID on T_ORG_CHANGEBDENTITY (
FID ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGEBDENTITY_IDX */
/*==============================================================*/
create index IDX_ORG_CHANGEBDENTITY_IDX on T_ORG_CHANGEBDENTITY (
FINDEX ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGEBDENTITY_ACO */
/*==============================================================*/
create index IDX_ORG_CHANGEBDENTITY_ACO on T_ORG_CHANGEBDENTITY (
FAFTERCHANGEORGID ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_CHANGEBDENTITY_BID */
/*==============================================================*/
create index IDX_ORG_CHANGEBDENTITY_BID on T_ORG_CHANGEBDENTITY (
FBASEID ASC
)
go


T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据):键值定义

名称

代码

主要的

PK_ORG_CHANGEBDENTITY

PK_ORG_CHANGEBDENTITY

TRUE


T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_ORG_CHANGEBDENTITY_FID

IDX_ORG_CHANGEBDENTITY_FID

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据)

IDX_ORG_CHANGEBDENTITY_IDX

IDX_ORG_CHANGEBDENTITY_IDX

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据)

IDX_ORG_CHANGEBDENTITY_ACO

IDX_ORG_CHANGEBDENTITY_ACO

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据)

IDX_ORG_CHANGEBDENTITY_BID

IDX_ORG_CHANGEBDENTITY_BID

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_CHANGEBDENTITY(基础资料组织变更之变更数据)