Recognises a uniqueness rule with no unique key behind it
A uniqueness rule marked as enforced, with no primary key or unique constraint covering those columns.
Can AI do this?
AI does this well Most of the tested AI models master this. 8 of 10 models master it.
| Model | Tier | Probability of mastery | Status |
|---|---|---|---|
| gemini-4-argon | Flagship | 100% | Mastered |
| gemini-3.1-pro-preview | Flagship | 84% | Not shown |
| gpt-6-astra | Flagship | 100% | Mastered |
| claude-fable-5-1 | Flagship | 100% | Mastered |
| gemini-3.8-flash | Mid tier | 100% | Mastered |
| gpt-6.1-sol | Mid tier | 100% | Mastered |
| claude-sonnet-5-5 | Mid tier | 100% | Mastered |
| gemini-3.5-flash-lite | Low cost | 45% | Not shown |
| gpt-6-luna | Low cost | 99% | Mastered |
| claude-haiku-5-5 | Low cost | 100% | Mastered |
Mastered means a probability of at least 90% that the model has this knobit, estimated from its graded answers. “Not shown” means the answers do not settle it either way. How the models are tested.
What it looks like in practice
Expected result: The rule and the missing primary key or unique constraint
How it is assessed: Flags the deficient case and passes the acceptable one. Deficient: BR-2: no two accounts share an IBAN, enforcement: constraint, and no uk_ on that column Acceptable: A unique constraint on the natural key, or the rule reassigned to a DQ check with a threshold (ANO-012)
Also known as: Uniqueness with nothing unique behind it (data rule)
Related knobits
Builds on
- K-356 Explains rule enforcement mechanisms and platform enforcement
- K-552 Explains candidate key and prime attribute
All 28 knobits of Document data rules as SBVR fact types and rule statements.
Source: Review checklist 03-data-rules, row 11