/* ================================================================================ 档案代号: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; |