/*
================================================================================
档案代号:tab_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table tab_file
(
tab01       varchar2(10) DEFAULT '' NOT NULL, /*员工代号*/
tab02       number(5) DEFAULT '0' NOT NULL, /*所得税计算年月*/
tab03       number(5) DEFAULT '0' NOT NULL, /*所得税计算月份*/
tab04       number(5) DEFAULT '0' NOT NULL, /*所得税计算序号*/
tab05       varchar2(1) DEFAULT '' NOT NULL, /*课税所得来源*/
tab06       varchar2(5) DEFAULT '' NOT NULL, /*计薪指标*/
tab07       number(5) DEFAULT '0' NOT NULL, /*次数*/
tab08       number(20,6) DEFAULT '0',/*课税所得                               */
tab09       number(20,6) DEFAULT '0',/*所得税                                 */
tab10       varchar2(1) DEFAULT 'n' NOT NULL, /*发放*/
tab11       varchar2(1) DEFAULT 'y' NOT NULL, /*合并计算*/
tab12       varchar2(10),            /*no use                                 */
tab13       number(20,6) DEFAULT '0 /*no use/<020' /*no use*/
);

create unique index tab_pk on tab_file (tab01,tab02,tab03,tab04);
alter table tab_file add  constraint tab_pk primary key  (tab01,tab02,tab03,tab04) enable validate;
grant select on tab_file to public;
grant index on tab_file to public;
grant update on tab_file to public;
grant delete on tab_file to public;
grant insert on tab_file to public;