I have few questions on my database setup:
In Figure 1, the primary “Recipe Listing” table is related to other tables (such as Recipe Steps). Is it correct to reference these other tables as “List of xxxx”, or should they be referenced as a single entry (xxxxx)?
In Figure 2, the “Recipe Steps” table is shown. Each field contains a data array. Do I need to add a separate unique key field to link the two tables? Or, is it configured correctly using the Recipe Listing field?
The data in the “Recipe Steps” table will only be uploaded via a CSV file import (i.e. there will be no “add data” option within the app). When importing the CSV file (Figure 3), if I choose the Type of Data field as “Recipe Steps”, I can validate and upload the data. If, however, I choose the Type of Data as “Recipe Listing” (as shown in Figure 3), I get an error (“The field Steps has been used twice. Please check your settings”). Is this error linked to an incorrect database configuration?