any626
searching PlanetScale…
- 1.▲
- 2.▲
- 3.▲
- 4.▲
- 5.▲
- 6.▲
4 ms·
- 1.▲
- 2.▲
- 3.▲
- 4.▲
Depends You could have property_id, user_id, value(string)
1 (assume age), 1213, 60
2 (gender), 1213, female
or property_id, user_id, value_str, value_int
1 (assume age), 1213, null, 60
2 (gender), - 5.▲
- 6.▲
The user data is most likely in rows instead of columns.
Instead of having id, name, age, gender
1213, fake, 60, female
they would have property_id, user_id, value
1 (assume age), 1213, 60
2 (gender), 1213, - 7.▲
- 8.▲