/*
================================================================================
档案代号:zc_file
档案名称:工作代码档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zc_file
(
zc01        varchar2(3) NOT NULL,    /*异动代号                               */
zc02        varchar2(10)             /*工作说明                               */
);

create unique index zc_pk on zc_file (zc01);
alter table zc_file add  constraint zc_pk primary key  (zc01) enable validate;
grant select on zc_file to public;
grant index on zc_file to public;
grant update on zc_file to public;
grant delete on zc_file to public;
grant insert on zc_file to public;