/* ================================================================================ 档案代号:oebi_file 档案名称:订单单身档(行业别档) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oebi_file ( oebi01 varchar2(16) DEFAULT '' NOT NULL, /*订单单号*/ oebi03 number(5) DEFAULT '0' NOT NULL, /*项次*/ oebiicd01 varchar2(40), /*内编母体料号 */ oebiicd02 varchar2(10), /*业务员 */ oebiicd03 number(9,4), /*备品比率 */ oebiicd04 varchar2(1), /*样品否 */ oebiicd05 varchar2(1), /*Multi Die */ oebiicd06 number(15,3), /*已转片数 */ oebiicd07 varchar2(10), /*End User */ oebiicd08 varchar2(1), /*已转完采购单否 */ oebiicd09 varchar2(10), /*单身送货地址码 */ oebislk01 varchar2(16) /*制单号 */ ); create unique index oebi_pk on oebi_file (oebi01,oebi03); alter table oebi_file add constraint oebi_pk primary key (oebi01,oebi03) enable validate; grant select on oebi_file to public; grant index on oebi_file to public; grant update on oebi_file to public; grant delete on oebi_file to public; grant insert on oebi_file to public; |