Advertisement
Guest User

Untitled

a guest
Feb 20th, 2019
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.08 KB | None | 0 0
  1. $table->string('document_no')->index();
  2. $table->string('order_no')->index()->nullable();
  3. $table->string('currency_code')->index()->default('SEK');
  4. $table->string('payment_method')->index()->nullable();
  5. $table->string('shipment_method')->index()->nullable();
  6. $table->string('customer_no')->index()->nullable();
  7. $table->string('customer_name')->index()->nullable();
  8. $table->string('zip_code')->index()->nullable();
  9. $table->string('city')->index()->nullable();
  10. $table->integer('total_sales')->index()->nullable();
  11. $table->integer('total_cost')->index()->nullable();
  12. $table->integer('total_profit')->index()->nullable();
  13. $table->integer('total_margin')->index()->nullable();
  14. $table->string('included_brands')->nullable()->index();
  15. $table->string('included_categories')->nullable()->index();
  16. $table->string('included_skus')->nullable()->index();
  17. $table->date('date')->index();
  18.  
  19. //Lines
  20. $table->string('sales_channel')->nullable()->index();
  21. $table->integer('qty')->index()->default(0);
  22. $table->integer('line_sales_amount')->index();
  23. $table->integer('line_cost_amount')->index();
  24. $table->integer('profit')->index();
  25. $table->integer('margin')->index();
  26.  
  27. //Products
  28. $table->string('parent_sku')->index()->nullable();
  29. $table->string('main_category')->index()->nullable();
  30. $table->string('brand')->index()->nullable();
  31. $table->string('wheel_size')->nullable()->index();
  32. $table->string('frame_type')->nullable()->index();
  33. $table->string('edrive_motor')->nullable()->index();
  34. $table->string('edrive_motor_placement')->nullable()->index();
  35. $table->string('edrive_brand')->nullable()->index();
  36. $table->string('travel_front')->nullable()->index();
  37. $table->string('e_bike')->nullable()->index();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement