Specifies whether the constraint is defined or established and whether it is enabled or disabled. State only applies to referential and check constraints.
Defined and enabled
The constraint definition has been added to the file, and the constraint will be enforced after the constraint is established.Defined and disabled
The constraint definition has been added to the file, but the constraint will not be enforced.Established and enabled
The constraint has been added to the file and all of the pieces of the file are there for enforcement.Established and disabled
The constraint has been added to the file and all of the pieces of the file are there for enforcement, but the constraint will not be enforced.