/*
================================================================================
档案代号:fih_file
档案名称:设备仪表资料单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fih_file
(
fih01       varchar2(20) NOT NULL,   /*设备编号                               */
fih02       varchar2(10) NOT NULL,   /*仪表编号                               */
fih03       date NOT NULL,           /*日期                                   */
fih04       varchar2(6) NOT NULL,    /*时间                                   */
fih05       number(15,3)             /*数值                                   */
);

create unique index fih_pk on fih_file (fih01,fih02,fih03,fih04);
alter table fih_file add  constraint fih_pk primary key  (fih01,fih02,fih03,fih04) enable validate;
grant select on fih_file to public;
grant index on fih_file to public;
grant update on fih_file to public;
grant delete on fih_file to public;
grant insert on fih_file to public;