/*
================================================================================
档案代号:fie_file
档案名称:作业资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fie_file
(
fie01       varchar2(10) NOT NULL,   /*作业编号                               */
fie02       number(5) NOT NULL,      /*步骤                                   */
fie03       varchar2(80)             /*内容                                   */
);

create unique index fie_pk on fie_file (fie01,fie02);
alter table fie_file add  constraint fie_pk primary key  (fie01,fie02) enable validate;
grant select on fie_file to public;
grant index on fie_file to public;
grant update on fie_file to public;
grant delete on fie_file to public;
grant insert on fie_file to public;