use zhengcaioa
|
|
if exists (select 1
|
from sysobjects
|
where id = object_id('t_salary_appeal')
|
and type = 'U')
|
drop table t_salary_appeal
|
go
|
|
/*==============================================================*/
|
/* Table: t_salary_appeal */
|
/*==============================================================*/
|
create table t_salary_appeal (
|
id int identity,
|
salary_id nvarchar(50) null,
|
reason nvarchar(1000) null,
|
amount decimal(10,2) null,
|
basis nvarchar(500) null,
|
sub_user nvarchar(50) null,
|
sub_time datetime null,
|
chk_user nvarchar(50) null,
|
chk_time datetime null,
|
chk_result nvarchar(1000) null,
|
status nvarchar(1) null,
|
constraint PK_T_SALARY_APPEAL primary key (id)
|
)
|
go
|
