locked
multiple foreign keys in a table refer to one primary key RRS feed

  • Question

  • User1055443156 posted

    Hi

    can its  good idea to design a database like

    multiple foreign keys in a table refer to one primary key

    Item table

    colums

    --item_id

    --cr_id (fk)               //

    --cr_coverId(fk)

    above cr_id and cr_cover_id

    relate same table Cureencies

    Cureencies

    ---cr_id

    Tuesday, October 2, 2012 3:18 AM

Answers