Enterprise Architect: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
|||
| (One intermediate revision by the same user not shown) | |||
| Line 102: | Line 102: | ||
t_operation "1" --> "0..*" t_operationtag : ElementID | t_operation "1" --> "0..*" t_operationtag : ElementID | ||
t_connector "1" --> "0..*" t_connectortag : ElementID | t_connector "1" --> "0..*" t_connectortag : ElementID | ||
note right of t_package | |||
Root packages have Parent_ID = 0 | |||
end note | |||
note right of t_object | |||
Object_Type discriminates: | |||
- Class | |||
- Interface | |||
- Package | |||
- Note | |||
etc. | |||
end note | |||
note right of t_connector | |||
Connector_Type: | |||
- Association | |||
- Generalization | |||
- Dependency | |||
- Aggregation | |||
etc. | |||
end note | |||
note bottom of "Tagged Value Tables" | |||
Quirk: Inconsistent naming | |||
- t_objectproperties uses "Value" | |||
- Others use "VALUE" | |||
Quirk: Inconsistent FK columns | |||
- t_objectproperties: Object_ID | |||
- Others: ElementID | |||
end note | |||
</uml> | |||
= Logical Schema = | |||
<uml> | |||
object Model { | |||
Root of hierarchy | |||
Synthetic type | |||
} | |||
object Package { | |||
Name | |||
ea_guid | |||
} | |||
object Class { | |||
Name | |||
Stereotype | |||
} | |||
object Attribute { | |||
Name | |||
Type | |||
Scope | |||
} | |||
object Operation { | |||
Name | |||
Type | |||
} | |||
object Parameter { | |||
Name | |||
Type | |||
Pos | |||
} | |||
object Association { | |||
Name | |||
SourceCard | |||
DestCard | |||
} | |||
object TaggedValue { | |||
Property | |||
Value/Notes | |||
} | |||
Model "1" *-- "0..*" Package : packages > | |||
Package "1" *-- "0..*" Package : packages > | |||
Package "1" *-- "0..*" Class : classes > | |||
Package "1" *-- "0..*" Association : associations > | |||
Class "1" *-- "0..*" Attribute : attributes > | |||
Class "1" *-- "0..*" Operation : operations > | |||
Operation "1" *-- "0..*" Parameter : parameters > | |||
Class "1" *-- "0..*" TaggedValue : taggedValues > | |||
Attribute "1" *-- "0..*" TaggedValue : taggedValues > | |||
Operation "1" *-- "0..*" TaggedValue : taggedValues > | |||
Association "1" *-- "0..*" TaggedValue : taggedValues > | |||
note right of Model | |||
Root packages from t_package | |||
WHERE Parent_ID = 0 | |||
end note | |||
note right of Package | |||
Nested packages via | |||
Parent_ID foreign key | |||
end note | |||
note right of Association | |||
From t_connector filtered | |||
by Connector_Type | |||
Ownership simulated via: | |||
Package → Object → Connector | |||
using Start_Object_ID | |||
end note | |||
note bottom of TaggedValue | |||
Comes from different tables | |||
depending on parent type: | |||
- Class: t_objectproperties | |||
- Attribute: t_attributetag | |||
- Operation: t_operationtag | |||
- Association: t_connectortag | |||
end note | |||
</uml> | </uml> | ||
Latest revision as of 06:31, 13 February 2026
Links
- https://en.wikipedia.org/wiki/Enterprise_Architect_(software)
- https://www.sparxsystems.de/enterprise-architect/
Database Schema
Core Tables
Logical Schema