Teams Table

Schema::create('teams', function (Blueprint $table) {
    $table->id();
    $table->string('name');
    $table->text('description')->nullable();
    $table->foreignId('owner_id')->constrained('users')->cascadeOnDelete();
    $table->timestamps();
});

public function owner(): BelongsTo
{
    return $this->belongsTo(User::class, 'owner_id');
}

public function users(): BelongsToMany
{
    return $this->belongsToMany(User::class)
        ->withTimestamps();
}

use App\Models\Team;

$team = Team::create([
    'name' => 'Acme Corporation',
    'description' => 'Our main business team',
    'owner_id' => auth()->id(),
]);

// Get all teams
$teams = Team::all();

// Get teams owned by a user
$ownedTeams = Team::where('owner_id', $userId)->get();

// Get team with members
$team = Team::with('users')->find(1);

// Check if user owns team
$isOwner = $team->owner_id === auth()->id();

$team = Team::find(1);

$team->update([
    'name' => 'New Team Name',
    'description' => 'Updated description',
]);

$team = Team::find(1);
$team->delete(); // Cascades to team_user records

Schema::table('teams', function (Blueprint $table) {
    $table->index('owner_id');
    $table->index('created_at');
});

Schema::table('teams', function (Blueprint $table) {
    $table->string('slug')->unique()->after('name');
});

// In Team model
public function getRouteKeyName()
{
    return 'slug';
}

Schema::table('teams', function (Blueprint $table) {
    $table->json('settings')->nullable();
});

// In Team model
protected $casts = [
    'settings' => 'array',
];

Schema::table('teams', function (Blueprint $table) {
    $table->string('logo_path')->nullable();
});