Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | FOREIGN_KEY_CONSTRAINT |
| Short Name | FCO |
| View Name | CI_FOREIGN_KEY_CONSTRAINTS |
| Description | Definition of a foreign key constraint |
| Sub-type of | JOIN_CONSTRAINT |
| Versioning: | Belongs to: RECORD versionable object SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_REFERENCE FOREIGN_TABLE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_OCO |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| FOREIGN_TABLE_REFERENCE | N |
Prompt: Join Table
Transferable only if null Defined on JCO supertype |
Must be for joining to one and only one RELATION_DEFINITION | |
| TABLE_REFERENCE | N |
Prompt: Table
Transferable only if null Defined on OCO supertype |
Must be placed on one and only one RELATION_DEFINITION | |
| PRIMARY_KEY_REFERENCE | Y | Prompt: Primary Key Joined To | May be for joining to one and only one PRIMARY_KEY_CONSTRAINT | 32 |
| UNIQUE_KEY_REFERENCE | Y | Prompt: Unique Key Joined To | May be for joining to one and only one UNIQUE_KEY_CONSTRAINT | 32 |
| RELATIONSHIP_END_REFERENCE | Y | Prompt: Relationship | May be the implementation of one and only one RELATIONSHIP_END | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ARC_MANDATORY | VARCHAR2(1) | N | Indicates whether or not foreign keys in the arc are mandatory
Prompt: Arc Mandatory ? Uppercase | YESNO | N |
| ARC_NUMBER | NUMBER(6, 0) | Y | Number identifying which arc (if any) this foreign key is within
Prompt: Arc Number | ||
| 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 Defined on OCO supertype | 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 Defined on OCO supertype | 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 Defined on OCO supertype | DEFER_STATUS | NOT DEFERRED |
| ENABLED_FLAG | VARCHAR2(1) | N | Specifies if constraint is ENABLED or DISABLED when it it is created on the database
Prompt: Enable ? Uppercase | YESNO | Y |
| ERROR_MESSAGE | VARCHAR2(70) | Y | An error message that is issued when data violates the constraint.
Prompt: Error Message Defined on OCO supertype | ||
| EXCEPTION_TABLE | VARCHAR2(40) | Y | Contains the name of the table which is to hold exceptions when an attempt is made to create the constraint on the database
Prompt: Exceptions Table Uppercase | ||
| FK_CASCADE_DELETE | VARCHAR2(1) | N | Indicates the actions required following an attempt to delete a related row in the join table
Prompt: Delete Rule Uppercase Defined on JCO supertype | CASCADE_RULE | X |
| FK_CASCADE_UPDATE | VARCHAR2(1) | N | Indicates the actions required following an attempt to update a related row in the join table
Prompt: Update Rule Uppercase Defined on JCO supertype | CASCADE_RULE | X |
| FK_TRANSFERABLE | VARCHAR2(1) | N | Indicates whether or not the foreign key can be updated.
Prompt: Transferable ? Uppercase Defined on JCO supertype | YESNO | Y |
| FOR_JOINING_TO | VARCHAR2(3) | Y | Arc 32 discriminator. Indicates element type "for joining to" arc points at (PCO or UCO)
Not displayed Uppercase System maintained Not updatable by user | FOREIGN_KEY_CONSTRAINT_FOR | |
| IMPLEMENTATION_LEVEL | VARCHAR2(6) | N | Indicates if constraints are implemented in the database, application, both or neither
Prompt: Validate in Uppercase Defined on JCO supertype | FCO_IMPLEMENTATION_LEVEL | BOTH |
| MANDATORY_FLAG | VARCHAR2(1) | N | Indicates whether the foreign key must exist
Prompt: Mandatory ? Uppercase Defined on JCO supertype | YESNO | Y |
| NAME | VARCHAR2(30) | N | The name of the key constraint.
Prompt: Name Uppercase Defined on OCO supertype | ||
| 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 Defined on OCO supertype |
Description |
| NOTES | CDINOT Defined on OCO supertype |
Notes |
| Other Properties |
|---|
| FOREIGN_KEY_CONSTRAINT has the 20 user definable properties (USER_DEFINED_PROPERTY_0, _1, _2, _3 etc) for User Extensibility |
The following 'standard' properties are also inherited by all element types:
|
Other element types that reference FOREIGN_KEY_CONSTRAINT:
Note: