Answer the question
In order to leave comments, you need to log in
What is the best way to structure tables?
There is a table with applications, the application has a status (Accepted or Rejected). If the status is Denied, there should be a comment with the reason for the refusal. What is the best way to organize the table structure?
The following options came to mind:
1. In the application table, in the status field, store json of the form
{
'status' : "...",
'comment' : "..."
}
id ,
status_name.
id,
status_id,
comment
Answer the question
In order to leave comments, you need to log in
1. In the request table in the status field, store json of the form
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question