Skip to main content
Back
Ellie.ai TeamUpdated Release Notes

Ellie 8.6: Reusable Physical Entities

Ellie 8.6 brings reusable physical entities, a reworked foreign key workflow with Draft FKs and a new constraint editor, and relocates DDL export to its own menu.

Dark blue Ellie 8.6 release graphic reading Reusable Physical Entities, with four glowing hexagonal layers labeled Conceptual, Logical, and Physical

Abstract

Ellie 8.6 introduces reusable physical entities, enabling consistent definitions across physical models, faster design, zero-touch updates, and built-in governance. This update also brings a significant change to foreign key handling, making physical modeling more precise and database-ready, and moves DDL export to its own menu. Upcoming features include reusable relationships and larger modeling constructs.

Ellie 8.6 introduces a major step forward in ellie.ai's asset reusability: reusable physical entities. Now your governed entities flow seamlessly from conceptual to logical — and finally into the physical layer.

Why this matters

Entity right-click menu on a physical invoice entity showing Edit, Add to glossary, Replace, Copy attributes, Entity type, and Delete options, with customer linked via a foreign key
Search or Create Entity dropdown showing an invoice entity listed under Current glossary
  • One definition, everywhere – customer, invoice, or campaign tables stay consistent across all physical models.
  • Faster design – drag a glossary entity straight onto the physical canvas.
  • Zero-touch updates – change once, propagate everywhere. Especially useful for no longer need to copy-paste attributes
  • Governance built-in – ownership, version history, and permissions travel with the folder that entities are.

We Made a Big Change to Foreign Keys

In conceptual and logical models, a foreign key is just an attribute flag.

In the physical layer this changes completely:

  • FK attributes are converted into Draft FKs. Draft FKs instruct you about whether to take the attribute into FK constraint (relationship) or not.
  • FKs defined in other levels can be used as a guide when creating the real FK constraints
  • The new Foreign Key Constraint Editor guides you in finalizing constraints.

This is a fundamental shift that makes physical modeling database-ready and far more precise.

Export the DDL has been move under its own menu item

Now it's easier to find, generates database-ready scripts, and reflects your finalized reusable entities and FK constraints.

Model toolbar with the reusable-entities database icon highlighted next to history, share, and info icons

What's Next

  • Reusable relationships are just around the corner — powered by our new relationship editor.
  • After that, we'll move on to re-using even larger modeling constructs for whole-design acceleration.

💡 With Ellie 8.6, reusable entities now span conceptual, logical, and physical levels. And with the new FK handling, physical modeling has never been stronger.

Ellie.ai Team

Ellie.ai

The team behind Ellie, writing about semantic data modeling, enterprise data architecture, and building the backbone for trustworthy AI.