Hi,
I'm design a database schema, for my invoice system, and i have a doubt:
I want have, invoice and estimate, but i dont know if use one table and inside the table, a value with different types or create a two tables, one for invoice and other for estimates. But the information that each have is same, only change the number of invoice or estimate.
Any opinion?
Thanks
j
stuff ;)
an invoice has to be a document by definition if you use foreign keys others than RESTRICT you will forge documents.
so yes redundant data is the way to go otherwise you risk onUpdate or onDelete problems :)