Tables that have been upgraded to
crrs may not have:
- Checked Foreign key Constraints. Foreign keys and joins are allowed but the constraint cannot be checked.
- Unique constraints that are not the primary key
- Check constraints that depend on columns other than the defined column
While there are techniques that allow preserving checked foreign keys, even under conditions created by eventual consistency, they all have nuanced tradeoffs. Throwing out these constraints for
crrs is something that is clear and keeps the model easy to undestand.