Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | MODULE_DETAIL_TABLE_USAGE |
| Short Name | MTI |
| View Name | CI_MODULE_DETAIL_TABLE_USAGES |
| Description | A "detail" usage of a table by a GENERAL_MODULE |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: GENERAL_MODULE versionable object REUSABLE_LOV versionable object REUSABLE_MCO versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
MODULE_UNIT_REFERENCE SQL_QUERY_SET_REFERENCE TABLE_REFERENCE ALIAS |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_MTI |
| Changes: | Summary of changes to MODULE_DETAIL_TABLE_USAGE in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| MODULE_UNIT_REFERENCE | N | Prompt: Module Unit | Must be within one and only one MODULE_UNIT | 85 |
| SQL_QUERY_SET_REFERENCE | N | Prompt: SQL Query Set | Must be within one and only one SQL_QUERY_SET | 85 |
| TABLE_REFERENCE | N |
Prompt: Table/View/Materialized View
Transferable only if null |
Must be of one and only one RELATION_DEFINITION | |
| CONSTRAINT_REFERENCE | Y | Prompt: Via Join Constraint | May be linked via one and only one JOIN_CONSTRAINT | |
| CONSTRAINT_REFERENCE2 | Y | Prompt: Via Network Join Constraint | May be tree walked via table using one and only one JOIN_CONSTRAINT | |
| MTI_REFERENCE | Y | Prompt: Link To | May be linked from one and only one MODULE_DETAIL_TABLE_USAGE | |
| TREEWALK_JOIN_CONSTRAINT | Y | Prompt: Via Pig's Ear Join Constraint | May be tree walked using one and only one JOIN_CONSTRAINT | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| ALIAS | VARCHAR2(30) | N | Alias by which this table usage is identified
Prompt: Usage Alias Uppercase System maintained: API provides a value only if left null by the user | ||
| MTI_FOR | VARCHAR2(3) | N | Arc 85 discriminator. Indicates whether this MTI (DTU) is within a MODULE_UNIT or a SQL_QUERY_SET
Not displayed Uppercase System maintained Not updatable by user | MTI_FOR | |
| NAME_IN_DATABASE | VARCHAR2(100) | Y | Name to be used by generators instead of table/view/snapshot name. Always used with no user/schema prefix regardless of preferences. Free format text but suggested list is the GLOBAL_SYNONYM_NAMEs for all implementations of the relation
Prompt: Name in Database Uppercase | ||
| NOT_EXISTS_FLAG | VARCHAR2(1) | N | Applicable to sub-queries only, and indicates whether the sub-query should be a logical 'NOT EXISTS'
Prompt: Not Exists ? Uppercase | YESNO | N |
| OUTER_JOIN_FLAG | VARCHAR2(1) | N | Indicates whether or not the link is to use an outer join condition. This only has relevance in the context of 'lookup' usages.
Prompt: Outer Join ? Uppercase | YESNODEF | D |
| PARTITION_NAME | VARCHAR2(30) | Y | Name of partition to which use of table to be restricted
Prompt: Partition Uppercase | ||
| REMARK | VARCHAR2(240) | Y | A comment on the use of this table by the module.
Prompt: Comment | ||
| REPORT_USAGE_TYPE | VARCHAR2(6) | Y | For internal use only. Used to capture the DTU usage type as interpreted by the reports generator (more values than BASE and LOOKUP). Intended to aid conversion to releases 2 of Designer/2000, and hence due to be dropped in release 2.
Not displayed Uppercase | ||
| SELECT_DISTINCT_FLAG | VARCHAR2(1) | N | Indicates whether the query is required to do SELECT DISTINCT. Applies to base tables only
Prompt: Select Distinct ? Uppercase | YESNO | N |
| TREEWALK_DIRECTION | VARCHAR2(4) | N | Direction of the treewalk. Applicable to both "normal" and network treewalks
Prompt: Direction Uppercase | TREEWALK_DIRECTION | DOWN |
| USAGE_TYPE | VARCHAR2(6) | Y | The type of the detailed table usage - base, lookup, sub-query or single row SQL aggregate
Prompt: Usage Type Uppercase | MTI_USAGE_TYPE | |
| 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 |
| CONNECT_BY_CLAUSE | CONNEC | Connect By Clause |
| DESCRIPTION | CDIDSC | Description |
| NOTES | CDINOT | Notes |
| QUERY_WHERE_CLAUSE | CDWHCL | WHERE Clause of Query |
| START_WITH_CLAUSE | STWITH | Start With Clause |
| VALIDATION_WHERE_CLAUSE | LVWHCL | Validation WHERE Clause |
| Other Properties |
|---|
| MODULE_DETAIL_TABLE_USAGE 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 MODULE_DETAIL_TABLE_USAGE:
Note: