Inside Enterprise Architect

If you ever wondered what happens behind the scenes in Enterprise Architect you should have a look into this book. It's the prefect map for the twisty little passages, all alike in EA. Beware that this edition is periodically reedited unchanged. Table of Contents Preface Copyright and Disclaimer Accessing the Database Inspecting EA's Tables Ways to Query Tables A List of All Tables Most Important Tables More things than you find in the Project Browser: t_object The Repository Structure: t_package The Diagram Frame: t_diagram Elements Inside Diagrams: t_diagramobjects Non-Standard Connectors: t_diagramlinks Connecting Elements: t_connector Element Feature Tables Attributes: t_attribute Operations: t_operation Tagged Value Tables Element Tagged Values: t_objectproperties Attribute Tagged Values: t_attributetag Operation Tagged Values: t_operationtag Connector Tagged Values: t_connectortag Security Related Tables Settings: t_secpolicies Users: t_secuser Groups: t_secgroup Assignment of users to groups: t_secusergroup Group permissions: t_secgrouppermission User permissions: t_secuserpermission Locks: t_seclocks Rarely Used Tables Stereotypes: t_stereotypes Not the Tagged Values: t_taggedvalue Attribute Constraints: t_attributeconstraints Table Attribute Tags: t_attributetag Linked Documents and Baselines: t_document Mixed option: t_genopt Alternate Images: t_image User Defined Scripts: t_script Element Requirements: t_objectrequires Element Constraints: t_objectconstraints Element Files: t_objectfiles Scenarios for (mainly) Use Cases: t_objectscenarios Parameters for Operations: t_operationparms Various Profiles: t_trxtypes Status Types: t_lists Maintenance: t_objectproblems Various Profiles: t_xrefsystem RTF: t_rtf Repository Settings: usys_system Auditing: t_snapshot Marvelous References A simple table: t_xref Definition of Multi-Stereotypes Default Composite Diagrams Profile file locations API Cross References t_package — EaPackage t_object — EaElement Bits and Pieces CSV Lists Object Types What is an Instance Concurrency GUID Object Run State Property TPos Property Object StyleEx Property Package Flags Property Diagram PDATA Property Diagram Swimlanes Property Diagram StyleEx Property DiagramObject ObjectStyle Property Connector SubType Property Connector Direction Property Connector PDATA5 Property Connector StateFlags Property Connector StyleEx Property Binary Data RGB Values Boundaries and Placeholders User Settings Registry APPDATA PROGRAMFILES Multiple EAs in Parallel GUI References Element Diagram Diagram Element Context Connector Attributes Operations Miscellaneous Query Caveats Debugging SQL SQL Search Builder Search Results Search Tagging Some Sample Queries Combine Script with Search Further Reading Feedback Scripting Enterprise Architect Sparx Forum Sparx Community SQL in General Geert Bellekens