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