Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | KEY_BASED_LINK |
| Short Name | KBL |
| View Name | CI_KEY_BASED_LINKS |
| Description | A sub-type of MODULE_COMPONENT_LINK |
| A KEY_BASED_LINK identifies a foreign key or primary key that links | |
| two module component inclusions, and also indicates which table usage | |
| in each module component inclusion is the subject of the link. | |
| Note that it is necessary for a key based link to include details of | |
| precisely which table usages are involved in each module component | |
| inclusion because links are not always between base tables. Neither | |
| is this information derivable from the foreign key or primary key | |
| specified, since any table may have more than one usage. | |
| The two module component inclusions involved in a key based link may | |
| be in the same module or in different modules. | |
| Sub-type of | MODULE_COMPONENT_LINK |
| Versioning: | Belongs to: GENERAL_MODULE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
MCN_REFERENCE_FROM MCN_REFERENCE_TO |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_MCL |
| Changes: | Summary of changes to KEY_BASED_LINK in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| JOIN_CONSTRAINT_REFERENCE | N | Prompt: Join Constraint | Must be via one and only one JOIN_CONSTRAINT | 33 |
| PRIMARY_KEY_REFERENCE | N | Prompt: Primary Key | Must be via one and only one PRIMARY_KEY_CONSTRAINT | 33 |
| MCN_REFERENCE_FROM | N |
Prompt: From Module Component
Transferable only if null Defined on MCL supertype |
Must be from one and only one MODULE_COMPONENT_INCLUSION | |
| MCN_REFERENCE_TO | N |
Prompt: To Module Component
Transferable only if null Defined on MCL supertype |
Must be to one and only one MODULE_COMPONENT_INCLUSION | |
| MODULE_REFERENCE_FROM | N |
Not displayed
System maintained Not transferable Defined on MCL supertype |
Must be from one and only one GENERAL_MODULE | |
| MODULE_REFERENCE_TO | N |
Not displayed
System maintained Not transferable Defined on MCL supertype |
Must be to one and only one GENERAL_MODULE | |
| TABLE_USAGE_REFERENCE_FROM | N | Prompt: From Table Usage | Must be from one and only one MODULE_DETAIL_TABLE_USAGE | |
| TABLE_USAGE_REFERENCE_TO | N | Prompt: To Table Usage | Must be to one and only one MODULE_DETAIL_TABLE_USAGE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| FK_ON_FROM_COMPONENT_FLAG | VARCHAR2(1) | N | Indicates whether foreign key is on 'from' component (Y) or 'to' component. Only relevent when from/to DTU's in the KEY_BASED_LINK are based on same underlying table, otherwise location of foreign key is clear and this property is ignored
Prompt: FKey on 'From' Component ? Uppercase | YESNO | N |
| KEY_BASED_LINK_VIA | VARCHAR2(3) | N | Arc 33 discriminator. Indicates whether the KEY_BASED_LINK is via a FOREIGN_KEY_CONSTRAINT or via a PRIMARY_KEY_CONSTRAINT
Not displayed Uppercase System maintained Not updatable by user | KEY_BASED_LINK_VIA | |
| 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 Defined on MCL supertype | MODULE_COMPONENT_LINK_TYPE | |
| SQL_QUERY_CLAUSE | VARCHAR2(10) | N | Identifies where the join condition is used
Prompt: SQL Query Clause Uppercase Defined on MCL supertype | 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 Defined on MCL supertype |
Description |
| NOTES | CDINOT Defined on MCL supertype |
Notes |
| Other Properties |
|---|
| KEY_BASED_LINK 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 KEY_BASED_LINK:
Note: