I will make a Spring Boot project school management system. There are many types of users. These users can log in. Do I need to create a user entity and then extend other entities from the user class? What makes…
In Symfony Api Platform application, using Maker Bundle to add a relationship field "Owner" to "Community" Entity coused all "Get" api calls to return the same error. This is a new project I use all the newest available version. Request:…
Just wanted to make sure that I'm understanding this right: designing UML-diagram we are talking about the relations between entities? in the context of SQL a table is a relation? I can remember that my teacher, for a while ago,…
In my application, an organization has multiple events, and a user can have multiple roles in different events, Until now it's all good I can just do a pivot relation btw user_id, role_id, event_id, But the problem is that I…
How can i insert multiple values into one row? My query insert into table_RekamMedis values ('RM001', '1999-05-01', 'D01', 'Dr Zurmaini', 'S11', 'Tropicana', 'B01', 'Sulfa', '3dd1'); i cant insert two values into one row. is there another way to do it?
My code is: CREATE TABLE `table_a` ( `id` INT NOT NULL AUTO_INCREMENT, `value` varchar(255), PRIMARY KEY (`id`) ) ENGINE=InnoDB; CREATE TABLE `table_b` LIKE `table_a`; INSERT INTO table_a VALUES (1, 'A'), (2, 'B'), (3, 'B'); INSERT INTO table_b VALUES (1, 'B');…
Newbie here having trouble wiring up some tables for a game's leaderboard. Would appreciate help! I have 3 tables; here's an ER diagram: ┌─────┐ ┌─────┐ │ IPs ├─||─────────────────|<─┤Names│ └──┬──┘ └──┬──┘ │ │ │ │ │ │ │ │ │ │…