Laravel 8中如何将具有不同属性的用户数据存储到单张数据表

Got it, let's work through this problem together. You've got two user types—Seekers and Agents—where Agents need an extra broker license number field, and you're stuck on saving that additional data properly. Here's how to fix this step by step:

You have two solid options depending on your app's future scalability:

Option 1: Single User Table (Simpler for Small Apps) #

Add a nullable broker_license_no field to your existing users table:

1. Generate a migration:

   php artisan make:migration add_broker_license_no_to_users_table --table=users
   

2. Update the migration file:

   public function up()
   {
       Schema::table('users', function (Blueprint $table) {
           $table->string('broker_license_no')->nullable();
       });
   }
   
   public function down()
   {
       Schema::table('users', function (Blueprint $table) {
           $table->dropColumn('broker_license_no');
       });
   }
   

3. Run the migration:

   php artisan migrate
   

Option 2: Separate Agents Table (Better for Scalability) #

If you anticipate adding more Agent-exclusive fields later, split the data into two tables with a one-to-one relationship:

1. Generate a migration for the agents table:

   php artisan make:migration create_agents_table
   

2. Update the migration file:

   public function up()
   {
       Schema::create('agents', function (Blueprint $table) {
           $table->id();
           $table->foreignId('user_id')->constrained()->onDelete('cascade');
           $table->string('broker_license_no');
           $table->timestamps();
       });
   }
   
   public function down()
   {
       Schema::dropIfExists('agents');
   }
   

3. Run the migration, then set up model relationships:
   • In app/Models/User.php:

     public function agent()
     {
         return $this->hasOne(Agent::class);
     }
     

   • Create app/Models/Agent.php:

     namespace App\Models;
     
     use Illuminate\Database\Eloquent\Model;
     use Illuminate\Database\Eloquent\Relations\BelongsTo;
     
     class Agent extends Model
     {
         protected $fillable = ['broker_license_no'];
     
         public function user(): BelongsTo
         {
             return $this->belongsTo(User::class);
         }
     }
     

Adjust your registration logic based on the database structure you chose:

For Option 1 (Single Table) #

Modify your existing create method to include the license number when registering an Agent:

protected function create(array $data)
{
    $roleId = isset($data['agent']) ? 2 : 3;
    
    $userData = [
        'given_name' => $data['given_name'],
        'last_name' => $data['last_name'],
        'email' => $data['email'],
        'password' => Hash::make($data['password']),
        'role_id' => $roleId,
    ];

    // Add license number only if registering as an Agent
    if ($roleId === 2) {
        $userData['broker_license_no'] = $data['broker_license_no'];
    }

    // Don't forget to add `broker_license_no` to your User model's $fillable!
    return User::create($userData);
}

Critical note: Update your User model's $fillable array to include the new field:

// app/Models/User.php
protected $fillable = [
    'given_name',
    'last_name',
    'email',
    'password',
    'role_id',
    'broker_license_no', // Add this line
];

For Option 2 (Separate Agents Table) #

First create the User record, then create a linked Agent record if needed:

protected function create(array $data)
{
    $roleId = isset($data['agent']) ? 2 : 3;

    // Create the base user record
    $user = User::create([
        'given_name' => $data['given_name'],
        'last_name' => $data['last_name'],
        'email' => $data['email'],
        'password' => Hash::make($data['password']),
        'role_id' => $roleId,
    ]);

    // Create linked Agent record if registering as an Agent
    if ($roleId === 2) {
        $user->agent()->create([
            'broker_license_no' => $data['broker_license_no'],
        ]);
    }

    return $user;
}

Make sure the broker license number is required only when the user selects to register as an Agent. If you're using a form request class (like app/Http/Requests/Auth/RegisterRequest.php), update the rules() method:

public function rules()
{
    $baseRules = [
        'given_name' => ['required', 'string', 'max:255'],
        'last_name' => ['required', 'string', 'max:255'],
        'email' => ['required', 'string', 'email', 'max:255', 'unique:users'],
        'password' => ['required', 'string', 'min:8', 'confirmed'],
    ];

    // Require license number only for Agent registrations
    if ($this->has('agent')) {
        $baseRules['broker_license_no'] = ['required', 'string', 'max:255'];
    }

    return $baseRules;
}

If you're validating directly in the controller, use this instead:

$this->validate($request, [
    'given_name' => 'required|string|max:255',
    'last_name' => 'required|string|max:255',
    'email' => 'required|string|email|max:255|unique:users',
    'password' => 'required|string|min:8|confirmed',
    'broker_license_no' => $request->has('agent') ? 'required|string|max:255' : 'nullable',
]);

That's it! Now when a user registers as an Agent, their license number will be saved correctly, while Seekers skip that field entirely.

内容的提问来源于stack exchange，提问作者Inquisitive