Timeline for MySQL table design
Current License: CC BY-SA 4.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 24, 2021 at 16:31 | vote | accept | Ofek | ||
| Mar 25, 2021 at 20:05 | comment | added | Ofek | Also just to clarify, you SELECT FROM records and not user_records as you were talking about the first approach | |
| Mar 25, 2021 at 20:04 | comment | added | Ofek | Hi there! Thank you for your answer. Actually, I did thought of this solution but it made me think of some more vulenerabilities it has. for example now this admin is a complete user which means if for some reason someone might find out its credentials then he would be able to remove all the general records from the database. Also for a little debate, what if I'll need to add in the future some kind of system to determine whether or not a user record is a "trusted" record by other users. Then the first approach would be come "clustered" with unnecessary data. no? | |
| Mar 25, 2021 at 18:49 | history | answered | John Herbert | CC BY-SA 4.0 |