Are the tables and relationships correct?
i redid the whole table and relationship, i would like to ask some advice if i'm on the right track or not so i could redo it again.
this is for a sales invoice with customer product price record and purchase invoice with supplier product price record
ThirdParty - record of supplier and customers
ThirdParty_Contact - record of supplier contacts and customers contacts
Product - record of product
Product 2, 3, 4 - TO of Product
LineItem_Sales - record of customer invoice and product
Invoice_Sales - record of customer invoice and thirdparty (customer)
ProductPrice_Customer - record of thirdparty (customer) and product
LineItem_Purchase - record of supplier invoice and product
Invoice_Purchase - record of supplier invoice and thirdparty (supplier)
ProductPrice_Supplier - record of thirdparty (supplier) and product
1. Should i separate the ThirdParty table into 2 ( customer table and supplier table), i combined them due to some customer might be a supplier and vice versa?
2. Should i combine the table LineItems, Invoices and ProductPrice? i've been thinking of combining these into one because they almost have the same fields.
3. I have 4 TO of Product but would like to merge it into one Product table if its possible, i noticed that if i start on the Product going to ThirdParty, the ThirdParty table needs to be a TO, and vice versa. i started with table ThirdParty so i got Product TOs,
Could i simpfily this to have just one Product and one ThirdParty Tables?
Thank You All!