Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | CONSTRAINT |
| Short Name | OCO |
| View Name | CI_CONSTRAINTS |
| Description | Definition of an Oracle referrential integrity constraint. |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Non-instantiable super-type of | CHECK_CONSTRAINT |
| JOIN_CONSTRAINT | |
| PRIMARY_KEY_CONSTRAINT | |
| UNIQUE_KEY_CONSTRAINT | |
| As this is a non-instantiable supertype, follow links (above) to its instantiable subtypes to find versioning information for each subtype, uniqueness criteria, API rules etc | |
| Underlying table: | SDD_OCO |
| Changes: | Summary of changes to CONSTRAINT in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| TABLE_REFERENCE | N |
Prompt: Table
Transferable only if null |
Must be placed on one and only one RELATION_DEFINITION | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| COMPLETE_FLAG | VARCHAR2(1) | N | Indicates whether the definition of the constraint is complete and ready to be used by the generators
Prompt: Complete ? Uppercase | YESNO | Y |
| CONSTRAINT_TYPE | VARCHAR2(10) | N | Sub-type discriminator. Internal property indicating the type of CONSTRAINT i.e. PRIMARY, UNIQUE, CHECK, FOREIGN or DOMAIN
Not displayed Uppercase System maintained Not updatable by user | OCO_CONSTRAINT_TYPE | |
| DEFER_STATUS | VARCHAR2(16) | N | Indicates whether constraint checking can be deferred until the end of the transaction (as opposed to end of each DML statement)
Prompt: Defer Status Uppercase | DEFER_STATUS | NOT DEFERRED |
| ERROR_MESSAGE | VARCHAR2(70) | Y | An error message that is issued when data violates the constraint.
Prompt: Error Message | ||
| NAME | VARCHAR2(30) | N | The name of the key constraint.
Prompt: Name Uppercase | ||
| PARENT_IVID | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a versioning viewpoint. Contains the IVID of the primary element type (not necessarily a PAC) forming the basis of the "versionable object" to which this element type belongs
Not displayed System maintained Updatable only if null Defined on SAC supertype | ||
| PAC_REFERENCE | NUMBER(38, 0) | Y | Internal use only. Exists on "secondary" element types from a structural viewpoint. Contains the IRID of the PAC forming the basis of the "logical object" to which this element type belongs
Not displayed System maintained Not updatable by user Defined on SAC supertype | ||
| Multi-line Text | ||
|---|---|---|
| Name | Text Type | Prompt |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| Other Properties |
|---|
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference CONSTRAINT:
Note: