Lets say I have 2 tables: User: ID: PK, AI username: varchar pwd: varchar addressID: FK references address.ID Address: ID: PK, AI street varchar, houseNr varchar, postal varchar, How would the history tables look like since we obviously have foreign…
I use Prisma and Postgresql for a project to store and manage recipes. I am struggling to implement a Many to Many relationship where I can constrain one side to require at least one value for the relation field. Recipes…
I'm encountering an issue with fetching data from my database in a production environment. The code works perfectly fine on localhost, but when deployed to production, it fails to retrieve updated data. Here's the relevant code snippet: import {connect} from…
Here my design database, I working on E-commerce project So when the admin create a new product its have new Id and the user have to select the color and size for the product. The problem is when create a…
I have two tables: dates: date 2024-01-01 2024-01-02 2024-01-03 2024-01-04 2024-01-05 actual: business_date id 2024-01-01 1 2024-01-02 2 2024-01-04 4 2024-01-05 5 I want to join these tables on the condition date = business_date, but in the case where there's…
I'm encountering a PHP execution time error while inserting approximately 250k records into a MySQL database using Laravel Eloquent. I'm aiming to achieve this without increasing the overall execution time, considering the following constraints: Frontend: Angular Multi-tenancy: Implemented using https://tenancyforlaravel.com/…
I want to group all the data with startDate>=today-3 or <=today+3. Here is the database: "startDate": { "$date": "2024-03-05T00:00:00Z" } Here is the query: const dailyPlans = await DailyPlan.aggregate([ { $match: { _id: { $in: allPlansID }, startDate: { $gte:…
Please check tables below and help to solve. Table A a_id name dept a_date amount 123 Clark Sales 2024-01-01 5000 124 Clark Sales 2024-01-02 6000 125 John Sales 2024-01-03 3500 126 John Sales 2024-01-04 5500 Table B b_id name dept…
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 have a problem with my Django database. When I enter: python manage.py makemigrations. I got this exception: AttributeError: module 'django.db.models' has no attribute 'PointField'. Here is my very simple code that cause the issue: from django.db import models import…