attribute.ent_or_type_nm
This is the domain of the attribute. It points to either the entity, if it is an attribute in the domain of an entity (i.e. is an attribute that represents a relationship), or to a type if in the domain of an ndt, or to an epic_type if in the domain of an EXPRESS simple or Epicentre extension type. This simple type attribute really represents a relationship through a select type. However, this capabality is not availabe in the projection toolkit. For performance reasons this attribute is implemented using a natural key.
fixed_length (M: CHAR(1))
attribute.fixed_length
This is TRUE (Y) if the attribute is fixed length.
is_active (M: CHAR(1))
attribute.is_active
This is TRUE (Y) if the attribute is part of the current subset.
attribute.optionality
This is TRUE (Y) if the attribute is optional.
ent_or_type_code (FNK, M: CHAR(3))
attribute.ent_or_type_code
This is ENT if the attribute is in the domain of an entity, TYP if it is in the domain of an ndt or EPT if it is an epic_type.
Defines a foreign key to table ref_object.
parent_ent (FNK, M: CHAR VARYING(40))
attribute.parent_ent
The entity in which this attribute is defined.
Defines a foreign key to table entity_def.
source_s (FSK, M: CHAR VARYING(19))
attribute.source
The source of this attribute.
Defines a foreign key to table source.
aggr_name (O: CHAR VARYING(15))
attribute.aggr_name
If the attribute is an aggregate this is the name of the aggregate type, e.g. BAG, SET, LIST, ARRAY, UNIQUE LIST, UNIQUE ARRAY.
max_card (O: INTEGER)
attribute.max_card
The "active" maximum cardinality of the attribute, that is the maximum cardinality that is defined for the current subset.
max_length (O: INTEGER)
attribute.max_length
This is the maximum length allowed for the attribute if the attribute is a variable length string.
min_card (O: INTEGER)
attribute.min_card
The minimum cardinality of the attribute if it is an aggregate.
orig_card (O: INTEGER)
attribute.orig_card
The maximum cardinality of the attribute as defined in the full logical schema. If the current subset has not restricted the maximum cardinality of the attribute, then this will have the same value as the max_card.
verb_phrase (O: CHAR VARYING(40))
attribute.verb_phrase
If the attribute represents a relationship, the verb_phrase attribute contains the verb phrase that describes the relationship from this attribute/entity to the attribute/entity it is related to.
forward_s (FSK, O: CHAR VARYING(19))
attribute.forward
This points to the forward attribute that this is an inverse attribute for, if this attribute is an inverse attribute.
Defines a foreign key to table attribute.
redecl_ent_s (FSK, O: CHAR VARYING(19))
attribute.redecl_ent
If this is an attribute that is redeclared, then this points tothe original attribute that this is a redeclaration for.
Defines a foreign key to table entity_def.