As the title describes I want to have a zero-or-one to zero-or-one relationship. For example, let's say we have two tables Calls and Files. A call might have an attached file on it, and vice versa. But I have a…
I'm looking for a confirmation and possible explanation. In PostgreSQL, I create a table A, referencing table B by FK with constrain option ON DELETE UPDATE SET DEFAULT. If the referenced record from table B is deleted, the physical "change"…
Consider the following table definition: CREATE TABLE containers ( id SERIAL PRIMARY KEY, name VARCHAR(255) NOT NULL, parent_id SERIAL REFERENCES containers(id) ); When I INSERT INTO containers(name) VALUES('test_name'), I'm getting the following: SELECT * FROM containers; id | name |…
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…