MID - the modeling company Home Search Tcl Script Help Tcl Script Help Contact Support

Views for ER Entities (ERMEntity)


ProjectModel

OWN Model of the ERM entity.

Package

OWN Package of the ERM Entity.

ERMEntity

OWN The ER entity itself.
ER_FOREIGN_KEY All ER entities that have a foreign key attribute referencing the primary key of the actual ERM entity.
ALL All ER entities that are connected to the actual entity by a relationship; if refentity (entity type of refentity is ERDiagram) is set only the found ERM entities not displayed in diagram refentity.
ER_VALID All ER entities that are needed to resolve datatype of foreign key attributes

ERMDBEntity

ALL All ERM DB entities.
OWN All ERM DB entities.
ER_MASTER Master ERM DB entity.

ERDiagram

ALL All diagrams with an entity node of the ER entity; if kind is given only those with the given kind; if refentity is given, remove the diagram refentity from the result list.
OWN Diagram refentity if it has an entity node of the ER entity.

ERDEntity

ALL All entity nodes of the ER entity.
MAINT_GLOBAL All entity nodes of the ERM entity with global maintenance.
MAINT_LOCAL All entity nodes of the ERM entity with local maintenance.
MAINT_GLOBAL_LOCAL All entity nodes of the ERM entity with global or local maintenance.
OWN Entity nodes of the ERM entity in diagram refentity.

ERMEntRs

ALL All ER entity relationship connections.
SONS All ER entity roles for version object
OWN ER entity relationship connection between given ER entity and ER relationship refentity.
ER_ALL_11 All ER entity relationship connections that should have a foreign key - (1,1) but no generalization, no direct cycle.
ER_FOREIGN_KEY All ER entity relationship connections that should have a foreign key - (1,1) but no generalization.
ER_LEFT All 'left' ER entity relationship connections.
OTH All ER entity relationship connections on the other side of the entity.

ERMRelationship

NAME ER relationship with name pattern between the given ERM entity and the ERM entity refentity (if refentity is not given, all ER relationships with name pattern between the given ERM entity and other entities).
ALL All ER relationships between the given ERM entity and other entities not displayed in diagram refentity (if the entity type of refentity is ERDiagram) or all ER relationships between the given ERM entity and ERM entity refentity (if the entity type of refentity is ERDEntity or ERMEntity).

ERMDBTable

OWN ERM DB table directly derived from ERM entity.
OTH All ERM DB tables not directly derived from ERM entity but referencing entities of the ERM DB table directly derived from ERM entity.
ALL All ERM DB tables either directly derived from ERM entity or not directly derived from ERM entity but referencing entities of the ERM DB table.

ERMAttribute

ALL All ERM attributes of the entity (sorted).
PAT All ERM attributes of the entity matching pattern (sorted).
ER_UNIQUENAME All ERM attributes of the entity using pattern as short or long name.
ER_PRIMARY_KEY All primary key attributes of the entity (sorted).
ER_FOREIGN_KEY All foreign key attributes of the entity (if kind == 1 only the foreign key attributes not assigned to a relation).
ER_LOCAL All local attributes of the entity (sorted).
ER_LOCAL_NOTNULL All local notnull attributes of the entity (sorted).
ER_LOCAL_NULL All local null attributes of the entity (sorted).

ERMTable

OWN ERM table to ERM entity.

ERMDBVFrom

ALL ALL database view from clauses using this database table.

ERMPrimKey

OWN Primary key of ERM DB table directly derived from ER entity.

ERMForKey

ALL Foreign keys of ERM DB table directly derived from ER entity.

ERConTab

ALL All ERM table constraints of the ERM entity.

ERConstraint

ALL ALL ER constraints used in ERM entity.

ERMDataElement

ALL All ERM data elements of ERM attributes of this DD view.

DDView

ALL All views using the actual ERM entity in the actual ProjectModel (if refentity not set) or in the ProjectModel refentity (otherwise).

DDEntity

ALL All view entities to the actual ERM entity in the actual ProjectModel (if refentity not set) or in the ProjectModel refentity (otherwise).

DDComponent

ALL All view components to the actual ERM entity in the actual ProjectModel (if refentity not set) or in the ProjectModel refentity (otherwise).