/*
================================================================================
档案代号:zzd_file
档案名称:制造业管理辞典
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zzd_file
(
zzd01       varchar2(40) NOT NULL,   /*英文                                   */
zzd02       varchar2(40),            /*中文                                   */
zzdacti     varchar2(1)              /*有效否                                 */
);

create unique index zzd_pk on zzd_file (zzd01);
alter table zzd_file add  constraint zzd_pk primary key  (zzd01) enable validate;
grant select on zzd_file to public;
grant index on zzd_file to public;
grant update on zzd_file to public;
grant delete on zzd_file to public;
grant insert on zzd_file to public;