/*
================================================================================
档案代号:fiu_file
档案名称:设备保养周期档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fiu_file
(
fiu01       varchar2(2) NOT NULL,    /*保养周期编号                           */
fiu02       varchar2(80),            /*说明                                   */
fiuacti     varchar2(1),             /*资料有效码                             */
fiuuser     varchar2(10),            /*资料所有者                             */
fiugrup     varchar2(10),            /*资料所有部门                           */
fiumodu     varchar2(10),            /*最后修改人员                           */
fiudate     date                     /*最后修改日期                           */
);

create unique index fiu_pk on fiu_file (fiu01);
alter table fiu_file add  constraint fiu_pk primary key  (fiu01) enable validate;
grant select on fiu_file to public;
grant index on fiu_file to public;
grant update on fiu_file to public;
grant delete on fiu_file to public;
grant insert on fiu_file to public;