Can a foreign key be null?
I'll answer
Earn 20 gold coins for an accepted answer.20
Earn 20 gold coins for an accepted answer.
40more
40more
Works at Clean Energy Partners, Lives in Copenhagen, Denmark.
Any number of rows in the child table can reference the same parent key value, so this model establishes a one-to-many relationship between the parent and foreign keys. However, each row in the child table must have a reference to a parent key value; the absence of a value (a null) in the foreign key is not allowed.
2023-05-06 16:07:48
评论(499)
Helpful(122)
Helpful
Helpful(2)
Alexander Wilson
QuesHub.com delivers expert answers and knowledge to you.
Any number of rows in the child table can reference the same parent key value, so this model establishes a one-to-many relationship between the parent and foreign keys. However, each row in the child table must have a reference to a parent key value; the absence of a value (a null) in the foreign key is not allowed.
