Re: Design Question: Keys using multiple Databases

This is a multi-part message in MIME format. --------------87B5CE8FD25F0E2626FA3F38 Content-Type: multipart/alternative; boundary="------------B3412DE40270DFDE965D4DAA" --------------B3412DE40270DFDE965D4DAA Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jens: You could define synonyms in the private databases referencing to the general database. These synonyms could be referenced by the depending tables as you do with any particular table. example: CREATE SYNONYM <synonym_name> FOR TABLE <general_database:table_name> good luck! Jens Ebert wrote: > We are a team who is developing database applications with Informix-Online > 7.23. > We are looking for Informix-Developers with experience in Informix who > help us to find a solution for our problem. > > We are designing multiple databases. We intend to design a > database with general (static) tables, that are used from several of our > applications. Beside this database, each application owns one private. > > The tables in the private databases have associations with tables in the > general database. This would mean that we need foreign-keys that span two > databases: The primary key of tables in the general database should be a > foreign key for tables in the private database. > > We would appreciate any idea how we can implement this concept without > loosing the > primary/foreign-key relationship. > > Thank you, > Jens --------------B3412DE40270DFDE965D4DAA Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit <HTML> Jens: <P>You could define synonyms in the private databases referencing to the general database. These synonyms could be referenced by the depending tables as you do with any particular table. <P><TT>example:</TT><TT></TT> <P><TT>CREATE SYNONYM &lt;synonym_name></TT> <BR><TT>&nbsp;&nbsp;&nbsp; FOR TABLE &lt;general_database:table_name></TT> <P>good luck! <P>Jens Ebert wrote: <BLOCKQUOTE TYPE=CITE>We are a team who is developing database applications with Informix-Online <BR>7.23. <BR>We are looking for Informix-Developers with experience in Informix who <BR>help us to find a solution for our problem. <P>We are designing multiple databases. We intend to design a <BR>database with general (static) tables, that are used from several of our <BR>applications. Beside this database, each application owns one private. <P>The tables in the private databases have associations with tables in the <BR>general database. This would mean that we need foreign-keys that span two <BR>databases: The primary key of tables in the general database should be a <BR>foreign key for tables in the private database. <P>We would appreciate any idea how we can implement this concept without <BR>loosing the <BR>primary/foreign-key relationship. <P>Thank you, <BR>Jens</BLOCKQUOTE> &nbsp;</HTML> --------------B3412DE40270DFDE965D4DAA-- --------------87B5CE8FD25F0E2626FA3F38 Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Melvin Perez Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Melvin Perez n: Perez;Melvin org: CAM Informatica. S. A. email;internet: cam@codetel.net.do title: Technical Vicepresident tel;work: (809) 686-5574 tel;fax: (809) 686-5467 tel;home: (809) 227-2893 x-mozilla-cpt: ;-960 x-mozilla-html: FALSE version: 2.1 end: vcard --------------87B5CE8FD25F0E2626FA3F38--