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
