org.orange.kicsa.integration.employee
ER Diagram Employee (Oracle)

Target server oracle_7
View physicalView
ER-Entity Summary
employee 
 

Diagram Elements Detail

employee

rdbOldLogicalName employee
internalPhysicalName EMPLOYEE
ER-Attribute Summary
attribute1 
endDate 
entityId 
entityName 
firstName 
id 
lastName 
rights 
 

employee Members Detail

attribute1

Is Primary Key
rdbOldLogicalName attribute1
internalPhysicalName ID

endDate
Generic jdbc name of correspondent column type DATE
internalDigits 0
internalSize 10
rdbOldLogicalName endDate
internalPhysicalName END_DATE
internalPhysicalType date

entityId
Generic jdbc name of correspondent column type VARCHAR
internalDigits 0
internalSize 127
rdbOldLogicalName entityId
internalPhysicalName URI
internalPhysicalType mediumint

entityName
Generic jdbc name of correspondent column type VARCHAR
rdbOldLogicalName entityName
internalSize 100
internalPhysicalName ENTITY_NAME

firstName
Generic jdbc name of correspondent column type VARCHAR
internalDigits 0
internalSize 15
rdbOldLogicalName firstName
internalPhysicalName FIRST_NAME
internalPhysicalType char

id
Generic jdbc name of correspondent column type VARCHAR
internalDigits 0
internalSize 127
rdbOldLogicalName id
internalPhysicalName ENTITY_URI
internalPhysicalType int

lastName
Generic jdbc name of correspondent column type VARCHAR
internalDigits 0
internalSize 20
rdbOldLogicalName lastName
internalPhysicalName LAST_NAME
internalPhysicalType char

rights
Generic jdbc name of correspondent column type CHAR
internalDigits 0
internalSize 127
rdbOldLogicalName rights
internalPhysicalName RIGHTS
internalPhysicalType mediumint