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

T_ORG_BDORGCHANGE(基础资料组织变更):描述

名称

T_ORG_BDORGCHANGE(基础资料组织变更)

代码

T_ORG_BDORGCHANGE

注释

 

模型

BOS

主键

PK_ORG_BDORGCHANGE


T_ORG_BDORGCHANGE(基础资料组织变更):列规格定义

名称

代码

数据类型

长度

强制

注释

内码

FID

int

 

TRUE

 

编号

FBILLNO

nvarchar(30)

30

TRUE

 

组织变更方案

FCHANGINGPLAN

varchar(36)

36

FALSE

 

变更前创建组织

FBCHANGECORGID

int

 

TRUE

 

基础资料

FBASE

varchar(36)

36

TRUE

 

变更人

FEXECUTORID

int

 

TRUE

 

变更日期

FEXECUTORDATE

datetime

 

FALSE

 


T_ORG_BDORGCHANGE(基础资料组织变更):脚本代码

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

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

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

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

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

/*==============================================================*/
/* Table: T_ORG_BDORGCHANGE */
/*==============================================================*/
create table T_ORG_BDORGCHANGE (
FID int not null default 0,
FBILLNO nvarchar(30) not null default ' ',
FCHANGINGPLAN varchar(36) null,
FBCHANGECORGID int not null default 0,
FBASE varchar(36) not null default ' ',
FEXECUTORID int not null default 0,
FEXECUTORDATE datetime null,
constraint PK_ORG_BDORGCHANGE primary key (FID)
)
go

/*==============================================================*/
/* Index: IDX_ORG_BDORGCHANGE_BN */
/*==============================================================*/
create index IDX_ORG_BDORGCHANGE_BN on T_ORG_BDORGCHANGE (
FBILLNO ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_BDORGCHANGE_CP */
/*==============================================================*/
create index IDX_ORG_BDORGCHANGE_CP on T_ORG_BDORGCHANGE (
FCHANGINGPLAN ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_BDORGCHANGE_BCOI */
/*==============================================================*/
create index IDX_ORG_BDORGCHANGE_BCOI on T_ORG_BDORGCHANGE (
FBCHANGECORGID ASC
)
go

/*==============================================================*/
/* Index: IDX_ORG_BDORGCHANGE_BASE */
/*==============================================================*/
create index IDX_ORG_BDORGCHANGE_BASE on T_ORG_BDORGCHANGE (
FBASE ASC
)
go


T_ORG_BDORGCHANGE(基础资料组织变更):键值定义

名称

代码

主要的

PK_ORG_BDORGCHANGE

PK_ORG_BDORGCHANGE

TRUE


T_ORG_BDORGCHANGE(基础资料组织变更):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_ORG_BDORGCHANGE_BN

IDX_ORG_BDORGCHANGE_BN

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_BDORGCHANGE(基础资料组织变更)

IDX_ORG_BDORGCHANGE_CP

IDX_ORG_BDORGCHANGE_CP

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_BDORGCHANGE(基础资料组织变更)

IDX_ORG_BDORGCHANGE_BCOI

IDX_ORG_BDORGCHANGE_BCOI

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_BDORGCHANGE(基础资料组织变更)

IDX_ORG_BDORGCHANGE_BASE

IDX_ORG_BDORGCHANGE_BASE

FALSE

FALSE

FALSE

FALSE

FALSE

T_ORG_BDORGCHANGE(基础资料组织变更)