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 report writing system in which every report will have it's own number such as 10-0001, 10-0002 and will contain 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 have a search page where the idea is that a user can type in a last name for instance and search the names files. 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","It em". I made these to test my code to make sure the information was being inserted, and it was. 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. One last thing, when a search is done for a report number, I'd like it to pull up all of the information that was submitted into it, or is that just a matter of how the program is coded and not to do with how it's stored? Anywhere from 1-30 reports generated daily. Thank you!
Comment