/*
================================================================================
档案代号:oad_file
档案名称:单位运费档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oad_file
(
oad01       varchar2(10) NOT NULL,   /*起运地点                               */
oad02       varchar2(10) NOT NULL,   /*到达地点                               */
oad041      number(20,6) NOT NULL,   /*第一类每公斤单位运费                   */
oad042      number(20,6) NOT NULL,   /*第二类每公斤单位运费                   */
oad043      number(20,6) NOT NULL,   /*第三类每公斤单位运费                   */
oad051      number(20,6) NOT NULL,   /*第一类每公斤单位运费(退货)             */
oad052      number(20,6) NOT NULL,   /*第二类每公斤单位运费                   */
                                     /*第二类每公斤单位运费(退货)             */
oad053      number(20,6) NOT NULL    /*第三类每公斤单位运费                   */
                                     /*第三类每公斤单位运费(退货)             */
);

create unique index oad_pk on oad_file (oad01,oad02);
alter table oad_file add  constraint oad_pk primary key  (oad01,oad02) enable validate;
grant select on oad_file to public;
grant index on oad_file to public;
grant update on oad_file to public;
grant delete on oad_file to public;
grant insert on oad_file to public;