RE: [binarycloud-dev] entity definition format

[Andreas A. <a.a...@th...>]

Hi,

> > > Another question. Can a entity span say parts of one or more tables?
> > > Something similar like a view in SQL?
> > "Sort of"
> > you can embed entity references (called pointers) in entity definitions.
> >
> > so you can say:
> >
> > user_id
> > user_name
> > user_password
> > address_id -> address
> >
> > i.e. "get the address entity with this id"
> Yep.

OK, will that work for the 4NF ?

i.e. "get all interest names for user with this id"

user_id
user_interests -> userinterests

userinterests:
user_id
interest_id-> interests

interests:
interest_id
interest_desc


[entities that span tables/part of tables]
> It does support that; you have to specify the joins in a
> hierarchical array structure in the entity definition (that syntax could
> use some rethinking
> before we release as it was imported from an earlier abstraction
> layer). I can supply an example entity definition if there is interest.

Oh yes, please.

Andi