/*
================================================================================
档案代号:adb_file
档案名称:集团组织单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table adb_file
(
adb01       varchar2(10) NOT NULL,   /*上层公司编号                           */
adb02       varchar2(10) NOT NULL,   /*下层公司编号                           */
adb03       date,                    /*生效日期                               */
adb04       date,                    /*失效日期                               */
adb05       varchar2(1),             /*转拨计价方式                           */
adb06       number(9,4)              /*转拨百分比                             */
);

create        index adb_02 on adb_file (adb02);
create unique index adb_pk on adb_file (adb01,adb02);
alter table adb_file add  constraint adb_pk primary key  (adb01,adb02) enable validate;
grant select on adb_file to public;
grant index on adb_file to public;
grant update on adb_file to public;
grant delete on adb_file to public;
grant insert on adb_file to public;