Table diagram

Source object type

Relationship type (active)

Relationship type (passive)

Target object type

Possible number of connections

Application system type (6) (OT_APPL_SYS_TYPE)

is owner of

has owner (271) (CT_IS_OWN)

Table (55) (OT_TBL)

Unique

Domain (physical) (47) (OT_DOM_PHYS)

depicts

is depicted by (84) (CT_DEPICTS_1)

Domain (16) (OT_DOM)

Unique

Field (21) (OT_FLD)

depicts

is depicted by (84) (CT_DEPICTS_1)

Attribute (8) (OT_ATTR)

Unique

Field (21) (OT_FLD)

depicts

is depicted by (84) (CT_DEPICTS_1)

ERM attribute (19) (OT_ERM_ATTR)

Unique

Field (21) (OT_FLD)

depicts

is depicted by (84) (CT_DEPICTS_1)

Relationship type (11) (OT_RELSHP_TYPE)

Unique

Field (21) (OT_FLD)

has

belongs to (96) (CT_HAS_1)

Domain (physical) (47) (OT_DOM_PHYS)

Unique

Field (specimen) (74) (OT_FLD_SPEC)

is of type

determines type of (169) (CT_IS_OF_TYPE_3)

Field (21) (OT_FLD)

Unique

Index (103) (OT_IDX)

is defined by

defines (246) (CT_IS_DEF_BY_1)

Field (21) (OT_FLD)

Unique

Memory location (53) (OT_MEM_LOC)

is assigned to

is assigned to (93) (CT_IS_ASSIG_5)

Field (21) (OT_FLD)

Unique

Memory location (53) (OT_MEM_LOC)

is assigned to

is assigned to (93) (CT_IS_ASSIG_5)

Table (55) (OT_TBL)

Unique

Table (55) (OT_TBL)

depicts

is depicted by (84) (CT_DEPICTS_1)

Entity type (17) (OT_ENT_TYPE)

Unique

Table (55) (OT_TBL)

depicts

is depicted by (84) (CT_DEPICTS_1)

Relation (51) (OT_REL)

Unique

Table (55) (OT_TBL)

depicts

is depicted by (84) (CT_DEPICTS_1)

Relationship type (11) (OT_RELSHP_TYPE)

Unique

Table (55) (OT_TBL)

depicts

is depicted by (84) (CT_DEPICTS_1)

View (57) (OT_VIEW)

Unique

Table (55) (OT_TBL)

has reference to

has reference to (294) (CT_HAS_REF_TO)

Table (55) (OT_TBL)

Unique

Table (55) (OT_TBL)

owns

is part of (95) (CT_OWNS)

Field (21) (OT_FLD)

Unique

Tables (specimen) (73) (OT_TBL_SPEC)

is of type

determines type of (169) (CT_IS_OF_TYPE_3)

Table (55) (OT_TBL)

Unique

View (physical) (75) (OT_VIEW_PHYS)

depicts

is depicted by (84) (CT_DEPICTS_1)

View (57) (OT_VIEW)

Unique

View (physical) (75) (OT_VIEW_PHYS)

reads

is read by (247) (CT_READ_1)

Field (21) (OT_FLD)

Unique

View (physical) (75) (OT_VIEW_PHYS)

reads

is read by (247) (CT_READ_1)

Table (55) (OT_TBL)

Unique

View (physical) (75) (OT_VIEW_PHYS)

reads

is read by (247) (CT_READ_1)

View (physical) (75) (OT_VIEW_PHYS)

Unique