Foreign keys in database modeling

Navigation
0

Can a primary key have two foreign keys in different tables? For example:

    
asked by anonymous 01.07.2015 / 08:54

1 answer

1

The primary key of the Profits table can be foreign / external key of other tables, in this case you have:

Billing 

 PK->codFaturamento
 FK->codLucro

Earnings 

PK->codLucro

Expenses 

PK->codDespesa

FK->codLucro

In these cases, a 1: N relationship

    
01.07.2015 / 10:46
Google maps v2 is returning "INVALID_REQUEST" How to make a lightbox with CSS and jQuery?