Querying backup question, generalisation

0
Hi all,  I am investigating an issue and have a copy of my database restored locally.    In my app PMR.Recipets generalises to system.image, which generalises to system.filedocument   When I query the data base for each of these, will they have the same id? These queries all return a row, but are they all part of the same object?    SELECT * FROM pmr$receipts WHERE id = 96827392346640575 SELECT * FROM system$image WHERE id = 96827392346640575 SELECT * FROM system$filedocument WHERE id = 96827392346640575   I suppose the question is, are the entity id unique across all tables and thus these are all the same object.
asked
1 answers
0

Hi Garion,

 

For generalizations & specializations, the generalization attribute values are stored in the generalization table and the specialization attribute values stored in the specialization table. Both the generalization and specialization will have the same object ID. The object ID value is dictated by the specialization object.

 

So to answer your question, they are all the same object, the "location" of the values is just split out over the different tables, depending on which entity contains the attribute.

 

Hope it helps!

answered