I would like to know how can I get Count on LEFT JOIN in SQL. Currently I have 3 tables : rooms_messages id room_id discussion_message_id created_at 1 10 101 2024-07-16 12:30:45 2 20 102 2024-07-16 12:30:50 3 10 103 2024-07-16…
I am developing an accounting app where users can have a product with currency A. The value of the product can be escrowed using a cheque payment with currency B and this cheque payment can be paid in cash with…
A personal identity codes consist of a string of numbers that indicates the individual’s date of birth, an individualized string, and a control character. Example: 150600A905P • 150600 = Date of birth • A = the character in the middle…
I am trying to seed my prisma db but am having trouble doing so with a user -> Payment relation. Seeder Code: export const userSeeder = async (prisma) => { const productIds = await getProductIds(prisma); const { gamingLaptopProductId, chairProductId, cologneProductId,…
I have a table like this: CREATE TABLE "users" ( id serial PRIMARY KEY, town text NOT NULL, street text not null, building text ); I want to be able to store unique entries by 3 columns "town", "street" and…
I have a parent table and a child table. A parent row stores the foreign key to the child row. If I set the constraint on the foreign key to ON DELETE CASCADE then that will throw an error when…
I'm implementing forgot password functionality in my NextJS app. I'm generating a temporary token whenever the user clicks on forgot password. Should I store the temporary token in the already existing users table, User table user_id user_name forgotpass_token here only…
In Laravel can I create oneToMany relations with junction tables instead of belongsToMany? Tables: Users: id, name, etc Table1: id, name, etc Table2: id, name, etc Table3: id, table1_id, table2_id, currentActive, lastActive [junction table with pivot columns] Table4: id, table3_id,…
I am creating an application which will enable users to create posts and also like posts. I am using MySQL to store all the data. I have the tables users and posts. I want to prevent the situation where a…
The following is my Prisma Schema for 3 models --> User, Cart and Item. model User { id String @id @default(auto()) @map("_id") @db.ObjectId name String email String @unique hashedPassword String isAdmin Boolean @default(false) cart Cart? } model Cart { id…