Oracle Designer Model, Release 6i
Element Type Definition

Element Type Name PARTITION_KEY_ENTRY
Short Name TBICOL
View NameCI_PARTITION_KEY_ENTRIES
Description A PARTITION_KEY_ENTRY represents the usage of a particular column
in the partition key of a table or index
Sub-type of INTERSECTION
Versioning: Belongs to:
NON_ORACLE_DATABASE versionable object
ORACLE_DATABASE versionable object
Rules: API Spec
Uniqueness Criteria
Deletion Rules
Descriptor: TABLE_IMPLEMENTATION_REFERENCE
INDEX_STORAGE_REFERENCE
COLUMN_REFERENCE
Used by: Oracle Designer

Underlying table:SDD_TBICOL
Changes: Summary of changes to PARTITION_KEY_ENTRY in Release 6i

Reference Properties
Name Opt ? Notes Relationship In Arc
INDEX_STORAGE_REFERENCE N Prompt: Global Index
Transferable only if null 		Must be in partition key of one and only one INDEX_STORAGE 61
TABLE_IMPLEMENTATION_REFERENCE N Prompt: Table Implementation
Transferable only if null 		Must be in partition key of one and only one TABLE_IMPLEMENTATION 61
COLUMN_REFERENCE N Prompt: Column
Transferable only if null 		Must be based on one and only one COLUMN

Properties
Name Datatype Opt ? Notes Domain Default Value
PARTITION_KEY_FOR VARCHAR2(3) N Arc 61 discriminator. Indicates whether in partition key of a table or index
Not displayed
Uppercase
System maintained
Not updatable by user 		PKE_FOR
SEQUENCE_NUMBER NUMBER(6, 0) N Sequence of column in partition key of the table or index
Prompt: Sequence in Key
System maintained: API provides a value only if left null by the user
PARENT_IVID NUMBER(38, 0) Y Internal use only. Common repository version identifier of owning PAC
Not displayed
System maintained
Updatable only if null
Defined on SE supertype
PAC_REFERENCE NUMBER(38, 0) Y Internal use only. Contains the IRID of the PAC for the "versionable object" to which this element belongs
Not displayed
System maintained
Not updatable by user
Defined on SE supertype

Multi-line Text
Name Text Type Prompt

Other Properties
PARTITION_KEY_ENTRY 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 PARTITION_KEY_ENTRY:


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
    •