/* ================================================================================ 档案代号:ogbi_file 档案名称:出货单单身档(行业别档) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ogbi_file ( ogbi01 varchar2(16) DEFAULT '' NOT NULL, /*出货单号*/ ogbi03 number(5) DEFAULT '0' NOT NULL, /*项次*/ ogbiicd01 varchar2(1), /*转仓 */ ogbiicd02 number(9,4), /*备品比率 */ ogbiicd03 varchar2(1), /*型态 */ /*0:一般 ; 1:样品 ; 2:Spare Part */ ogbiicd04 varchar2(20) /*Tape Reel */ ); create unique index ogbi_pk on ogbi_file (ogbi01,ogbi03); alter table ogbi_file add constraint ogbi_pk primary key (ogbi01,ogbi03) enable validate; grant select on ogbi_file to public; grant index on ogbi_file to public; grant update on ogbi_file to public; grant delete on ogbi_file to public; grant insert on ogbi_file to public; |