Added employee table and employee seed.
re-wrote the seed file to sanitize the data and split employee and customer columns. Have not migrated the schema to match the new seed file. Database is out of sync with the output of the seeding process.
ran first sales migration, going to seed the db with data from the sales csv.
properly seeded and sanitized the sample from the csv! All the data is in the db, need to split up into different tables.
generated employee scaffolding, migrated the employee table and added an employee id column to the sales data table. Have not populated the employee table with info from the sales data table.
ran migration to populate the employee table from the sales data table.
populated the employee_id column of the sales data table. Now there is a foreign key in the sales data table that links to an employee data table of four employees.
added customer scaffolding and ran the migration to add the customer table to the database. It has not yet been populated with information from the master sales data table.
added customer id column to sales data table. have not yet populated either the customer table or the customer_id column in the sales table.
populated customer table and customer url attributes... went back because I accidentally overwrote customer account number. Cant find a way to revert the migration. ugh.
trying to fix the overwritten account numbers in the customer table as well as filling the customer_id in the sale table. wrote a migration but have not yet runt it.
added migration to populate customer id in sales table. accidentally overwrote account number. need to reseed database before migrating.
just prior to seeding the database
returned database back to it's original state
reseeded database so that the account numbers were correct. successfully populated the customer ID column in the sales table. On to creating products!
created Product model/scaffold. ran the migration to create a product table in the db with a name column.
added product id column to the sales table
populated product table as well as product id in sales table.
fixed seeding problem and migrations for customer ID and product ID in the sales table should work now.
commit made after customer id and product id were correctly populated in the sales table as foreign keys.