Quote:
1) Does cascade=x mean that it cascades the entire object graph, or only to the next level, unless the next level also contains cascade=x ?
Only to the next level, then that level's cascade takes over so to speak.
Quote:
2) If one set has cascade=x and the next cascade=y, which applies? x or y? Does "all" have precedence? What are the rules?
The set with 'x' will follow 'x', the set with 'y' will follow 'y'. Cascade all means that both inserts and updates are cascaded. Cascade all-delete-orphan means that orphaned children will be deleted when their parent is deleted.