/*
================================================================================
档案代号:dff_file
档案名称:资料库比对结果档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table dff_file
(
dff01       varchar2(10),            /*版本代号                               */
dff02       number(5),               /*差异类别                               */
                                     /*1:table not found in target            */
                                     /*2:table not found in source            */
                                     /*3:field not found in target            */
                                     /*4:field not found in source            */
                                     /*5:field data type not match            */
                                     /*6:field data length not match          */
dff03       varchar2(20),            /*source db name                         */
                                     /*source db name ==>  如ds               */
dff04       varchar2(20),            /*target db name                         */
                                     /*target db name ==>  如ds3              */
dff05       varchar2(18),            /*table name in source db                */
                                     /*table name in source db ==>  如aoo_file*/
dff06       varchar2(18),            /*table name in target db                */
                                     /*table name in target db ==>  如azz_file*/
dff07       varchar2(18),            /*field name in source db                */
                                     /*field name in source db ==>  如oma11   */
dff08       varchar2(18),            /*field name in target db                */
                                     /*field name in target db ==>  如oga20   */
dff09       varchar2(20),            /*different data type in source db       */
dff10       varchar2(20),            /*different data type in target db       */
dff11       varchar2(10),            /*different data length in source db     */
dff12       varchar2(10),            /*different data length in target db     */
dff13       varchar2(18),            /*next field name in source              */
dff14       varchar2(18),            /*next filed name in target              */
dff15       date                     /*比对日期                               */
);

grant select on dff_file to public;
grant index on dff_file to public;
grant update on dff_file to public;
grant delete on dff_file to public;
grant insert on dff_file to public;