Search results
Apr 25, 2024 · I'm new to game db design and struggling how to make a inventory system. I found two options to design inventory db. For user it's like this. inventory has user_id and item_id and the relation is like 1:N and M:1.
5 days ago · Could someone provide a step-by-step explanation or point me to a beginner-friendly tutorial? I have an ERD for an inventory management system, and I need to create corresponding tables in a MySQL database. Any help would be greatly appreciated! enter image description here. i've watched youtube and such but im having a hard time understanding it
1 day ago · I am trying to use the following formula to tell me where I reduce inventory in overstocked DC's and where I move inventory to understocked DC's but the total on hand inventory does not add up to the total optimal level on the other end of the output: I will post a picture of the formula but I will explain again if I didn't do it well the first ...
6 days ago · I'm working on developing a booking system where users can reserve timeslots for various activities. I'm currently considering two different approaches for storing the booking information in the database, and I'm seeking guidance on which approach would be best suited for my scenario.
4 days ago · I am following a video tutorial to learn flask. I was able to create a database before creating the package structure. Now, I want to delete and create the database again but the queries do not do anything. Below is the package structure. enter image description here. I imported the db from mybills.routes and then ran below queries.
5 days ago · I want to understand if my thesis is right about storing complex data as jsonb vs using columns to store the various keys inside the jsonb. My thesis is that with jsonb, eventually we have different versions of data.
May 6, 2024 · I am working on a project where I need to implement real-time updates from a MySQL database table to a server. The goal is to ensure that any changes made to specific tables in the database are immediately reflected on the server side without relying on frequent polling.
