
Tips
The primary key of the DB should be the surrogate key, not the compound primary key.
When I was researching about Unicode's "surrogate pairs" in a separate matter, an article about the "surrogate key" and "compound primary key" in the database was caught in the **surrogate** connection and I derailed as much as I could (laughs)...