Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | QUEUE_TABLE_IMPLEMENTATION |
| Short Name | QTI |
| View Name | CI_QUEUE_TABLE_IMPLEMENTATIONS |
| Description | The implementation of a queue table in a specific schema |
| Sub-type of | DB_OBJECT_IMPLEMENTATION |
| Versioning: | Belongs to: NON_ORACLE_DATABASE versionable object ORACLE_DATABASE versionable object |
| Rules: |
API Spec Uniqueness Criteria Deletion Rules |
| Descriptor: |
DATABASE_USER_REFERENCE QUEUE_TABLE_DEF_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DOI |
| Reference Properties | ||||
|---|---|---|---|---|
| Name | Opt ? | Notes | Relationship | In Arc |
| DATABASE_USER_REFERENCE | N |
Prompt: Database User
Transferable only if null Defined on DOI supertype |
Must be in schema of one and only one DATABASE_USER | |
| QUEUE_TABLE_DEF_REFERENCE | N |
Prompt: Queue Table
Transferable only if null |
Must be an implementation of one and only one QUEUE_TABLE_DEFINITION | |
| ORACLE_TYPE_DBU_REFERENCE | Y | Prompt: Database User of Oracle Type | May be referencing an Oracle type owned by one and only one DATABASE_USER | |
| STORAGE_DEFINITION_REFERENCE | Y | Prompt: Storage Definition | May be limited by one and only one STORAGE_DEFINITION | |
| TABLESPACE_REFERENCE | Y | Prompt: Tablespace | May be created in one and only one TABLESPACE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| COMPLETE_FLAG | VARCHAR2(1) | N | Indicates whether the definition of the database object is complete and ready to be used by the generators
Prompt: Complete ? Uppercase Defined on DOI supertype | YESNO | Y |
| INITIAL_TRANSACTION | NUMBER(3, 0) | Y | The initial number of transaction entries that are allocated
Prompt: Init Trans Range: 1 to 255 | ||
| MAXIMUM_TRANSACTION | NUMBER(3, 0) | Y | Maximum number of transactions that may update a block concurrently
Prompt: Max Trans Range: 1 to 255 | ||
| OBJECT_IMPLEMENTATION_TYPE | VARCHAR2(3) | N | Sub-type discriminator. Internal property indicating whether the DB_OBJECT_IMPLEMENTATION is a TABLE_IMPLEMENTATION (TBI), VIEW_IMPLEMENTATION (VWI), SNAPSHOT_IMPLEMENTATION (SNI), SEQUENCE_IMPLEMENTATION (SQI) etc
Not displayed Uppercase System maintained Not updatable by user Defined on DOI supertype | OBJECT_IMPLEMENTATION_TYPE | |
| PERCENT_FREE | NUMBER(3, 0) | Y | Amount of free space (as a percentage) in a block that is allocated to the table
Prompt: Percent Free Range: 0 to 99 | ||
| PERCENT_USED | NUMBER(3, 0) | Y | Minimum level of space (as a percentage) in a block that ORACLE maintains for each block
Prompt: Percent Used Range: 1 to 99 | ||
| 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 |
| IMPLEMENTATION_DESCRIPTION | IMPDSC Defined on DOI supertype |
Implementation Description |
| IMPLEMENTATION_NOTES | IMPNOT Defined on DOI supertype |
Implementation Notes |
| Other Properties |
|---|
| QUEUE_TABLE_IMPLEMENTATION 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 QUEUE_TABLE_IMPLEMENTATION:
Note: