/*
================================================================================
档案代号:for_file
档案名称:仪器校验记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table for_file
(
for01       varchar2(10) NOT NULL,   /*校验编号                               */
for02       number(5) NOT NULL,      /*项次                                   */
for03       varchar2(6) NOT NULL,    /*校订项目                               */
for04       varchar2(255)            /*检验结果                               */
);

create unique index for_pk on for_file (for01,for02,for03);
alter table for_file add  constraint for_pk primary key  (for01,for02,for03) enable validate;
grant select on for_file to public;
grant index on for_file to public;
grant update on for_file to public;
grant delete on for_file to public;
grant insert on for_file to public;