[wvenable]

Composite keys are fine as long as all the key columns are surrogate keys.

[SoftTalker]

High bridges without guardrails are fine as long as you don't fall off.

[wvenable]

Using composite keys can help prevent you from representing invalid states in the database or in your application. They can be guardrails.