/*
================================================================================
档案代号:log_file
档案名称:Trigger Log 资料明细档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table log_file
(
tab         varchar2(8),             /*档案编号                               */
key1        varchar2(20),            /*资料编号一                             */
key2        varchar2(20),            /*资料编号二                             */
key3        varchar2(20),            /*资料编号三                             */
key4        varchar2(20),            /*资料编号四                             */
key5        varchar2(20),            /*No Use                                 */
col         varchar2(8),             /*栏位                                   */
ldate       date,                    /*异动日期                               */
luser       varchar2(6),             /*异动人员                               */
ltype       varchar2(3),             /*类别                                   */
old_val     varchar2(20),            /*修改前资料                             */
new_val     varchar2(20)             /*修改后资料                             */
);

create        index log_01 on log_file (key1);
create        index log_02 on log_file (col);
create        index log_03 on log_file (ldate);
grant select on log_file to public;
grant index on log_file to public;
grant update on log_file to public;
grant delete on log_file to public;
grant insert on log_file to public;