/*
================================================================================
档案代号:fic_file
档案名称:设备类型档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fic_file
(
fic01       varchar2(10) NOT NULL,   /*类型编号                               */
fic02       varchar2(80),            /*名称                                   */
fic03       varchar2(1)              /*铭牌存在否                             */
);

create unique index fic_pk on fic_file (fic01);
alter table fic_file add  constraint fic_pk primary key  (fic01) enable validate;
grant select on fic_file to public;
grant index on fic_file to public;
grant update on fic_file to public;
grant delete on fic_file to public;
grant insert on fic_file to public;