I have a form with multiple fields to upload data and fetch the member's data to the front end. In the front end, some sections have multiple points so I have created separate tables for them. To fetch data from…
I'm building an analytical solution with a worker to calculate 30-day statistics and a UI to display them. Currently, the UI uses a fixed last 30 days date range, but I want to support custom date ranges with millisecond response…
I've been trying to model a relationship in Laravel between a ShapeContainer entity and different shapes with unique properties, but a common Shape interface (with getArea and getPerimeter methods). I've read up on the examples in the laravel documentation (posts,…
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…