/* ================================================================================ 档案代号:ogf_file 档案名称:多角贸易出货单抛转对应单号 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ogf_file ( ogf00 varchar2(10), /*来源营运中心编号 */ ogf01 varchar2(16) NOT NULL, /*来源出货单号 */ ogf02 varchar2(10), /*目的营运中心编号 */ ogf03 varchar2(16) /*目的出货单号 */ ); create unique index ogf_pk on ogf_file (ogf01); alter table ogf_file add constraint ogf_pk primary key (ogf01) enable validate; grant select on ogf_file to public; grant index on ogf_file to public; grant update on ogf_file to public; grant delete on ogf_file to public; grant insert on ogf_file to public; |