I have a bidirectional ManyToMany mapping, and I am trying to delete a post entity. When I delete it, the reference in the posts_categories table should also be removed. However, despite trying the following two approaches, it’s not deleting the…
I am developing a database for giveaways. I have two main tables: participants and giveaways with an N:N relationship since a participant can participate to one or more giveaways and a giveaway can have one or more participants. My (simplified)…
I have an application with a User model and a Group model as well as a Many-To-Many relationship defined between both models. I now would like to check if a user is member of a specific group. I know that…
I have a model Product, and the same product can be sold by multiple supermarkets and outlets, so I define two BelongsToMany relationships for them: class Product extends Model { public function supermarkets(): BelongsToMany { return $this->belongsToMany( Supermarket::class, 'product_supermarket', 'product_id',…
I'm developing a React Native app and utilizing Appwrite for storage and API calls. For saving the user ID of users who like a post, I'm employing the following API call: export async function likeVideoPost(postId, userId) { try { const…
I'm currently building an API assigned for an ecommerce project using Laravel framework. While getting help to build data migrations and Models, I got confused on how the product_categories, the intermediate table, can link a product and category as in…
I have two collections in MongoDB with many-to-many relationship. Many users can be cast in many roles. It looks like Entity Framework is adapted only for relational databases, where an helper table between two entities is used as a join…
i have a many to many relation like a customers and orders. type EmployeeShiftList struct { ID uint UUID uuid.UUID `gorm:"<-:create"` FirstName string `validate:"required,max=250"` LastName string `validate:"omitempty,max=250"` ShiftMaps []ShiftMap `gorm:"many2many:attendance.employee_shifts;foreignKey:ID;References:ShiftID;joinForeignKey:EmployeeID;joinReferences:ShiftID"} type ShiftMap struct { ShiftID uint `gorm:"primaryKey"` FromDate time.Time ToDate…
I have my models configured as below: public class Order { [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } public string UserId { get; set; } = null!; public DkUser User { get; set; } = null!; public int…
I know that primary key values cannot be repeated. However, I want to make it so that games can be played on more than one platform. For example "Dark Souls" on PC and PS4. How do I modify the relational…