/*
================================================================================
档案代号:zay_file
档案名称:自定义资料转换设定档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zay_file
(
zay01       varchar2(80) NOT NULL,   /*查询单id                               */
zay02       number(5) NOT NULL,      /*序号                                   */
zay03       varchar2(1) NOT NULL,    /*客制否                                 */
zay04       varchar2(1),             /*转换项目                               */
zay05       varchar2(80) NOT NULL,   /*原转换值                               */
zay06       varchar2(1),             /*取代型态                               */
zay07       varchar2(80)             /*取代值                                 */
);

create unique index zay_pk on zay_file (zay01,zay02,zay03,zay05);
alter table zay_file add  constraint zay_pk primary key  (zay01,zay02,zay03,zay05) enable validate;
grant select on zay_file to public;
grant index on zay_file to public;
grant update on zay_file to public;
grant delete on zay_file to public;
grant insert on zay_file to public;