Element Type Definition: SEQUENCE

Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name	SEQUENCE
Short Name	OSQ
View Name	CI_SEQUENCES
Description	Definition of a database sequence to supply a serial list of unique
	numbers

Sub-type of	SHAREABLE_ELEMENT
Versioning:	Structure of SEQUENCE versionable object
Rules:	API Spec Uniqueness Criteria Deletion Rules
Descriptor:	NAME
Used by:	Oracle Designer
Underlying table:	SDD_OSQ
Changes:	Summary of changes to SEQUENCE in Release 6i

Reference Properties
Name	Opt ?	Notes	Relationship	In Arc

Properties
Name	Datatype	Opt ?	Notes	Domain	Default Value
NAME	VARCHAR2(30)	N	The name of this ORACLE sequence. Prompt: Name Uppercase
PURPOSE	VARCHAR2(70)	Y	Brief description of the purpose of this sesquence Prompt: Purpose
REMARK	VARCHAR2(2000)	Y	A comment on this sequence. Prompt: Comment
SEQUENCE_TYPE	VARCHAR2(1)	N	Specifies whether the sequence is implemented as a row in a code controls table or as an ORACLE sequence. Prompt: Code Control ? Uppercase	OSQ_SEQUENCE_TYPE	O

Multi-line Text
Name	Text Type	Prompt
DESCRIPTION	CDIDSC	Description
NOTES	CDINOT	Notes

Other Properties
SEQUENCE 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: ID IRID IVID ELEMENT_TYPE_NAME DATE_CREATED CREATED_BY DATE_CHANGED CHANGED_BY NUMBER_OF_TIMES_MODIFIED TYPES

Other element types that reference SEQUENCE:

Each FOLDER_MEMBER must be of one and only one FOLDERED_ELEMENT
Each COLUMN may be based on one and only one SEQUENCE
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_SYNONYM must be for one and only one SEQUENCE (in arc)
Each SET_MEMBER_ITEM must be of one and only one PRIMARY_ACCESS_ELEMENT (in arc)
Each SERVER_OBJECT_USAGE must be for generation of one and only one CIELEMENT (in arc)
Each SEQUENCE_IMPLEMENTATION must be an implementation of one and only one SEQUENCE
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