Provide your own table and column aliases, and relationship names. Relationship Properties shows how individual join conditions of selected connectors propagated to define the new chain. A new derived chain relationship appears here between Customers and Suppliers, to give you all suppliers who delivered the orders for each customer. Easily create custom chain relationships, without actually changing the connected database at all! Create the chain from two or more selected connectors. Visualize and customize your linked columns.īuilt-in chains are automatically created for any many-to-many relationship, bypassing the intersection table. Enhance it by dragging another table column over another. Move the mouse over connectors, shapes and items, to highlight all related elements.Įasily enhance your model with custom joins, without actually changing the connected database at all! Drag one table column over another to start creating a custom join. These diagram types outline the degree of connectivity between tables, through relationships.Įxpand relationships into connectors with simple drag and drop of generated relationship items. Collapse connectors back by simply removing them from the diagram. Connectors are straight lines and show no other details.
Shapes have been collapsed and rendered transparent. Combine the reduced but powerful set of diagram options, to generate all sorts of effects.Ĭustomize a large number of simplified generated models, such as the Simple, Topological, or Graph model here. Replace physical data types with short conceptual types (numeric, string, datetime).Ĭustomize a large number of rich generated models, such as the Detailed, Structural, or Relationships model here.
Bypass intersection tables and show conceptual many-to-many connectors between shapes. Hide, collapse or minify table/view shapes. Generic support for dozens of relational database platforms, including Oracle, SQL Server, PostgreSQL, MySQL, Azure, Amazon Redshift, SQLite and Firebird. One-time reverse engineer, to extract information about database tables, views, columns and relationships. Hide intersection tables and show virtual many-to-many connectors between the other shapes Provide your own alternative aliases for any table and column name, without changing the database at all Virtual relationships between tables, without actually changing the databaseīypass two or more chained relationships with one single virtual join With a generic graphical interface, and auto-generated detailed, structural, relationships, simple, graph or topological models' and is an app in the Development category. Relationships are distributed as items on each of the participating shapes drag them out to simply display as connectors Model Xtractor is described as 'Free visual data modeling inspection tool for most popular one-way reverse-engineered relational databases. Simple topologies or graphs, for large numbers of database tables Customize new or extracted ER database models, in traditional Foot Crow's or IDEF1X notationĮxplore and customize ER models enhanced with new features and notations (see below)Ĭollapsed and minimized shapes, expandable relationship items, many-to-many relationships and plenty of other original features you'll find nowhere else