/*
================================================================================
档案代号:zd_file
档案名称:日报表资料(daily report)
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table zd_file
(
zd01        date NOT NULL,           /*日期                                   */
zd02        varchar2(10) NOT NULL,   /*使用者代号                             */
zd03        number(5) NOT NULL,      /*异动序号                               */
zd10        varchar2(3),             /*异动代号                               */
zd11        number(15,3),            /*异动时间                               */
zd12        varchar2(255),           /*备注                                   */
zdgrup      varchar2(10)             /*Group                                  */
);

create unique index zd_pk on zd_file (zd01,zd02,zd03);
alter table zd_file add  constraint zd_pk primary key  (zd01,zd02,zd03) enable validate;
grant select on zd_file to public;
grant index on zd_file to public;
grant update on zd_file to public;
grant delete on zd_file to public;
grant insert on zd_file to public;