/* ================================================================================ 档案代号:fib_file 档案名称:设备附件资料档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fib_file ( fib01 varchar2(20) NOT NULL, /*设备编号 */ fib02 number(5) NOT NULL, /*项次 */ fib03 varchar2(70) /*文件路径档名 */ ); create unique index fib_pk on fib_file (fib01,fib02); alter table fib_file add constraint fib_pk primary key (fib01,fib02) enable validate; grant select on fib_file to public; grant index on fib_file to public; grant update on fib_file to public; grant delete on fib_file to public; grant insert on fib_file to public; |