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