数据表:T_PA_SALARYPAYMENTENTRY(发放明细表)

T_PA_SALARYPAYMENTENTRY(发放明细表):描述

名称

T_PA_SALARYPAYMENTENTRY(发放明细表)

代码

T_PA_SALARYPAYMENTENTRY

注释

 

模型

PA

主键

PK_PA_SALARYPAYMENTENTRY


T_PA_SALARYPAYMENTENTRY(发放明细表):列规格定义

名称

代码

数据类型

长度

强制

注释

发放明细内码

FENTRYID

int

 

TRUE

 

发放内码

FID

int

 

FALSE

 

发放方式

FPAYMODE

char(1)

1

FALSE

X:现金
Y:银行卡

银行内码

FBANKID

int

 

FALSE

 

开户人

FACCOUNTPERSON

nvarchar(80)

80

FALSE

 

银行账号

FACCOUNT

nvarchar(30)

30

FALSE

 

发放类型

FPAYTYPE

char(1)

1

FALSE

K:按固定金额
B:按比例
S:按剩余额度

比例(%)

FPERCENT

decimal(19,6)

19

FALSE

 

金额

FMONEY

decimal(19,6)

19

FALSE

 

描述

FDESCRIPTION

nvarchar(255)

255

FALSE

 

证件号码

FCARD

nvarchar(80)

80

FALSE

 


T_PA_SALARYPAYMENTENTRY(发放明细表):脚本代码

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_SALARYPAYMENTENTRY') and o.name = 'FK_PA_SALARYPAYMENTENTRY')
alter table T_PA_SALARYPAYMENTENTRY
drop constraint FK_PA_SALARYPAYMENTENTRY
go

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

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

/*==============================================================*/
/* Table: T_PA_SALARYPAYMENTENTRY */
/*==============================================================*/
create table T_PA_SALARYPAYMENTENTRY (
FENTRYID int not null default 0,
FID int null,
FPAYMODE char(1) null,
FBANKID int null,
FACCOUNTPERSON nvarchar(80) null,
FACCOUNT nvarchar(30) null,
FPAYTYPE char(1) null,
FPERCENT decimal(19,6) null,
FMONEY decimal(19,6) null,
FDESCRIPTION nvarchar(255) null default ' ',
FCARD nvarchar(80) null default ' ',
constraint PK_SALARYPAYMENTENTRY primary key (FENTRYID)
)
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'X:现金
Y:银行卡',
'user', @CurrentUser, 'table', 'T_PA_SALARYPAYMENTENTRY', 'column', 'FPAYMODE'
go

declare @CurrentUser sysname
select @CurrentUser = user_name()
execute sp_addextendedproperty 'MS_Description',
'K:按固定金额
B:按比例
S:按剩余额度',
'user', @CurrentUser, 'table', 'T_PA_SALARYPAYMENTENTRY', 'column', 'FPAYTYPE'
go

/*==============================================================*/
/* Index: IDX_PA_SPMENTENTRY_FK */
/*==============================================================*/
create index IDX_PA_SPMENTENTRY_FK on T_PA_SALARYPAYMENTENTRY (
FID ASC
)
go

alter table T_PA_SALARYPAYMENTENTRY
add constraint FK_PA_SALARYPAYMENTENTRY foreign key (FID)
references T_PA_SALARYPAYMENT (FID)
go


T_PA_SALARYPAYMENTENTRY(发放明细表):键值定义

名称

代码

主要的

PK_PA_SALARYPAYMENTENTRY

PK_PA_SALARYPAYMENTENTRY

TRUE


T_PA_SALARYPAYMENTENTRY(发放明细表):索引定义

名称

代码

唯一的

群集器

主要的

外键

候选键

表格

IDX_PA_SPMENTENTRY_FK

IDX_PA_SPMENTENTRY_FK

FALSE

FALSE

FALSE

TRUE

FALSE

T_PA_SALARYPAYMENTENTRY(发放明细表)