Please pay attention to the below step by step description.
I have 2 tables,
idTransaction, which is an auto generated value. The
idTransaction_Feewhich is also an auto generated value.
Transaction_Fee, therefor, the
Transactioncan have only one
Now, I think I need to make both
primary keys in
Transaction_Fee table, because
Transaction cannot be duplicated.
Now my question is, since the
idTransaction_Fee is going to have 2
primary keys, is it mandatory to create a
Unique Key for
Transaction_Fee ? The reason I am asking this is in some cases I have seen people creating
Unique Keys when they have 2
Primary Keys in a table. But in my case, since the
Transaction_Fee can be easily identified using its auto generated ID
Unique Key is not required, I think.
However I am willing to take expert advice before proceeding.