build tables of my database MySQL -

i'm building tables , relation of database.

i have table of product , 3 tables of promotions a_i id have differents rows according type of promotion.

how can reference product correct table of promotion?

it's little bit difficult explain it, hope understand. many ;))

you have in product table, field contains 'promotionstypeid', , use 1 table called promotion, , promotionstypeid reference promotionid in promotion table, instead of using 3 different tables promotion. make promotion generic promotion.