/*
================================================================================
档案代号:dpj_file
档案名称:在/离职证明用途代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table dpj_file
(
dpj01       varchar2(4) NOT NULL,    /*用途代号                               */
dpj02       varchar2(80),            /*用途说明                               */
dpjacti     varchar2(1),             /*资料有效码                             */
dpjuser     varchar2(10),            /*原始资料建立者                         */
dpjgrup     varchar2(10),            /*使用者部门                             */
dpjmodu     varchar2(10),            /*最后修改资料者                         */
dpjdate     date                     /*最后修改日期                           */
);

create unique index dpj_pk on dpj_file (dpj01);
alter table dpj_file add  constraint dpj_pk primary key  (dpj01) enable validate;
grant select on dpj_file to public;
grant index on dpj_file to public;
grant update on dpj_file to public;
grant delete on dpj_file to public;
grant insert on dpj_file to public;