I have a table which contains all the Reports report_id | Name ---------------+------------- 1 | Sales Q3 2 | Sales Q2 I have a relation table which contains one to many relations about the report with dept report_id | dept_id…
Let's say I have a posts and users models, I want to manage the relationship between them like so: bookmarks (A post can be bookmarked by many users and vice-verca) likes (Same idea as bookmarks) The convention is to make…
I am creating an webshop app. I have a tech shop with products that are for example CPUs, GPUs, keyboards, mouses etc. All of them have common attributes - id, description, name, but also their own, custom attributes - mouses…
I have a table called Configuration: CREATE TABLE "Configuration" ( "id" CHAR(36) NOT NULL, "namespace" VARCHAR(255) NOT NULL, "key" VARCHAR(255) NOT NULL, "value" JSONB NOT NULL, "level" "ConfigLevel" NOT NULL, "userId" CHAR(36), "orgId" CHAR(36), "teamId" CHAR(36), "moduleId" CHAR(36), "moduleSubscriptionId" CHAR(36),…
I have a postgresql database with four tables: User, Country, City, and Street. The User table contains information about users, including their name, level (which can be "Country", "City", or "Street"), and ids that corresponds to the ID of the…
I am building an online editing tool. This tool allows users to upload different types of media and files, which are stored in S3. I'm struggling to think of a robust and future-proof way to manage these files, particularly when…
I'm designing the database for a food delivery app. There are special kind of products: Product examples: Kebab (price is fixed) Pizza Margherita - (price is dynamic) Pizza Half-Half - (price is dynamic - there are two products combined into…
I have this part of a class diagram that I want to translate into SQL: Piece of class diagram: My internship supervisor sent me this SQL code: CREATE TABLE `users` ( `Matricule` varchar(50) NOT NULL, `Password` varchar(50) NOT NULL, `Role`…
I design a game achievement system for a MySQL database. Each achievement has 3 levels and each level contains a different reward. Achievements and their levels and rewards are the same for every user. Table achievement: id_achievement title description level_1…
I am designing a DB schema for a meal planning application. Each meal plan consists of blocks (2 months of diet, 2 months of bulking), each block of meals for the day, each meal of the day of foods. I…