数据表:T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录)

T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录):描述

名称

T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录)

代码

T_PA_PAYPLANITEMENTRY

注释

 

模型

PA

主键

PK_PA_PAYPLANPAYITEM


T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录):列规格定义

名称

代码

数据类型

长度

强制

注释

薪酬方案主键

FID

int

 

TRUE

 

分录主键

FENTRYID

int

 

TRUE

 

顺序号

FORDER

int

 

FALSE

 

薪酬项目ID

FPAYITEMID

int

 

FALSE

 

启用状态

FISENABLE

varchar(20)

20

FALSE

 

输入类型

FINPUTTYPE

varchar(20)

20

FALSE

 

手工输入项目类型

FITEMTYPE

char(1)

1

FALSE

 


T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录):脚本代码

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_PAYPLANITEMENTRY') and o.name = 'FK_PA_PAYPLAN_PAYITEM')
alter table T_PA_PAYPLANITEMENTRY
drop constraint FK_PA_PAYPLAN_PAYITEM
go

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

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

/*==============================================================*/
/* Table: T_PA_PAYPLANITEMENTRY */
/*==============================================================*/
create table T_PA_PAYPLANITEMENTRY (
FID int not null default 0,
FENTRYID int not null default 0,
FORDER int null default 0,
FPAYITEMID int null default 0,
FISENABLE varchar(20) null,
FINPUTTYPE varchar(20) null,
FITEMTYPE char(1) null,
constraint PK_T_PA_PAYPLANITEMENTRY primary key (FENTRYID)
)
go

/*==============================================================*/
/* Index: IDX_PA_PAYPLANPAYITEM */
/*==============================================================*/
create index IDX_PA_PAYPLANPAYITEM on T_PA_PAYPLANITEMENTRY (
FID ASC
)
go

alter table T_PA_PAYPLANITEMENTRY
add constraint FK_PA_PAYPLAN_PAYITEM foreign key (FID)
references T_PA_PAYPLAN (FID)
go


T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录):键值定义

名称

代码

主要的

PK_PA_PAYPLANPAYITEM

PK_PA_PAYPLANPAYITEM

TRUE


T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_PA_PAYPLANPAYITEM

IDX_PA_PAYPLANPAYITEM

FALSE

FALSE

FALSE

TRUE

FALSE

T_PA_PAYPLANITEMENTRY(薪酬方案薪酬项目分录)