What should be the structure of a mysql database in my case?
There is a challenge to create a table with users (name, balance)
each user can be some transaction, such as (a Fine prize)
So the question is, how do I organize the database structure? create a separate table for users and a separate transaction? And I these two tables to link please write the query for example to withdraw all fines user under the name Oleg
each user can be some transaction, such as (a Fine prize)
So the question is, how do I organize the database structure? create a separate table for users and a separate transaction? And I these two tables to link please write the query for example to withdraw all fines user under the name Oleg
asked June 10th 19 at 15:34
1 answer
answered on
Solution
Write a query difficult, because there is even an exemplary table structure of the database.
But I would have done exactly what you wrote. Just a little would improve.
Made three tables.
And the query would be something like this.
But I would have done exactly what you wrote. Just a little would improve.
Made three tables.
And the query would be something like this.
SELECT * from type_tranaction where i_user = 1 and i_type = 2Find more questions by tags MySQL
the user id in the table
Name
Surname
the record id
type id transaction
the value of TransAsia
the user id belongs to whom
id in the table
title (penalty/award) - Kamron29 commented on June 10th 19 at 15:45
In the extreme case at least
- Kamron29 commented on June 10th 19 at 15:51