/*
================================================================================
档案代号:fgc_file
档案名称:量测仪器校验记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fgc_file
(
fgc01       varchar2(15) NOT NULL,   /*仪器编号                               */
fgc011      number(5) NOT NULL,      /*项次                                   */
                                     /*项次'0' 为第一笔                       */
fgc02       date,                    /*校验日期                               */
fgc03       varchar2(10),            /*校验编号                               */
fgc04       varchar2(10),            /*校验人员                               */
fgc05       varchar2(4),             /*校验不良原因                           */
fgc06       varchar2(1),             /*校验结果                               */
fgc07       date                     /*下次校验日                             */
);

create unique index fgc_pk on fgc_file (fgc01,fgc011);
alter table fgc_file add  constraint fgc_pk primary key  (fgc01,fgc011) enable validate;
grant select on fgc_file to public;
grant index on fgc_file to public;
grant update on fgc_file to public;
grant delete on fgc_file to public;
grant insert on fgc_file to public;