Re: Database organization questions

What I think I am going to do is design the table structure for my db and
then use a trigger to update the otrs tables(kept separate) when necessary.
If I mixed the tables then I could potentially run into issues when I do an
upgrade of otrs or if I need to change something on my end down the line.
Keeping them separate seems to make more sense to me right now.

On Fri, Jun 24, 2011 at 8:15 PM, Joshua Tolley <eggyknap(at)gmail(dot)com> wrote:

> On Thu, Jun 16, 2011 at 08:50:30AM -0400, matty jones wrote:
> > I am going to be setting up OTRS, a help desk application, and the
> backend
> > is going to be Postgres, along with this I need to create
> > a separate application to track whether or not a customer has a service
> > contract with us and the type of service contact. The question I have is
> > that the service application will have a table that stores the customer's
> > contact information, and OTRS also has this table, is there a way I can
> > share this table between these two applications?
>
> Do the two applications have the same concept for this table? In other
> words,
> do they both expect the same table structure, field names, data types,
> field
> order, indexing, etc.? If not, it will be pretty tough to get them to share
> the table.
>
> --
> Joshua Tolley / eggyknap
> End Point Corporation
> http://www.endpoint.com
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
>
> iEYEARECAAYFAk4FKK0ACgkQRiRfCGf1UMPvfACeJTmnF2cYYIK3e0uutXjXxR5a
> L10AoJxAIRr9mYGDsuSVNocbjMCCQa31
> =XUCW
> -----END PGP SIGNATURE-----
>
>