Re: Inhomogeneous data in a database

Alex: On Wed, Apr 15, 2015 at 11:27:41PM +0200, Alex Becker wrote: > Hi! Hello, > Thank you for your feedback. I also asked some colleagues about > it. We agreed that the view approach would be the nice thing. > > However, I do not know if I did it the right way / if I > understood t correctly.

Re: Inhomogeneous data in a database

On Thu, Apr 16, 2015 at 10:56:22AM -0400, Brandon McCaig wrote: > /*or use foreign key if you wish*/ "content" AS target_type, Doh! That should have been the same as the second part of the union: > b.target_type_id AS target_type, Regards, -- Brandon McCaig Castopulence Software

SV: Inhomogeneous data in a database

Oh yes, Brandon read my mind. That was what I meant. Think of the view "navigation" as an abstraction layer for your data, rather than it containing the data. That is one of the pros for views: You can abstract your complex, but robust data model beneath them and you don't have to care about t