/*
================================================================================
档案代号:cpg_file
档案名称:员工其它津贴扣款项目资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cpg_file
(
cpg01       varchar2(10) NOT NULL,   /*员工代号                               */
cpg02       number(5),               /*No Use                                 */
cpg03       varchar2(1),             /*No Use                                 */
cpg04       varchar2(10) NOT NULL,   /*津贴代码                               */
cpg05       varchar2(10),            /*No Use                                 */
cpg06       varchar2(1),             /*No Use                                 */
cpg07       varchar2(1),             /*No Use                                 */
cpg08       number(20,6),            /*津贴金额                               */
                                     /*津贴金额          #modify 030314 NO.A066*/
cpg09       date NOT NULL,           /*生效日期                               */
cpg10       date                     /*失效日期                               */
);

create unique index cpg_pk on cpg_file (cpg01,cpg04,cpg09);
alter table cpg_file add  constraint cpg_pk primary key  (cpg01,cpg04,cpg09) enable validate;
grant select on cpg_file to public;
grant index on cpg_file to public;
grant update on cpg_file to public;
grant delete on cpg_file to public;
grant insert on cpg_file to public;