Re: Database organization questions

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