/*
================================================================================
档案代号:czd_file
档案名称:职委会给付资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table czd_file
(
czd01       varchar2(4) NOT NULL,    /*类别                                   */
czd02       date NOT NULL,           /*发放日期                               */
czd03       varchar2(10) NOT NULL,   /*员工编号                               */
czd04       number(20,6),            /*应发金额                               */
                                     /*应发金额        NO.A066                */
czd05       number(20,6)             /*税额                                   */
                                     /*税额            NO.A066                */
);

create unique index czd_pk on czd_file (czd01,czd02,czd03);
alter table czd_file add  constraint czd_pk primary key  (czd01,czd02,czd03) enable validate;
grant select on czd_file to public;
grant index on czd_file to public;
grant update on czd_file to public;
grant delete on czd_file to public;
grant insert on czd_file to public;