/* ================================================================================ 档案代号: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; |