/*
================================================================================
档案代号:taa_file
档案名称:
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table taa_file
(
taa01       varchar2(10) DEFAULT '' NOT NULL, /*员工代号*/
taa02       number(5) DEFAULT '0' NOT NULL, /*年度*/
taa03       number(5) DEFAULT '0' NOT NULL, /*月份*/
taa04       number(20,6) DEFAULT '0',/*课税所得总额                           */
taa05       number(20,6) DEFAULT '0',/*所得税总额                             */
taa06       number(20,6) DEFAULT '0',/*no use                                 */
taa07       varchar2(40)             /*no use                                 */
);

create unique index taa_pk on taa_file (taa01,taa02,taa03);
alter table taa_file add  constraint taa_pk primary key  (taa01,taa02,taa03) enable validate;
grant select on taa_file to public;
grant index on taa_file to public;
grant update on taa_file to public;
grant delete on taa_file to public;
grant insert on taa_file to public;