AnsweredAssumed Answered

Are the tables and relationships correct?

Question asked by starstuff on May 26, 2015
Latest reply on Jun 3, 2015 by starstuff

Title

Are the tables and relationships correct?

Post

Hi All!

 

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

Tables:

(GREEN)

ThirdParty - record of supplier and customers

ThirdParty_Contact - record of supplier contacts and customers contacts

(RED)

Product - record of product

Product 2, 3, 4 - TO of Product

(ORANGE)

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

(BLUE)

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

 

Some concerns

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!

 

 

relationships2.png

Outcomes