How do I link two tables, People and Messages, when there is no single column in the Messages table that corresponds to the primary key of the People table? I have two tables: one containing email messages called Messages and…
In the UI I have a table where I'm showing data grouped by shipday which is days of the week. To do that in the hasura I've created a PostgreSQL view - CREATE OR REPLACE VIEW "public"."view_shipday" AS SELECT shipdata.shipday,…
In SQL I have a table setup RegisterTable ---- DocId int status int docType int CarDocument Table ---- carDocId int (PK, FK -> RegisterTable) name string carMake varchar EmployeeDocument ---- emplyeeDocId int (PK, FK -> RegisterTable) name varchar age int…
I am designing a database for a web project in which I am trying to collect users' emotional feelings toward art collections. A hybrid dual list on the website allows users to select three options from 12 options and then…
I have several millions of files and each file may have several thousands of functions. I have to store the names of these files and functions in a MySQL table to display this in a UI. The file names will…
I am building a web app for a client who has ~1M rows of data in their MySQL database. The data looks approximately like this: Products +---------+-----------+---------+-------------+---------+----------+ | Id | Name | Size | Colour | 4 Other attributes |…
I am designing a sharded database. Many times we use two columns, first for logical shard and second for uniquely identifying a row in the shard. Instead of that I am planning to have just a 1 column with long…
I need to create a table where each user (approx 60 atm) would have a defined task for each day. Right now the database have one column for each user with the task name in it (which is bad in…
There's a simple table with columns a,b,c,d. I want value in d to be a+b if c>0 and a-b if c<=0. How can I do this? I tried this code and it doesn't work. How can I dynamically insert data…
I have a user collection in firestore and each user object has an array of references to "tasks" that they have applied to. Tasks is a separate collection as well and each task object has a user ref array as…