Schema builder (columns, types) in Laravel - Step-by-Step Execution

Concept Flow - Schema builder (columns, types)

Start Migration

↓

Create Schema Builder Instance

↓

Define Table Name

↓

Add Columns with Types

↓

Set Column Options (nullable, default, etc.)

↓

Run Migration to Create Table

↓

Table Created in Database

This flow shows how Laravel's schema builder creates a table by defining columns and their types step-by-step.

Execution Sample

Laravel

Schema::create('users', function (Blueprint $table) {
  $table->id();
  $table->string('name');
  $table->integer('age')->nullable();
  $table->timestamps();
});

This code creates a 'users' table with an id, a name column, an optional age column, and timestamp columns.

Execution Table

Step	Action	Column Added	Type	Options
1	Start Schema::create	None	None	None
2	$table->id()	id	bigint (auto-increment)	Primary key
3	$table->string('name')	name	string (varchar)	Required
4	$table->integer('age')->nullable()	age	integer	Nullable
5	$table->timestamps()	created_at, updated_at	timestamp	Nullable, default NULL
6	End Schema::create	Table 'users' created	N/A	N/A

💡 All columns defined and table created in database

Variable Tracker

Variable	Start	After Step 2	After Step 3	After Step 4	After Step 5	Final
columns	[]	[id]	[id, name]	[id, name, age]	[id, name, age, created_at, updated_at]	[id, name, age, created_at, updated_at]

Key Moments - 2 Insights

Why does $table->integer('age')->nullable() allow null values?

Because the nullable() method sets the column to accept NULL, as shown in step 4 of the execution_table where 'age' column options include Nullable.

What does $table->timestamps() add to the table?

It adds two timestamp columns: created_at and updated_at, which are nullable by default, as shown in step 5 of the execution_table.

Visual Quiz - 3 Questions

Look at the execution table, what type is assigned to the 'id' column at step 2?

A integer

B string

C bigint (auto-increment)

D timestamp

💡 Hint

Check the 'Type' column in row for step 2 in execution_table

At which step are the timestamp columns created?

A Step 3

B Step 5

C Step 4

D Step 6

💡 Hint

Look for $table->timestamps() action in execution_table

If we remove ->nullable() from the 'age' column, what changes in the options column at step 4?

A Options will be empty (not nullable)

B Options will include Nullable

C Type changes to string

D Column is removed

💡 Hint

Compare options for 'age' column in step 4 with and without nullable() in execution_table

Concept Snapshot

Laravel Schema Builder:
- Use Schema::create('table', fn(Blueprint $table) => {...})
- Add columns: $table->string('name'), $table->integer('age')->nullable()
- Common types: id(), string(), integer(), timestamps()
- Use nullable() to allow NULL values
- Run migration to create table in DB

Full Transcript

This visual execution shows how Laravel's schema builder creates a database table step-by-step. First, the migration starts and Schema::create is called with the table name 'users'. Then columns are added one by one: an auto-incrementing id, a required string 'name', an integer 'age' that can be null, and timestamp columns for created_at and updated_at. Each step updates the columns list. Nullable columns allow empty values. The timestamps method adds two timestamp columns. Finally, the table is created in the database with all defined columns.