我想使用laravel雄辩的模型和关系来加入项目中所有表的数据;但是,我在翻译这些关系时遇到了一个问题。例如,我有两个表;第一个是书籍表,另一个是作者表。
Schema::create('books', function (Blueprint $table) {
$table->increments('id');
$table->string('code', 20)->unique('ak_books__code')->nullable(false);
$table->smallInteger('books_type_id');
$table->float('detection_limit', 10, 0);
$table->smallInteger('books_classification_id');
$table->smallInteger('books_number');
$table->foreign(['books_classification_id', 'books_number'], 'fk_books__classification_scales')
->references(['calibration_id', 'number'])->on('classification')
->onUpdate('RESTRICT')->onDelete('RESTRICT');
});
Schema::create('classification', function (Blueprint $table) {
$table->smallInteger('calibration_id');
$table->smallInteger('number');
$table->string('name', 50);
$table->primary(['calibration_id', 'number'], 'pk_classification_scales');
$table->foreign('calibration_id', 'fk_classification_calibration')->references('id')
->on('calibration_parameters')->onUpdate('CASCADE')->onDelete('CASCADE');
});
如何在书籍表上建立关系以拿number
和calibration_id
?
喜欢书籍缩写,我将向您展示一个有关任务项目之间关系的示例(此任务的项目是什么):
任务
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('tasks', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->text('description');
$table->string('name');
$table->integer('project_id')->unsigned();
$table->timestamp('start_date');
$table->timestamp('end_date');
$table->timestamps();
$table->foreign('project_id')->references('id')->on('projects')->onDelete('cascade')->onUpdate('cascade');
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('tasks');
}
项目
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('projects', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('description');
$table->tinyInteger('active')->default(1);
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('projects');
}
我希望对您有帮助,问候!