<default>
ER Diagram ER-Modell DB Belegung

Target server oracle_7
ER-Entity Summary
BELEGUNG 
RAUMPLAN 
 

Diagram Elements Detail

BELEGUNG

Primary Key Name SYS_C001574
rdbOldLogicalName BELEGUNG
internalPhysicalName BELEGUNG
ER-Attribute Summary
BEGINN 
DOZENT 
ENDE 
ID 
ID_RAUM 
VORLESUNGSBEZEICHNUNG 
WOCHENTAG 
 

BELEGUNG Members Detail

BEGINN

Generic jdbc name of correspondent column type TIMESTAMP
internalNotNull
internalSize 7
rdbOldLogicalName BEGINN
internalPhysicalName BEGINN
internalPhysicalType DATE

DOZENT
Generic jdbc name of correspondent column type VARCHAR
internalSize 20
rdbOldLogicalName DOZENT
internalPhysicalName DOZENT
internalPhysicalType VARCHAR2

ENDE
Generic jdbc name of correspondent column type TIMESTAMP
internalNotNull
internalSize 7
rdbOldLogicalName ENDE
internalPhysicalName ENDE
internalPhysicalType DATE

ID
Is Primary Key
Generic jdbc name of correspondent column type DECIMAL
internalPhysicalType NUMBER
internalSize 22
internalPhysicalName ID
internalNotNull
rdbOldLogicalName ID

ID_RAUM
Is Primary Key
Generic jdbc name of correspondent column type DECIMAL
Referenced Attribute ID
Foreign Link SYS_C001575
internalPhysicalType NUMBER
internalSize 22
internalPhysicalName ID_RAUM
internalNotNull
rdbOldLogicalName ID_RAUM

VORLESUNGSBEZEICHNUNG
Generic jdbc name of correspondent column type VARCHAR
internalSize 100
rdbOldLogicalName VORLESUNGSBEZEICHNUNG
internalPhysicalName VORLESUNGSBEZEICHNUNG
internalPhysicalType VARCHAR2

WOCHENTAG
Generic jdbc name of correspondent column type VARCHAR
internalNotNull
internalSize 10
rdbOldLogicalName WOCHENTAG
internalPhysicalName WOCHENTAG
internalPhysicalType VARCHAR2

ER-Relationship Links

to ER-Entity RAUMPLAN

Verb phrase SYS_C001575
Identifying
rdbOldLogicalName SYS_C001575
internalPhysicalName SYS_C001575

RAUMPLAN

Primary Key Name SYS_C001568
rdbOldLogicalName RAUMPLAN
internalPhysicalName RAUMPLAN
ER-Attribute Summary
ID 
JAHR 
RAUM 
SEMESTER 
 

RAUMPLAN Members Detail

ID

Is Primary Key
Generic jdbc name of correspondent column type DECIMAL
internalPhysicalType NUMBER
internalSize 22
internalPhysicalName ID
internalNotNull
rdbOldLogicalName ID

JAHR
Generic jdbc name of correspondent column type DECIMAL
internalNotNull
internalSize 4
rdbOldLogicalName JAHR
internalPhysicalName JAHR
internalPhysicalType NUMBER

RAUM
Generic jdbc name of correspondent column type VARCHAR
internalNotNull
internalSize 10
rdbOldLogicalName RAUM
internalPhysicalName RAUM
internalPhysicalType VARCHAR2

SEMESTER
Generic jdbc name of correspondent column type VARCHAR
internalNotNull
internalSize 2
rdbOldLogicalName SEMESTER
internalPhysicalName SEMESTER
internalPhysicalType VARCHAR2