Skip to content Skip to sidebar Skip to footer

Sql Primary And Foreign Key

if you have tables A(a primary key) B(primary key (b ,c)) and C(primary key (a,b1,b2,c) references A(a),B(b),B(b),B(c)) how would you go on and define it in proper Sqlite for A

Solution 1:

I think you would do:

C(a) references A(a)
C(b1, c) references B(b, c)
C(b2, c) references B(b, c)

But it is a little hard to tell without examples of the data and knowing what the columns and tables mean.

Post a Comment for "Sql Primary And Foreign Key"