Laravel generate sub table script example

Ideas ：
The single table record is too large, and the query efficiency is low , Consider dividing the table into months , Annual table to save data .

Create table script ： （ The following is just an example , Adjust according to actual needs ）

<?php

namespace App\Console\Commands\Table;

use Illuminate\Console\Command;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class TableCopy extends Command
{
    
    protected $signature = 'cron:table-copy {table?}';

    protected $table_date_format = 'Y';

    public function handle()
    {
    
        $table_base = $this->argument('table') ?: 'promotion_water';
        try {
    
            switch($table_base) {
    
                case 'promotion_water':
                    $table_name = $table_base.'_'.date($this->table_date_format);
                    $rt = $this->check_promotion_running_water_table($table_name);
// $rt && $this->info('created table success! table:'.$table_name);
                    $rt && logger('created table success! table:'.$table_name);
                    break ;
                default:
                    break ;
            }
        } catch (\Exception $e) {
    
            logger('TableCreate.error',['table_base'=> $table_base,$e->getMessage()]);
        }
    }

    public function check_promotion_running_water_table($table_name)
    {
    
        if(!Schema::hasTable($table_name)) {
    
            Schema::create($table_name, function (Blueprint $table) {
    
                $table->increments('id');
                $table->string('serial_number')->index()->comment(' Serial number ');
                $table->string('seller_id')->index()->comment(' Channel number ');
                $table->string('userno')->index()->comment(' Promoters ID');
                $table->string('cardId')->index()->comment(' card ID');
                $table->string('proCode')->index()->comment(' Source code ');
                $table->string('link')->index()->comment(' Landing page links ');
                $table->string('from')->index()->comment(' source ');
                $table->string('ip')->index()->comment('IP');
                $table->datetime('time')->index()->comment('');
                $table->timestamps();
            });
            if(Schema::hasTable($table_name)) {
    
                return true;
            }
        }
        return false;
    }
}

Timing task configuration

 //app/Console/Kernel.php
 $schedule->command('cron:table-copy')->dailyAt('00:00')->runInBackground();