Is it possible for a field that is part of a composite key to be a foreign key referencing a primary key in another table?

Question

I am trying to model a database and I have two tables: Cell_Information and Cell_Stats In Cell_Information, Cell_ID is the primary key.

In Cell_Stats, Cell_ID and Timestamp are a composite primary key.

is it possible for Cell_Stats.Cell_ID to be a foreign key while also being part of the composite key?

If you are having trouble with it, show us the specific SQL that is causing trouble. — Rick James, Feb 25 '21 at 06:43

score 0 · Answer 1 · answered Feb 17 '21 at 11:22

0

is it possible for [a particular column] to be a foreign key while also being part of the composite key?

Yes.

That was easy. If you are having trouble making it work, please ask another question.

answered Feb 17 '21 at 11:22

O. Jones

1 Answers1