/*
================================================================================
档案代号:zte_file
档案名称:档案名称单身档其他设定
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zte_file
(
zte01       varchar2(20) NOT NULL,   /*档案编号                               */
zte02       varchar2(20) NOT NULL,   /*资料库名称                             */
zte03       varchar2(30) NOT NULL,   /*栏位代码                               */
zte04       varchar2(1),             /*属性                                   */
zte05       varchar2(1),             /*记录预设值设定方式                     */
zte06       varchar2(255)            /*记录预设值或程式代码                   */
);

create unique index zte_pk on zte_file (zte01,zte02,zte03);
alter table zte_file add  constraint zte_pk primary key  (zte01,zte02,zte03) enable validate;
grant select on zte_file to public;
grant index on zte_file to public;
grant update on zte_file to public;
grant delete on zte_file to public;
grant insert on zte_file to public;