/* ================================================================================ 档案代号:ogbb_file 档案名称:出货单序号档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ogbb_file ( ogbb01 varchar2(16) NOT NULL, /*出货单号 */ ogbb012 number(5) NOT NULL, /*项次 */ ogbb02 varchar2(15) NOT NULL /*序号 */ ); create unique index ogbb_pk on ogbb_file (ogbb01,ogbb012,ogbb02); alter table ogbb_file add constraint ogbb_pk primary key (ogbb01,ogbb012,ogbb02) enable validate; grant select on ogbb_file to public; grant index on ogbb_file to public; grant update on ogbb_file to public; grant delete on ogbb_file to public; grant insert on ogbb_file to public; |