create_table "gps_logs", force: :cascade do |t|
    t.integer "merchandiser_id", null: false
    t.string "latitude"
    t.string "longitude"
    t.datetime "gpsStarted"
    t.datetime "gpsStopped"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "merchandisers", force: :cascade do |t|
    t.string "name"
    t.string "email"
    t.string "password_digest"
    t.integer "salesManager_id", null: false
    t.integer "route_plan_id", null: false
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "outlets", force: :cascade do |t|
    t.string "name"
    t.string "latitude"
    t.string "longitude"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "route_plan_details", force: :cascade do |t|
    t.integer "routePlan_id", null: false
    t.integer "merchandiser_id", null: false
    t.integer "outlet_id", null: false
    t.string "date"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "route_plans", force: :cascade do |t|
    t.integer "salesManager_id", null: false
    t.datetime "start_date"
    t.datetime "end_date"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end

  create_table "sales_managers", force: :cascade do |t|
    t.string "name"
    t.string "email"
    t.string "password_digest"
    t.datetime "created_at", null: false
    t.datetime "updated_at", null: false
  end