Migrations and Job Portal Schema

What is a Laravel migration?

php artisan make:migration create_products_table

Schema::create('products', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->decimal('price', 10, 2);
    $table->timestamps();
});

php artisan migrate
php artisan migrate:rollback
php artisan migrate:refresh
php artisan migrate:fresh

rollback undoes the latest migration batch. refresh rolls back every migration and runs them again. fresh drops all tables and migrates from scratch.

What do up() and down() do?

• Define the concept in one or two sentences.
• Give a small example and trace what happens.
• Explain one limitation, trade-off, or common mistake.

How do foreign keys and indexes work?

• Define the concept in one or two sentences.
• Give a small example and trace what happens.
• Explain one limitation, trade-off, or common mistake.

How would you model companies, jobs and applications?

• Define the concept in one or two sentences.
• Give a small example and trace what happens.
• Explain one limitation, trade-off, or common mistake.

How do you create a safe production schema change?

• Define the concept in one or two sentences.
• Give a small example and trace what happens.
• Explain one limitation, trade-off, or common mistake.

How do unique constraints prevent duplicate jobs?

• Define the concept in one or two sentences.
• Give a small example and trace what happens.
• Explain one limitation, trade-off, or common mistake.

How do you roll back a migration?

php artisan make:migration create_products_table

Schema::create('products', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->decimal('price', 10, 2);
    $table->timestamps();
});

php artisan migrate
php artisan migrate:rollback
php artisan migrate:refresh
php artisan migrate:fresh

rollback undoes the latest migration batch. refresh rolls back every migration and runs them again. fresh drops all tables and migrates from scratch.