/* ================================================================================ 档案代号:oef_file 档案名称:订单费用档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oef_file ( oef01 varchar2(16) NOT NULL, /*订单号 */ oef03 number(5) NOT NULL, /*项次 */ /*项次 (0 表示单头备注) */ oef04 varchar2(10) NOT NULL, /*费用代号 */ oef05 number(20,6), /*费用金额 */ /*费用金额 (本币) */ oef06 varchar2(255) /*备注 */ ); create unique index oef_pk on oef_file (oef01,oef03,oef04); alter table oef_file add constraint oef_pk primary key (oef01,oef03,oef04) enable validate; grant select on oef_file to public; grant index on oef_file to public; grant update on oef_file to public; grant delete on oef_file to public; grant insert on oef_file to public; |