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