/*
================================================================================
档案代号:fik_file
档案名称:设备停机记录档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fik_file
(
fik01       varchar2(20) NOT NULL,   /*设备编号                               */
fik02       date NOT NULL,           /*停机日期                               */
fik03       varchar2(5) NOT NULL,    /*停机时间                               */
fik04       date,                    /*开机日期                               */
fik05       varchar2(5),             /*开机时间                               */
fik06       varchar2(255),           /*备注                                   */
fikuser     varchar2(10),            /*资料所有者                             */
fikgrup     varchar2(10),            /*资料所有部门                           */
fikmodu     varchar2(10),            /*资料修改者                             */
fikdate     date                     /*最近修改日                             */
);

create unique index fik_pk on fik_file (fik01,fik02,fik03);
alter table fik_file add  constraint fik_pk primary key  (fik01,fik02,fik03) enable validate;
grant select on fik_file to public;
grant index on fik_file to public;
grant update on fik_file to public;
grant delete on fik_file to public;
grant insert on fik_file to public;