Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | DATABASE_SYNONYM |
| Short Name | DSY |
| View Name | CI_DATABASE_SYNONYMS |
| Description | A database synonym for a database object |
| Sub-type of | SECONDARY_ACCESS_ELEMENT |
| Versioning: | Belongs to: JAVA_MODULE versionable object ORACLE_OBJECT_TYPE versionable object SEQUENCE versionable object SNAPSHOT_DEFINITION versionable object TABLE_DEFINITION versionable object VIEW_DEFINITION versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
TABLE_DEFINITION_REFERENCE VIEW_DEFINITION_REFERENCE SNAPSHOT_DEFINITION_REFERENCE SEQUENCE_REFERENCE PLSQL_MODULE_REFERENCE JAVA_MODULE_REFERENCE NAME |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DSY |
| Changes: | Summary of changes to DATABASE_SYNONYM in Release 6i |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| JAVA_MODULE_REFERENCE | N |
Prompt: Java Class Definition
Transferable only if null |
Must be for one and only one JAVA_MODULE | 12 |
| PLSQL_MODULE_REFERENCE | N |
Prompt: PL/SQL Definition
Transferable only if null |
Must be for one and only one PLSQL_MODULE | 12 |
| SEQUENCE_REFERENCE | N |
Prompt: Sequence
Transferable only if null |
Must be for one and only one SEQUENCE | 12 |
| SNAPSHOT_DEFINITION_REFERENCE | N |
Prompt: Materialized View
Transferable only if null |
Must be for one and only one SNAPSHOT_DEFINITION | 12 |
| TABLE_DEFINITION_REFERENCE | N |
Prompt: Table
Transferable only if null |
Must be for one and only one TABLE_DEFINITION | 12 |
| VIEW_DEFINITION_REFERENCE | N |
Prompt: View
Transferable only if null |
Must be for one and only one VIEW_DEFINITION | 12 |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| COMPLETE_FLAG | VARCHAR2(1) | N | Indicates whether the definition of this object is complete and ready to be used by the generators
Prompt: Complete ? Uppercase | YESNO | Y |
| NAME | VARCHAR2(30) | N | Another name by which the database object is known.
Prompt: Name Uppercase | ||
| SCOPE | VARCHAR2(10) | N | Indicates whether the synonym is PUBLIC or PRIVATE
Prompt: Scope Uppercase | PGD_SCOPE | PUBLIC |
| SYNONYM_FOR | VARCHAR2(3) | N | Arc 12 discriminator. Indicates what the arc points at (VW, TBL, SNP etc)
Not displayed Uppercase System maintained Not updatable by user | DATABASE_SYNONYM_FOR | |
| 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 |
|---|
| DATABASE_SYNONYM 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 DATABASE_SYNONYM:
Note: