/*
================================================================================
档案代号:fgb_file
档案名称:量测仪器校定项目维护作业
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fgb_file
(
fgb01       varchar2(15) NOT NULL,   /*仪器编号                               */
fgb02       number(5) NOT NULL,      /*项次                                   */
fgb03       varchar2(6),             /*校定项目                               */
fgb04       varchar2(255),           /*备注                                   */
fgbacti     varchar2(1),             /*资料有效码                             */
fgbuser     varchar2(10),            /*资料所有者                             */
fgbgrup     varchar2(10),            /*资料所有群                             */
fgbmodu     varchar2(10),            /*资料更改者                             */
fgbdate     date                     /*最近修改日                             */
);

create unique index fgb_pk on fgb_file (fgb01,fgb02);
alter table fgb_file add  constraint fgb_pk primary key  (fgb01,fgb02) enable validate;
grant select on fgb_file to public;
grant index on fgb_file to public;
grant update on fgb_file to public;
grant delete on fgb_file to public;
grant insert on fgb_file to public;