Element Type Definition: QUEUE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	QUEUE_IMPLEMENTATION
Short Name	QUI
View Name	CI_QUEUE_IMPLEMENTATIONS
Description	The implementation of a queue in an Oracle database

Sub-type of	SECONDARY_ACCESS_ELEMENT
Non-instantiable super-type of	QUEUE_NP_IMPLEMENTATION
	QUEUE_P_IMPLEMENTATION

	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_QUI

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc
ORACLE_DATABASE_REFERENCE	N	Prompt: Oracle Database Transferable only if null	Must be defined in one and only one ORACLE_DATABASE

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
COMPLETE_FLAG	VARCHAR2(1)	N	Indicates whether definition complete and ready to be used by the generators Prompt: Complete ? Uppercase	YESNO	Y
QUEUE_IMPLEMENTATION_SUBTYPE	VARCHAR2(3)	N	Sub-type discriminator. Internal system maintained property indicating the subtype of QUEUE_IMPLEMENTATION Not displayed Uppercase System maintained Not updatable by user	QUEUE_IMPLEMENTATION_SUBTYPE
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	Implementation Description
IMPLEMENTATION_NOTES	IMPNOT	Implementation Notes

Other Properties
The following 'standard' properties are also inherited by all element types: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference QUEUE_IMPLEMENTATION:

Each DIAGRAM_ELEMENT_USAGE must be for one and only one CIELEMENT (in arc)
Each DOCUMENT_ATTACHMENT must be from one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each DATABASE_OBJECT_GRANT must be for one and only one QUEUE_IMPLEMENTATION (in arc)
Each QUEUE_SUBSCRIBER must be a subscriber to one and only one QUEUE_IMPLEMENTATION
Each EXTENDED_STRUCTURE_ELEMENT must be part of one and only one ACCESS_CONTROLLED_ELEMENT (in arc)
Each EXTENDED_STRUCTURE_ELEMENT must be use of one and only one ACCESS_CONTROLLED_ELEMENT

Note:

All properties are displayed and updatable by the user unless indicated otherwise

All reference properties are displayed and transferable unless indicated otherwise

All domains are enforced unless indicated otherwise

All properties and reference properties are defined on this element type unless indicated as inherited from a supertype