Oracle Designer Model, Release 6i
Element Type Definition


Element Type Name CLASSIFIER_ATTRIBUTE
Short Name CAT
View NameCI_CLASSIFIER_ATTRIBUTES
Description A specific detail of the classifier to which it belongs
Sub-type of SECONDARY_ACCESS_ELEMENT
Non-instantiable super-type of ENTITY_OBJECT_ATTRIBUTE
GENERAL_ATTRIBUTE
VIEW_OBJECT_ATTRIBUTE
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_CAT

Reference Properties
Name Opt ? Notes Relationship In Arc
CLASSIFIER_REFERENCE Y Prompt: Classifier Datatype May be of datatype of one and only one CLASSIFIER

Properties
Name Datatype Opt ? Notes Domain Default Value
CHANGE_RESTRICTION VARCHAR2(8) N Indicates whether the value may be modified after the object is created and, if so, what restrictions apply
Prompt: Change Restriction
Uppercase
CHANGE_RESTRICTION NONE
CLASSIFIER_ATTRIBUTE_SUBTYPE VARCHAR2(3) N Sub-type discriminator. Internal property indicating whether the attribute is an entity object attribute (EAT) or a general attribute (GAT)
Not displayed
Uppercase
System maintained
Not updatable by user
CLASSIFIER_ATTRIBUTE_SUBTYPE
DATATYPE_FORMAT VARCHAR2(10) N Internal property acting as "logical arc discriminator" between SCALAR_DATATYPE and CLASSIFIER_REFERENCE, indicating which is populated. These are both optional, but one or other MUST be specified
Not displayed
Uppercase
System maintained
Not updatable by user
DATATYPE_FORMAT
DECIMAL_PLACES NUMBER(4, 0) Y For numeric datatypes, specifies the number of decimal places allowed for this attribute
Prompt: Decimal Places
DEFAULT_VALUE VARCHAR2(2000) Y Default value for the attribute. If the attribute is an array, the default values are held as a comma separated list
Prompt: Default Value
MAXIMUM_LENGTH NUMBER(5, 0) Y Maximum length of data that this attribute can contain
Prompt: Maximum Length
MAXIMUM_MULTIPLICITY VARCHAR2(10) N Maximum multiplicity of the attribute. A value of 1 indicates a single attribute, whereas a value > 1 or '*' indicates an array
Prompt: Maximum Multiplicity
1
MINIMUM_MULTIPLICITY NUMBER(10, 0) N Minimum multiplicity of the attribute. A value of 0 indicates the attribute is optional, 1 (or more) that it is mandatory
Prompt: Minimum Multiplicity
0
NAME VARCHAR2(100) N Name of the attribute
Prompt: Name
PROMPT VARCHAR2(132) Y Prompt to be used when displaying this attribute
Prompt: Prompt
RETRIEVABLE_FLAG VARCHAR2(1) N Indicates whether user is allowed to access the values stored in this attribute. If the attribute has a datatype of a domain then the equivalent property on the domain determines whether the attribute is queryable
Prompt: Is Retrievable
Uppercase
YESNO Y
SCALAR_DATATYPE VARCHAR2(15) Y Scalar datatype of the attribute, where datatype not defined as a classifier
Prompt: Scalar Datatype
SCALAR_DATATYPE
SEQUENCE NUMBER(6, 0) N Sequence for use by the transformers, indicating the position of this attribute among other attributes for the same classifier
Prompt: Sequence in Classifier
System maintained: API provides a value only if left null by the user
SERIALIZABLE_FLAG VARCHAR2(1) N Indicates, in Java, whether the attribute is part of the persistent state of the object and will be serialized with the object
Prompt: Is Serializable
Uppercase
YESNO N
STATIC_FLAG VARCHAR2(1) N Indicates whether the attribute is a "class attribute", ie at the class level with only a single value for all instances
Prompt: Is Static
Uppercase
YESNO N
UPDATABLE_FLAG VARCHAR2(1) N Indicates whether the user is allowed to update the values stored in this attribute. If the attribute has a datatype of a domain then the equivalent property on the domain determines whether the attribute is updatable
Prompt: Is Updatable
Uppercase
YESNO Y
VISIBILITY VARCHAR2(10) N Visibility of the attribute
Prompt: Visibility
Uppercase
VISIBILITY PRIVATE
VOLATILE_FLAG VARCHAR2(1) N Indicates, in Java, whether the attribute may be accessed by unsynchronized threads and so certain code optimizations must not be performed on it
Prompt: Is Volatile
Uppercase
YESNO N
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
DESCRIPTION CDIDSC Description
NOTES CDINOT 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 CLASSIFIER_ATTRIBUTE:


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