/* ================================================================================ 档案代号:wsl_file 档案名称:EasyFlow 整合自动确认功能 log 档 档案目的:纪录单据程式执行确认过程中错误发生讯息, 供整合程式判断是否正确执行 上游档案: 下游档案: ============.========================.========================================== */ create table wsl_file ( wsl01 varchar2(20) NOT NULL, /*fglappserver/fglserver 的值 */ wsl02 varchar2(10) NOT NULL, /*使用者代号 */ wsl03 varchar2(20) NOT NULL, /*程式代号 */ wsl04 varchar2(7), /*错误讯息代号 */ wsl05 varchar2(255) /*错误讯息内容 */ ); create unique index wsl_pk on wsl_file (wsl01,wsl02,wsl03); alter table wsl_file add constraint wsl_pk primary key (wsl01,wsl02,wsl03) enable validate; grant select on wsl_file to public; grant index on wsl_file to public; grant update on wsl_file to public; grant delete on wsl_file to public; grant insert on wsl_file to public; |