Table creations

[David Sanborn]

I am writing an app for use with my trucking company. Each user will have the app, where they can store their trip data, and export twice a month to their Cloud Storage. They can then import it to a sheet that will extrapolate the trip data, and payroll data into separate sheets with in the worksheet. 

My question is, how should I set up the tables? I have current trip data that goes onto a trip sheet for handing in, payroll data for the personal info for the driver, app settings data (check boxes etc) for recall with trip info is recalled for updating on route, trip data they select from, payroll data that is pulled according to the drivers selections, vehicle data for the same reason. 

I have worked with SQL in my apps, but as a single table with limited data storage. This is my first bigger use of tables, and I am not sure if I should have one large table with all the data, or smaller tables. I know I am going to use trip data (stored pick up land drop locations) as one table, and the same for vehicle data. How should I set up the other table(s)?

[Alex (Cloud Platform Support)]

Hi David,

This is a classical topic in web application development: the design and structure of SQL tables. A question like this would have better chances of useful answers if posted on Stack Overflow which we regularly monitor alongside other Stack Exchange sites (see one here specifically for database administration). Posting there would increase your chances to get a comprehensive answer due to the larger audience. This Google forum is more suited to general discussions of Cloud SQL Platform specifically.

[David Sanborn]

Thanks.