Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | MODULE_COMPONENT_LINK |
| Short Name | MCL |
| View Name | CI_MODULE_COMPONENT_LINKS |
| Description | A link between two MODULE_COMPONENT_INCLUSIONS that may be in the |
| same module or in different modules. The two sub-types of link | |
| are KEY_BASED_LINK, where the link is via a specific primary or | |
| foreign key, and CUSTOM_LINK, where the nature of the link is | |
| defined in a join condition | |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Non-instantiable super-type of | CUSTOM_LINK |
| KEY_BASED_LINK | |
| 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_MCL |
| Changes: | Summary of changes to MODULE_COMPONENT_LINK in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| MCN_REFERENCE_FROM | N |
Prompt: From Module Component
Transferable only if null |
Must be from one and only one MODULE_COMPONENT_INCLUSION | |
| MCN_REFERENCE_TO | N |
Prompt: To Module Component
Transferable only if null |
Must be to one and only one MODULE_COMPONENT_INCLUSION | |
| MODULE_REFERENCE_FROM | N |
Not displayed
System maintained Not transferable |
Must be from one and only one GENERAL_MODULE | |
| MODULE_REFERENCE_TO | N |
Not displayed
System maintained Not transferable |
Must be to one and only one GENERAL_MODULE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| MODULE_COMPONENT_LINK_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating the type of module component link
Not displayed Uppercase System maintained Not updatable by user | MODULE_COMPONENT_LINK_TYPE | |
| SQL_QUERY_CLAUSE | VARCHAR2(10) | N | Identifies where the join condition is used
Prompt: SQL Query Clause Uppercase | SQL_CLAUSE | DEFAULT |
| 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 MODULE_COMPONENT_LINK:
Note: