denz1994 / bespoked-seed Goto Github PK

Currently, the seeding for the sales table is not filling correctly. Here is the high-level diagram of the tables and how they relate:

A good starting point would be to ensure the Customers, Products, and Salespersons tables are updated before we use their columns as foreign keys. We can naturally force the order because all the 3 tables mentioned above have already been asynchronously seeded prior to the seeding of the Sales table.

Once we have access to the entries in their respective columns we can seed them into the sales table. A similar approach can be used for the quarterly report, but using only the Sales and Salesperson tables as dependencies for the quarterly report.