Schema::create('users', function (Blueprint $table) {
$table->id();
$table->string('name');
$table->string('email')->unique();
$table->timestamp('email_verified_at')->nullable();
$table->string('password');
$table->timestamps();
$table->foreignId('company_id')->nullable()->constrained('companies');
});
Schema::create('customers', function (Blueprint $table) {
$table->id();
$table->string('customer_name')->unique();
$table->timestamps();
$table->foreignId('company_id')->unique()->constrained('companies');
});
Schema::create('companies', function (Blueprint $table) {
$table->id();
$table->string('name')->unique();
$table->timestamps();
});
make sure companies table migrate first