Enterprise Architect: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 2: | Line 2: | ||
* https://en.wikipedia.org/wiki/Enterprise_Architect_(software) | * https://en.wikipedia.org/wiki/Enterprise_Architect_(software) | ||
* https://www.sparxsystems.de/enterprise-architect/ | * https://www.sparxsystems.de/enterprise-architect/ | ||
= Database Schema = | |||
== Core Tables == | |||
<uml> | |||
hide methods | |||
hide stereotypes | |||
hide circle | |||
skinparam classAttributeIconSize 0 | |||
package "Core Tables" { | |||
class t_package { | |||
Package_ID INTEGER | |||
Parent_ID INTEGER | |||
Name TEXT | |||
ea_guid TEXT | |||
} | |||
class t_object { | |||
Object_ID INTEGER | |||
Package_ID INTEGER | |||
Object_Type TEXT | |||
Name TEXT | |||
ea_guid TEXT | |||
} | |||
class t_attribute { | |||
ID INTEGER | |||
Object_ID INTEGER | |||
Name TEXT | |||
Type TEXT | |||
Scope TEXT | |||
ea_guid TEXT | |||
} | |||
class t_operation { | |||
OperationID INTEGER | |||
Object_ID INTEGER | |||
Name TEXT | |||
Type TEXT | |||
ea_guid TEXT | |||
} | |||
class t_operationparams { | |||
OperationID INTEGER | |||
Name TEXT | |||
Type TEXT | |||
Pos INTEGER | |||
} | |||
class t_connector { | |||
Connector_ID INTEGER | |||
Start_Object_ID INTEGER | |||
End_Object_ID INTEGER | |||
Connector_Type TEXT | |||
SourceCard TEXT | |||
DestCard TEXT | |||
} | |||
} | |||
package "Tagged Value Tables" { | |||
class t_objectproperties { | |||
PropertyID INTEGER | |||
Object_ID INTEGER | |||
Property TEXT | |||
Value TEXT | |||
} | |||
class t_attributetag { | |||
PropertyID INTEGER | |||
ElementID INTEGER | |||
Property TEXT | |||
VALUE TEXT | |||
} | |||
class t_operationtag { | |||
PropertyID INTEGER | |||
ElementID INTEGER | |||
Property TEXT | |||
VALUE TEXT | |||
} | |||
class t_connectortag { | |||
PropertyID INTEGER | |||
ElementID INTEGER | |||
Property TEXT | |||
VALUE TEXT | |||
} | |||
} | |||
t_package "1" --> "0..*" t_package : Parent_ID | |||
t_package "1" --> "0..*" t_object : Package_ID | |||
t_object "1" --> "0..*" t_attribute : Object_ID | |||
t_object "1" --> "0..*" t_operation : Object_ID | |||
t_operation "1" --> "0..*" t_operationparams : OperationID | |||
t_connector --> t_object : Start_Object_ID | |||
t_connector --> t_object : End_Object_ID | |||
t_object "1" --> "0..*" t_objectproperties : Object_ID | |||
t_attribute "1" --> "0..*" t_attributetag : ElementID | |||
t_operation "1" --> "0..*" t_operationtag : ElementID | |||
t_connector "1" --> "0..*" t_connectortag : ElementID | |||
</uml> | |||
Revision as of 06:27, 13 February 2026
Links
- https://en.wikipedia.org/wiki/Enterprise_Architect_(software)
- https://www.sparxsystems.de/enterprise-architect/
Database Schema
Core Tables