/* ================================================================================ 档案代号:wcc_file 档案名称:spc 整合设定档(表单整合栏位设定) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table wcc_file ( wcc01 varchar2(20) NOT NULL, /*程式代号 */ wcc02 varchar2(20) NOT NULL, /*栏位名称 */ wcc03 varchar2(1), /*更新否 */ wcc04 varchar2(1), /*No Use */ wcc05 varchar2(1), /*No Use */ wcc06 varchar2(1), /*No Use */ wcc07 varchar2(1) /*No Use */ ); create unique index wcc_pk on wcc_file (wcc01,wcc02); alter table wcc_file add constraint wcc_pk primary key (wcc01,wcc02) enable validate; grant select on wcc_file to public; grant index on wcc_file to public; grant update on wcc_file to public; grant delete on wcc_file to public; grant insert on wcc_file to public; |