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