drop table vendor_orders;
create table vendor_orders (

  order_ref          number,
  customer_id        number,
  scu                number,
  quantity           number,
  order_date         date,

  status             varchar2(80) );

alter table vendor_orders
  add constraint vendor_orders_pk primary key (order_ref, customer_id)
  using index;