Apr 16, 2016 03:25 PM
I need to create an airtable for my vocational school. We teach and we place students into jobs.
I could create one mega table with lots of views. Or seperate tables for each:
Students
Sessions
Student Reviews
Employers
Prospects and Leads
Partners
Is there a methodology for deciding between making a view versus making a table and connecring data? What should i consider?
Apr 17, 2016 05:43 AM
Each “thing” should have it’s own table. The Students table should link to a Student Reviews table, etc.
Apr 17, 2016 06:21 PM
Thanks @Nathan_Cain.
How is that better than the student recoew being part of the student table, and just hidden or revealed using a VIEW?
Apr 17, 2016 11:57 PM
It depends on what a Student review is. Will a student be reviewed multiple times, and you want to keep the data from each review (in tech talk, is there a 1 to many relationship between students and reviews)? If so, you’d want to make Student Review a table.
Apr 18, 2016 05:03 AM
Also, if you want to use Airtable’s built in forms then you will want to keep separate tables. The form would allow you to choose the student from a dropdown and then type in the review information. The form would belong to the Reviews table.
Apr 18, 2016 11:35 AM
The student review is the student’s review of the school. So there’s a one-to-one relationship there.
Apr 18, 2016 01:49 PM
So, if you would like to present one of Airtable’s forms to the student then it will need to be a separate table. However, if you are going to have someone type in their review for the student or are going to make use of the api to design your own forms AND there will only be one review per student then you are good to go with one table.