multiple foreign keys in one table
Is it possible if I have a loads table that consists of Carriers and Customers with ID’s in the Accounts table to have foreign keys for both of these fields in the loads table pointing to the one Accounts ID field?
Example:
Loads table:
Carrier : UUID
Customer: UUID
Accounts Table:
ID : UUID
account_type: carrier or customer
Doing this I have gotten a foreign key error before and am not sure how to fix.
Example:
Loads table:
Carrier : UUID
Customer: UUID
Accounts Table:
ID : UUID
account_type: carrier or customer
Doing this I have gotten a foreign key error before and am not sure how to fix.
