/* ================================================================================ 档案代号:azo_file 档案名称:系统重要资料修改记录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table azo_file ( azo01 varchar2(20), /*程式编号 */ /*程式编号 (program code) */ azo02 varchar2(10), /*异动人员 */ azo03 date, /*异动日期 */ azo04 varchar2(10), /*异动时间 */ azo05 varchar2(18), /*异动资料的 KEY VALUE */ azo06 varchar2(80) /*异动说明 */ ); create index azo_01 on azo_file (azo01,azo02); create index azo_02 on azo_file (azo04); grant select on azo_file to public; grant index on azo_file to public; grant update on azo_file to public; grant delete on azo_file to public; grant insert on azo_file to public; |