With a schema: CREATE TABLE foo ( id SERIAL UNIQUE, name VARCHAR(15) NOT NULL, domain VARCHAR(255), ); CREATE TABLE bar ( foo_id INT UNIQUE NOT NULL REFERENCES foo(id), passphrase VARCHAR ); I need to use: SELECT * FROM foo LEFT…
I have a table companies in which there are some duplicated rows I found with a simple GROUP BY name. This companies table has a PRIMARY KEY id which is referenced in several other tables, under the name company_id, which…
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 have a 'projects' table in my Laravel project. The migration looks something like this: Schema::create('projects', function (Blueprint $table) { $table->id(); $table->string('title'); $table->string('key')->nullable(); $table->integer('bpm')->nullable(); $table->boolean('is_collaborative')->default(false); $table->foreignId('owner_id')->constrained('users')->cascadeOnDelete(); $table->timestamps(); }); I want the owner_id field to reference a user's id in order…
I want to save a post in my db with the logged user_id. I have a column user_id in my post table. When I want to create a new post with this logged user_id nothing happens Here is my my…
I recently started learning postgresql, and I had a little problem setting up relationships between tables. I have 2 tables - users and projects. Each project has its creator (user), and each user has an array with his projects. create…
CREATE TABLE Bagel ( BagelID CHAR(2) NOT NULL, BagelName VARCHAR(30), BagelPrice DECIMAL(4,2), BagelDesc VARCHAR(30), PRIMARY KEY (BagelID)); CREATE TABLE Customer ( CustID INT NOT NULL, FirstName VARCHAR(30), LastName VARCHAR(60), Address1 VARCHAR(60), Address2 VARCHAR(60), City VARCHAR(30), State CHAR(2), Zip INT, MobilePhone…
I have a table for the invoice and it has the primary key which is id, and for invoice details the foreign key is invoice_id. What I want is during saving the primary key on the invoice, it would also…
I have three tables 1. Account 2. dept and 3. managers In the managers table I need to add both account key and dept key as foreign key but one will null and other will have value, means if inserted…
I have multiple classes X, Y, Z: public class X { public int Id { get; set; } public virtual List<Image> Images { get; set; } } public class Y { public int Id { get; set; } public virtual…