org.orange.kicsa.integration.employee
ER Diagram Employe (MySQL)

Target server mySQL_3_23
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