I have the following 2 tables in MySQL: Client (identifier, first name, last name ...) Bonus (Id, CustomerId, Value, ...)
A one-to-one relationship, each customer has only one bonus. (CustomerId is unique in the bonus table)
Q: Do I have to leave the "Identifier" column in the bonus table? (I want to know why or why not)
Bonus.Id coulmn Bonus.CustomerId PK. Bonus.CustomerId, . , , -- Bonus.Id coulmn. Bonus.CustomerId, PK , . , - FK , CustomerId ( PK), , .
, , , , . SQL .
, Bonus.Id .
--, ? "bonusvalue" .
(: , , - , "id" )