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