/*
================================================================================
档案代号:gez_file
档案名称:抛转预设资料维护(资料中心)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gez_file
(
gez01       varchar2(10) DEFAULT '' NOT NULL, /*资料中心代码*/
gez02       varchar2(1) DEFAULT '' NOT NULL, /*资料类别*/
gez03       varchar2(10) DEFAULT '' NOT NULL, /*抛转营运中心*/
gez04       varchar2(20) DEFAULT '' NOT NULL, /*栏位代号*/
gez05       varchar2(255)            /*抛转栏位值                             */
);

create unique index gez_pk on gez_file (gez01,gez02,gez03,gez04);
alter table gez_file add  constraint gez_pk primary key  (gez01,gez02,gez03,gez04) enable validate;
grant select on gez_file to public;
grant index on gez_file to public;
grant update on gez_file to public;
grant delete on gez_file to public;
grant insert on gez_file to public;