数据表:T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细)

T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细):描述

名称

T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细)

代码

T_PA_DIMENSIONSUBENTRY

注释

 

模型

PA

主键

PK_PA_DIMENSIONSUBENTRY


T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细):列规格定义

名称

代码

数据类型

长度

强制

注释

分录内码

FENTRYID

int

 

FALSE

 

内码

FDETAILID

int

 

TRUE

 

维度子明细编码

FDMITEMNUMBER

nvarchar(50)

50

FALSE

 

显示序号

FORDERNUMBER

int

 

FALSE

 

维度子明细内码

FBASEITEMID

nvarchar(50)

50

FALSE

 

是否选用

FISUSE

char(1)

1

FALSE

 

创建组织

FCREATEORG

int

 

FALSE

 

使用组织

FUSEORG

int

 

FALSE

 

标准表显示值

FVALUE

nvarchar(50)

50

FALSE

 


T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细):脚本代码

if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('T_PA_DIMENSIONSUBENTRY') and o.name = 'FK_T_PA_DIMENSIONSUBENTRY')
alter table T_PA_DIMENSIONSUBENTRY
drop constraint FK_T_PA_DIMENSIONSUBENTRY
go

if exists (select 1
from sys.sysreferences r join sys.sysobjects o on (o.id = r.constid and o.type = 'F')
where r.fkeyid = object_id('T_PA_DIMENSIONSUBENTRY_L') and o.name = 'FK_T_PA_DIMENSIONSUBENTRY_L')
alter table T_PA_DIMENSIONSUBENTRY_L
drop constraint FK_T_PA_DIMENSIONSUBENTRY_L
go

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

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

/*==============================================================*/
/* Table: T_PA_DIMENSIONSUBENTRY */
/*==============================================================*/
create table T_PA_DIMENSIONSUBENTRY (
FENTRYID int null,
FDETAILID int not null default 0,
FDMITEMNUMBER nvarchar(50) null,
FORDERNUMBER int null,
FBASEITEMID nvarchar(50) null,
FISUSE char(1) null,
FCREATEORG int null,
FUSEORG int null,
FVALUE nvarchar(50) null,
constraint PK_T_PA_DIMENSIONSUBENTRY primary key (FDETAILID)
)
go

/*==============================================================*/
/* Index: IDX_PA_DIMSUBENTRY */
/*==============================================================*/
create index IDX_PA_DIMSUBENTRY on T_PA_DIMENSIONSUBENTRY (
FENTRYID ASC
)
go

alter table T_PA_DIMENSIONSUBENTRY
add constraint FK_T_PA_DIMENSIONSUBENTRY foreign key (FENTRYID)
references T_PA_DIMENSIONENTRY (FENTRYID)
go


T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细):键值定义

名称

代码

主要的

PK_PA_DIMENSIONSUBENTRY

PK_PA_DIMENSIONSUBENTRY

TRUE


T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_PA_DIMSUBENTRY

IDX_PA_DIMSUBENTRY

FALSE

FALSE

FALSE

TRUE

FALSE

T_PA_DIMENSIONSUBENTRY(薪酬标准维度模型子明细)