1
I’m creating a system and I have two columns: empresas and usuarios. The usuarios.id_empresa makes is the key of empresas.id_empresa, however, some data from the two tables are filled in simultaneously and after the registration is done the other information can be inserted. But if I turn php artisan migrate without data in the table empresas error appears that cannot make this link between tables by empresas not yet having data. How to resolve this?
The record dealer will have the inputs (among relatives in which table it belongs)
Name (user name) Company (enterprises) Telephone (company) E-mail (company name) password (users)
Note that this form will popular two tables at the same time, so I need to reference usuarios.id_empresas in empresas.id_empresa.
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->increments('user_id');
$table->integer('user_empresa')->unsigned();
$table->string('user_nome');
$table->string('user_email')->unique();
$table->string('user_cpf')->unique()->nullable();
$table->string('user_rg')->unique()->nullable();
$table->string('user_telefone')->nullable();
$table->string('user_senha');
$table->boolean('user_ativo');
$table->string('user_permissions');
$table->integer('user_profile')->unsigned();
$table->timestamps();
/* $table->foreign('user_empresa')
->references('empresa_id')
->on('empresas')->onDelete('cascade');*/
});
}
public function up()
{
Schema::create('empresas', function (Blueprint $table) {
$table->increments('empresa_id');
$table->string('empresa_nome');
$table->string('empresa_email')->unique();
$table->string('empresa_cnpj_cpf')->nullable();
$table->string('empresa_telefone');
$table->boolean('empresa_trial')->default(1);
$table->boolean('empresa_ativo')->default(0);
$table->boolean('empresa_cad_completo')->default(0);
$table->string('empresa_plano')->default(0);
$table->date('empresa_expira');
$table->timestamps();
});
}
What is the error message?
– novic
SQLSTATE[HY000]: General error: 1215 Cannot add Foreign key Constraint (SQL: a lter table
usersadd Constraintusers_user_empresa_foreignForeign key (u 
 ser_empresa) Referencesempresas(empresa_id) on delete)– user60485
I know this error gives because the companies table does not have data yet but how to solve it if I need to do the list of tables even without having data?
– user60485
Put the Migration on
– novic