I have ProductCollection Model and AttributeValue Model which have a common table product_collection_attributes that has 2 columns: product_collection_id and attribute_value_id that are a foreign key to their respective tables and are both a primary key. In ProductCollection Model relation is:…
Is there any way to create a relationship on a Laravel model using an "OR" condition for the field used to join the table while loading an eloquent model? Example Table: user_connections Name Type id bigInt|primary|auto_increment from_user_id bigInt to_user_id bigInt…
I'm developing a Spring Boot application with a PostgreSQL database. Within this application, I've implemented the functionality to create bots. Here's a glimpse of my Bot entity: @Data @Entity @Table(name = "bots") @NoArgsConstructor @AllArgsConstructor @Builder public class Bot { @Id…
Let's say i have three models User Post and Comment and linked like so: class User extends Model { public function posts(): HasMany { return $this->hasMany(Post::class); } } class Comment extends Model { public function post(): BelongsTo { return $this->belongsTo(Post::class);…
I have a problem that I have publications that are assigned to articles and I need to display other publications that are assigned to given articles on the details of a given publication. Each publication can be assigned to several…
I have 3 models: public class Student { public int StudentId { get; set; } public string StudentName { get; set; } public string Father { get; set; } public string PhoneNumber { get; set; } public string Email {…
I am developing an application that's used to manage sales business of a company. Their business are multi layer, means a sales person A is managed by another sales person B, and that sales person B is also managed by…
I have two Different Schemas User and Article A user can publish many articles for which the relationship is One to Many The scehmas are as follows const mongoose = require("mongoose"); const userSchema = mongoose.Schema( { username: { type: String,…
my database has two table games and teams, games migration: $table->unsignedBigInteger('homeTeam'); $table->unsignedBigInteger('awayTeam'); $table->foreign('homeTeam')->references('id')->on('teams') $table->foreign('awayTeam')->references('id')->on('teams') what is relationship between this two table? many to many? should I create "game_team" pivot table? i tried to change design of database but it don't…
I am using a Laravel Resource to return my object. The object has optional relationships. My Resource code so far is below and is working as expected: public function toArray(Request $request): array { return [ 'id' => (string) $this->id, 'attributes'…