Book a Demo

Author Topic: How to create pseudo foreign keys in database model diagram  (Read 3380 times)

babdev

  • EA User
  • **
  • Posts: 31
  • Karma: +0/-0
    • View Profile
How to create pseudo foreign keys in database model diagram
« on: January 18, 2017, 02:06:40 am »
Hi

I am currently documenting an existing database schema in EA where some of the relationships between tables are not enforced in the schema, they are instead enforced in the code. The code is not documented to that level of detail so what I'd like to do is add in foreign key constraints between tables in a way that won't cause them to be included when generating DDL. In effect, I'm looking to create a pseudo foreign key that can be distinguished from a genuine foreign key in diagrams and be excluded from generated DDL. Any ideas on how I might be able to do this?

Thanks

Mike