/*
================================================================================
档案代号:fiz_file
档案名称:备件类型档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fiz_file
(
fiz01       varchar2(4) NOT NULL,    /*备件类型编号                           */
fiz02       varchar2(80)             /*说明                                   */
);

create unique index fiz_pk on fiz_file (fiz01);
alter table fiz_file add  constraint fiz_pk primary key  (fiz01) enable validate;
grant select on fiz_file to public;
grant index on fiz_file to public;
grant update on fiz_file to public;
grant delete on fiz_file to public;
grant insert on fiz_file to public;