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

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

名称

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

代码

T_PA_DIMENSIONENTRY

注释

 

模型

PA

主键

PK_PA_DIMENSIONENTRY


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

名称

代码

数据类型

长度

强制

注释

维度模型内码

FID

int

 

TRUE

 

分录内码

FENTRYID

int

 

TRUE

 

显示序号

FORDERNUMBER

int

 

FALSE

 

维度名

FSELECTDIM

nvarchar(50)

50

FALSE

 

维度类型

FDATATYPE

varchar(20)

20

FALSE

 

维度元素类型

FELEMTYPE

nvarchar(50)

50

FALSE

 

维度类型编码

FDIMTYPENUMBER

nvarchar(50)

50

FALSE

 

主键字段名

FPKFIELDNAME

nvarchar(50)

50

FALSE

 

编号字段名

FNUMBERFIELDNAME

nvarchar(50)

50

FALSE

 

名称字段名

FNAMEFIELDNAME

nvarchar(50)

50

FALSE

 

对应人员实体

FPERSONENTITY

nvarchar(50)

50

FALSE

 

对应人员字段

FPERSONFIELD

nvarchar(50)

50

FALSE

 

人员实体主键

FPERTABLEPK

nvarchar(50)

50

FALSE

 


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

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_DIMENSIONENTRY') and o.name = 'FK_T_PA_DIMENSIONENTRY')
alter table T_PA_DIMENSIONENTRY
drop constraint FK_T_PA_DIMENSIONENTRY
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_DIMENSIONENTRY_L') and o.name = 'FK_T_PA_DIMENSIONENTRY_L')
alter table T_PA_DIMENSIONENTRY_L
drop constraint FK_T_PA_DIMENSIONENTRY_L
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') and o.name = 'FK_T_PA_DIMENSIONSUBENTRY')
alter table T_PA_DIMENSIONSUBENTRY
drop constraint FK_T_PA_DIMENSIONSUBENTRY
go

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

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

/*==============================================================*/
/* Table: T_PA_DIMENSIONENTRY */
/*==============================================================*/
create table T_PA_DIMENSIONENTRY (
FID int not null default 0,
FENTRYID int not null default 0,
FORDERNUMBER int null,
FSELECTDIM nvarchar(50) null,
FDATATYPE varchar(20) null,
FELEMTYPE nvarchar(50) null,
FDIMTYPENUMBER nvarchar(50) null,
FPKFIELDNAME nvarchar(50) null,
FNUMBERFIELDNAME nvarchar(50) null,
FNAMEFIELDNAME nvarchar(50) null,
FPERSONENTITY nvarchar(50) null,
FPERSONFIELD nvarchar(50) null,
FPERTABLEPK nvarchar(50) null,
constraint PK_T_PA_DIMENSIONENTRY primary key (FENTRYID)
)
go

/*==============================================================*/
/* Index: IDX_PA_DIMENSIONENTRY */
/*==============================================================*/
create index IDX_PA_DIMENSIONENTRY on T_PA_DIMENSIONENTRY (
FID ASC
)
go

alter table T_PA_DIMENSIONENTRY
add constraint FK_T_PA_DIMENSIONENTRY foreign key (FID)
references T_PA_SALARYDIMENSIONMODEL (FID)
go


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

名称

代码

主要的

PK_PA_DIMENSIONENTRY

PK_PA_DIMENSIONENTRY

TRUE


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

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_PA_DIMENSIONENTRY

IDX_PA_DIMENSIONENTRY

FALSE

FALSE

FALSE

TRUE

FALSE

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