/* ================================================================================ 档案代号:gce_file 档案名称:资料上传下载条件式维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gce_file ( gce01 varchar2(10) NOT NULL, /*格式代码 */ gce02 number(5) NOT NULL, /*序号 */ gce03 varchar2(30) NOT NULL, /*栏位代码 */ gce04 varchar2(255) /*运算式 */ ); create unique index gce_pk on gce_file (gce01,gce02,gce03); alter table gce_file add constraint gce_pk primary key (gce01,gce02,gce03) enable validate; grant select on gce_file to public; grant index on gce_file to public; grant update on gce_file to public; grant delete on gce_file to public; grant insert on gce_file to public; |