/*
================================================================================
档案代号:zxv_file
档案名称:员工执行动作资料档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zxv_file
(
zxv01       varchar2(10) NOT NULL,   /*使用者代号                             */
                                     /*使用者代号,(Login user name)           */
zxv02       varchar2(32) NOT NULL,   /*使用者tty                              */
zxv03       date,                    /*日期                                   */
zxv04       date,                    /*时间                                   */
                                     /*ORA版须手工将型态改为char(8)           */
zxv05       varchar2(10)             /*执行动作                               */
);

create unique index zxv_pk on zxv_file (zxv01,zxv02);
alter table zxv_file add  constraint zxv_pk primary key  (zxv01,zxv02) enable validate;
grant select on zxv_file to public;
grant index on zxv_file to public;
grant update on zxv_file to public;
grant delete on zxv_file to public;
grant insert on zxv_file to public;