Should the primary key be the Projects or the Tasks? In other words, should the table design look like?
Page 1 / 1
In general, it is good practice to have a unique primary field. However, Airtable does not require this.
Note that the primary field (first column) is not the same as a primary key.
If you think that you will have several projects with multiple tasks, you might want to have a two table system, one table for projects and another for tasks. Then join the tables with a linked record field.
In general, it is good practice to have a unique primary field. However, Airtable does not require this.
Note that the primary field (first column) is not the same as a primary key.
If you think that you will have several projects with multiple tasks, you might want to have a two table system, one table for projects and another for tasks. Then join the tables with a linked record field.
@kuovonne Thank you. I should have clarified field vs key so thank you for that. What is the advantage to doing a two table system over a one table system? I always thought you’d want fewer tables where possible especially if the (in this case) tasks columns are all unique.
@kuovonne Thank you. I should have clarified field vs key so thank you for that. What is the advantage to doing a two table system over a one table system? I always thought you’d want fewer tables where possible especially if the (in this case) tasks columns are all unique.