Multiple foreign keys in one table to 1 other table in mysql
- by djerry
Hey guys,
I got 2 tables in my database: user and call. User exists of 3 fields: id, name, number and call : id, 'source', 'destination', 'referred', date.
I need to monitor calls in my app. The 3 ' ' fields above are actually userid numbers.
now i'm wondering, can i make those 3 field foreign key elements of the id-field in table user?
Thanks in advance...