Messages

1

General Board / Relations between database tables

« on: April 06, 2004, 12:48:29 pm »

  Hi all.
I use FireBird/InterBase database, where relations between tables are based on triggers. I have made a database model in EA importing DLL from ODBC a added associations as FKs. Problem is when I want to synchronize with actual db, FKs disappear. I now it's logical behaviour, but is there any way how to retain relations?
Thanks for any suggestion.

2

General Board / Re: Different views

« on: March 27, 2004, 02:35:58 pm »

Oh, seems have sold it already...

3

General Board / Different views

« on: March 27, 2004, 02:07:56 pm »

  Hi all,
our three projects use the same database. But there are several tables which belongs just to one project. I'd like to have one data model for all these projects, because it's easier to keep changes up to date just in one data model than three or more similar.  But I'd like to have an option to see tables which belong to one project and other projects' tables not.  I mean something like layers in PhotoShop. Could anyone suggest the best way how to achieve this?
I tried to have 'base tables' in one diagram and this diagram I dropped into another with other tables, but then  I couldn't model relations between tables in separate diagrams.

Thanks for any helpful hints.