Oracle Designer Model,
Release 6i
Element Type Definition
| Element Type Name | SEQUENCE_IMPLEMENTATION |
| Short Name | SQI |
| View Name | CI_SEQUENCE_IMPLEMENTATIONS |
| Description | The implementation of a sequence 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 SEQUENCE_REFERENCE |
| Used by: |
Oracle Designer |
| Underlying table: | SDD_DOI |
| Changes: | Summary of changes to SEQUENCE_IMPLEMENTATION in Release 6i |
| 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 | |
| SEQUENCE_REFERENCE | N |
Prompt: Sequence
Transferable only if null |
Must be an implementation of one and only one SEQUENCE | |
| Properties | |||||
|---|---|---|---|---|---|
| Name | Datatype | Opt ? | Notes | Domain | Default Value |
| CACHE_VALUE | NUMBER(38, 0) | Y | Specifies a pre-allocation of sequence numbers that can be cached in memory.
Prompt: Cache 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 |
| CYCLE | VARCHAR2(1) | N | Indicates whether or not the sequence is cyclical
Prompt: Cycle ? Uppercase | YESNO | N |
| GLOBAL_SYNONYM_NAME | VARCHAR2(30) | Y | Name to be used by Server Generator when creating synonyms for this object
Prompt: Global Synonym Name Uppercase | ||
| INCREMENT_VALUE | NUMBER(38, 0) | Y | The number by which the sequence is incremented
Prompt: Increment | ||
| MAXIMUM_VALUE | NUMBER(38, 0) | Y | Specifies the maximum value for the sequence
Prompt: Maximum | ||
| MINIMUM_VALUE | NUMBER(38, 0) | Y | Specifies the minimum value the sequence will generate
Prompt: Minimum | ||
| 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 | |
| SCOPE | VARCHAR2(8) | N | Scope of visibility of the database object, used by the Server Generator to determine when database links and synonyms need to be created
Prompt: Scope Uppercase | DB_OBJECT_SCOPE | DATABASE |
| SORTING_ORDER | VARCHAR2(1) | N | Indicates whether or not the sequence numbers should be generated in the order of request
Prompt: Order ? Uppercase | YESNO | N |
| START_VALUE | NUMBER(38, 0) | Y | Specifies the first sequence number to be created
Prompt: Start | ||
| 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 |
|---|
| SEQUENCE_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 SEQUENCE_IMPLEMENTATION:
Note: