/* ================================================================================ 档案代号: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; |