/* ================================================================================ 档案代号:wsq_file 档案名称:EasyFlow 整合设定档(备注档设定) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table wsq_file ( wsq01 varchar2(20) NOT NULL, /*程式代号 */ wsq02 varchar2(20) NOT NULL, /*程式使用备注档 */ wsq03 varchar2(20) NOT NULL, /*备注档 key 值栏位 #1 */ wsq04 varchar2(20), /*备注档 key 值栏位 #2 */ wsq05 varchar2(20), /*备注档 key 值栏位 #3 */ wsq06 varchar2(20), /*备注档 key 值栏位 #4 */ wsq07 varchar2(20) /*备注档 key 值栏位 #5 */ ); create unique index wsq_pk on wsq_file (wsq01); alter table wsq_file add constraint wsq_pk primary key (wsq01) enable validate; grant select on wsq_file to public; grant index on wsq_file to public; grant update on wsq_file to public; grant delete on wsq_file to public; grant insert on wsq_file to public; |