I've been working on a project lately that is written in python and I want to incorporate mysql into it. The python code is basically a sales report writing system in which every sales report will have it's own number such as 10-0001, 10-0002 and will contain customer information like first & last names, addresses, phone numbers, etc. There is also a page, if needed, for items such as televisions, brand names of items, color of items, serial numbers of items, values of items, etc, and there will also be a narrative page where several paragraphs of info can be entered.
I originally made a database named "maindb" which has a table named "info". Inside of the table I made a few columns such as "fname", "lname", "City", "State", "Brand","Item". I now want to go through my entire code and set up all of the entries fields with mysql but I'm not sure if I should make it so every report number creates a new table with new columns, or if I should just stick with one table and a whole lot of columns in it.
Info to be entered can include:
The employee sales report number date & time of sale customer's first & last name customer's address customer's phone numbers (cell, work, home) type of payment (cash, credit card, check) number of items item description make of item model of item serial number of item price of item sales narratives/notes
I read about 'normalization' which seems like something I could use but I'm not really sure how to go about that. Any suggestions? Thanks