/*
================================================================================
档案代号:pjx_file
档案名称:技能单位费用档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table pjx_file
(
pjx01       varchar2(10) NOT NULL,   /*技能代码                               */
pjx02       varchar2(4),             /*单位                                   */
pjx03       number(20,6),            /*单位费用                               */
pjxacti     varchar2(1),             /*资料有效码                             */
pjxdate     date,                    /*最近修改日                             */
pjxgrup     varchar2(10),            /*资料所有部门                           */
pjxmodu     varchar2(10),            /*资料修改者                             */
pjxuser     varchar2(10),            /*资料所有者                             */
pjx04       varchar2(1)              /*直间接                                 */
);

create unique index pjx_pk on pjx_file (pjx01);
alter table pjx_file add  constraint pjx_pk primary key  (pjx01) enable validate;
grant select on pjx_file to public;
grant index on pjx_file to public;
grant update on pjx_file to public;
grant delete on pjx_file to public;
grant insert on pjx_file to public;