Laravel cizí klíč
Schema::table('posts', function (Blueprint $table) {
$table->unsignedBigInteger('user_id');
$table->foreign('user_id')->references('id')->on('users');
});
OR
Schema::table('posts', function (Blueprint $table) {
$table->foreignId('user_id')->constrained();
});
laravel migrace
php artisan make:migration create_users_table --create=users
php artisan make:migration add_votes_to_users_table --table=users
laravel dělá migraci
php artisan make:migration CreateUsersTable
laravelův migrační index
$table->index(['account_id', 'created_at']);