In SQL, what's the standard convention for what rows and columns should be used for? For instance, if I need to make a table of users and their data, which axis (rows or columns) should be the users labels and which axis should be the users data labels?EDIT: The Free Heroku plan only allows a maximum of 10000 rows on the SQL table, so will it make a difference if I switch the table axises around and use a very large number of columns instead of rows?
What should I use columns for, and what should I use rows for in SQL?
database;database design;sql;heroku