I have a table that is connected with 2 other tables like so:
ID_1 | ID_2 //Foreign key of table1 //Foreign key of table2
ID | Some information |More information //connected with ID_1
ID | Some information | More information //connected with ID_2
So in the main table,
ID_2 can be set, but not both. The way it is now (2 foreign keys) aren't working because they're optional.
What would be my options here?
I know I can split it up to 2 tables but that's not how I want it.
Should I make them able to be NULL?