I
I
Igor2019-10-18 07:56:33
Database design
Igor, 2019-10-18 07:56:33

What type of database cell to use?

Hello.
Tell me please.
There is a table of users. Each user has a cell with numbers and information about them.
What type and type of data to use for a cell in which something like this will be stored:
Number -> some string, date, another date, a string with a date
Number2 -> string, date, another date, a string with a date
Number3 -> string, date, another date, date string,
etc.
How it will be used : each number will be constantly taken from the database, checked and, if necessary, any of the fields (string, number, etc.) will be changed in it.
That is, a permanent action reading a record and so on for each user (mostly no more than 5 numbers for each, but there may be 100 and 1000 numbers).
After some time, the number and everything connected with it will be deleted.
I thought to store it in json format, but will it be best practice or are there solutions that work better and faster?
And any DB will cope with this or some one is better suited?

Answer the question

In order to leave comments, you need to log in

2 answer(s)
M
Moses Fender, 2019-10-18
@mosesfender

Isn't it easier to make a table for this information, where there will be separate rows in which there will be corresponding fields, and bind it by user ID?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question