/* ================================================================================ 档案代号:wcd_file 档案名称:spc 整合设定档(基本资料栏位设定) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table wcd_file ( wcd01 varchar2(15) NOT NULL, /*档案代码 */ wcd02 varchar2(20) NOT NULL, /*栏位名称 */ wcd03 varchar2(1), /*No Use */ wcd04 varchar2(1), /*No Use */ wcd05 varchar2(1), /*No Use */ wcd06 varchar2(1), /*No Use */ wcd07 varchar2(1) /*No Use */ ); create unique index wcd_pk on wcd_file (wcd01,wcd02); alter table wcd_file add constraint wcd_pk primary key (wcd01,wcd02) enable validate; grant select on wcd_file to public; grant index on wcd_file to public; grant update on wcd_file to public; grant delete on wcd_file to public; grant insert on wcd_file to public; |