/*
================================================================================
档案代号:gey_file
档案名称:资料控管维护档案(资料中心)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table gey_file
(
gey01       varchar2(1) DEFAULT '' NOT NULL, /*资料类别*/
gey02       varchar2(10) DEFAULT '' NOT NULL, /*营运中心*/
gey03       varchar2(20) DEFAULT '' NOT NULL, /*栏位代号*/
gey04       varchar2(2),             /*允许新增的条件                         */
gey05       varchar2(255)            /*允许新增值                             */
);

create unique index gey_pk on gey_file (gey01,gey02,gey03);
alter table gey_file add  constraint gey_pk primary key  (gey01,gey02,gey03) enable validate;
grant select on gey_file to public;
grant index on gey_file to public;
grant update on gey_file to public;
grant delete on gey_file to public;
grant insert on gey_file to public;