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

Views for ER DB Tables (ERMDBTable)


ProjectModel

OWN Model of the ERM DB table.

Package

OWN Package of the ERM DB Table.

ERMDBTable

OWN The ERM DB table itself (if ERM DB table) or the own or assigned ERM DB table (if ERM DB entity, ERM specimen, ERM table constraint, ERM attribute, ERM primary key, ERM foreign key, ERM index or ERM index attribute).

ERMTabOpt

ALL All DB table options (sorted).
ALLTRG All DB table options of target system pattern.
TRG DB table option named pattern of target system refentity.

ERMEntity

OWN ERM entity (same ERM table).
ALL All ERM entities used in ERM DB table.
OTH All ERM entities used in ERM DB table.

ERMRelationship

ER_MERGE all ERM relationships of which the name is stored in one of the ERM specimens.

ERMDBEntity

OWN ERM DB entity (connection of ERM entity to ERM DB table) to ERM entity refentity.
ALL All ERM DB entities (connections of ERM entity to ERM DB tables).
ER_MASTER ERM DB entity (connection of ERM entitiy to ERM DB table) to the ERM entity with the same ERM table like the ERM DB table.

ERMSpecimen

ALL All ERM specimen in ERM DB table.

ERMTable

OWN ERM table to ERM DB table.

ERMAttribute

ALL All ERM attributes in ERM DB table (sorted).
SONS All ERM attributes used by at least one of the ERM attributes in ERM DB table.
ER_PRIMARY_KEY All primary key attributes in ERM DB table (sorted).
ER_FOREIGN_KEY All foreign key attributes in ERM DB table.
ER_UNIQUENAME All ERM attributes of which the short or long name is name.
ER_DSATTR_ONLY All attributes from DS-schema only (sorted).

ERMIndex

ALL All ERM indexes of ERM DB table.
NAME ERM index of ERM DB table of which the name is name.

ERMPrimKey

OWN Primary key of the ERM DB table.
ER_VALID Primary key of the ERM DB table if ERM DB entity to ERM entity where should have a foreign key.

ERMForKey

ALL All foreign keys of the ERM DB table (sorted).
NAME Foreign key of the ERM DB table of which the name is name.

ERMPkFk

ALL All pairs primary key - foreign key in database schema.
ER_NO_FOREIGN All pairs primary key - foreign key in database schema which have no foreign key in database schema.

ERConTab

ALL All ERM table constraints.

ERConstraint

ALL ALL ER constraints used in ERM DB table.

ERDiagram

ALL ALL ERDiagrams of the entities in ERM DB table.
JUMPLIST ALL ERDiagrams of the entities in ERM DB table.

ERMDBView

ALL ALL database views using this database table.

ERMDBVFrom

ALL ALL database view from clauses using this database table.

ERMEntRs

ER_NO_FOREIGN All ERM entity relationship connections that should inherit a foreign key but do not.
ER_FOREIGN_KEY All ERM entity relationship connections that should inherit a foreign key.
ER_VALID All ER entities that are needed to resolve datatype of foreign key attributes