/* ================================================================================ 档案代号:oeo_file 档案名称:订单产品的选择配件(Options)/备品档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oeo_file ( oeo01 varchar2(16) NOT NULL, /*订单单号 */ oeo03 number(5) NOT NULL, /*项次 */ oeo04 varchar2(40) NOT NULL, /*选择配件料号 */ oeo05 varchar2(4), /*发料单位 */ oeo06 number(20,8) NOT NULL, /*QPA */ /*QPA #No:6102 */ oeo07 varchar2(1), /*必需否 */ /*必需否 (0.必需件 1.选择配件) */ oeo08 varchar2(1), /*属性 */ /*属性 1.选配件 2.备品 #by payton */ oeo09 number(15,3) /*数量 */ /*数量 #by payton */ ); create unique index oeo_pk on oeo_file (oeo01,oeo03,oeo04); alter table oeo_file add constraint oeo_pk primary key (oeo01,oeo03,oeo04) enable validate; grant select on oeo_file to public; grant index on oeo_file to public; grant update on oeo_file to public; grant delete on oeo_file to public; grant insert on oeo_file to public; |